Question: 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
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 a MS Excelspreadsheet. 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts