Purpose and Overview Descriptive statistics consists of techniques used to

Purpose and Overview
<
Descriptive statistics consists of techniques used to summarize a set of data. In a sense, we are using the data on members of a set to describe the set. We can do this via graphs and/or tables. After we take a look at the frequencies of our data, we need to choose a statistical test that shows how each of the units (individual subjects) seem similar. Thus, we use the measures of central tendency. This gives us an overview of the sample, which should give us an understanding of the population it represents.
<
<
The purpose of this assignment is for students to:
<
<
Begin development of a spreadsheet that represents a sample of 20 participants responding to the first five questions from the Math Anxiety Questionnaire in Module 1
<
Develop a bar graph.
<
Directions
<
Last week, you all completed the Math Anxiety Questionnaire and shared your results. This week, we will begin the lopment of a spreadsheet that represents a sample of 20 participants responding to the first five questions from the Math Anxiety Questionnaire. The first column is ID (which is a coding that refers to the individual participant), the next two columns are sex and age of these participants and the remaining columns are coded as variables that represent the first five questions from the Math Anxiety Questionnaire.
<
<
Step One: Using this fictitious data enter the data into an excel spreadsheet. This can be copied and pasted into the MS Excel™ spreadsheet.
<
<
<
ID
<
<
Sex
<
<
Age
<
<
Cringe*
<
<
Uneasy*
<
<
Afraid*
<
<
Worried*
<
<
Understand*
<
<
1
<
<
M
<
<
28
<
<
5
<
<
3
<
<
4
<
<
4
<
<
3
<
<
2
<
<
F
<
<
34
<
<
2
<
<
5
<
<
3
<
<
2
<
<
1
<
<
3
<
<
F
<
<
25
<
<
4
<
<
4
<
<
4
<
<
2
<
<
5
<
<
4
<
<
M
<
<
56
<
<
3
<
<
4
<
<
3
<
<
1
<
<
2
<
<
5
<
<
M
<
<
23
<
<
5
<
<
4
<
<
3
<
<
3
<
<
4
<
<
6
<
<
F
<
<
29
<
<
1
<
<
5
<
<
3
<
<
2
<
<
3
<
<
7
<
<
F
<
<
30
<
<
3
<
<
3
<
<
5
<
<
2
<
<
5
<
<
8
<
<
F
<
<
59
<
<
2
<
<
5
<
<
5
<
<
1
<
<
2
<
<
9
<
<
M
<
<
45
<
<
4
<
<
2
<
<
5
<
<
3
<
<
3
<
<
10
<
<
F
<
<
38
<
<
1
<
<
2
<
<
4
<
<
1
<
<
1
<
<
11
<
<
M
<
<
33
<
<
3
<
<
2
<
<
4
<
<
3
<
<
2
<
<
12
<
<
M
<
<
47
<
<
4
<
<
2
<
<
3
<
<
4
<
<
5
<
<
13
<
<
F
<
<
24
<
<
1
<
<
5
<
<
3
<
<
4
<
<
4
<
<
14
<
<
M
<
<
29
<
<
5
<
<
4
<
<
2
<
<
1
<
<
3
<
<
15
<
<
M
<
<
53
<
<
3
<
<
1
<
<
5
<
<
2
<
<
1
<
<
16
<
<
F
<
<
48
<
<
4
<
<
4
<
<
1
<
<
5
<
<
3
<
<
17
<
<
F
<
<
27
<
<
2
<
<
5
<
<
4
<
<
3
<
<
4
<
<
18
<
<
F
<
<
34
<
<
4
<
<
4
<
<
3
<
<
2
<
<
5
<
<
19
<
<
M
<
<
26
<
<
4
<
<
5
<
<
2
<
<
3
<
<
2
<
<
20
<
<
M
<
<
36
<
<
5
<
<
5
<
<
5
<
<
4
<
<
3
<
<
*(Scores range from 1=Disagree to 5=Agree)
<
<
Step Two: After you have entered the data, develop a bar graph for ONE of the following variables.
<
<
Cringe
<
Uneasy
<
Afraid
<
Worried
<
Understand
<
Be sure you label each axis as well as provide a name for your graph.
<
<
Step Three: Name the different levels of measurement of each of the variables on the Math Anxiety dataset as either Ordinal, Nominal, Interval, or Ratio data. Describe what each of the four terms mean. You may type this directly on the MS Excel™ spreadsheet.
<
<
<
Please note: All students are required to have Microsoft Office 2007 or greater. (Please see the Student Handbook.)
<
<
Label all files using the following naming convention.
<
<
Last Name_Initial First Name_Assignment Week and Number
<
Example: Morse_G_WA2
<
<
Submit your MS Excel™spreadsheet and your bar graph using the Submission link.