Assignment:
Inferential Practice Problems Part 1: Use the Excel Analysis ToolPak? when necessary for the following:
1. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, and/or Ratio). Some variables can be more than one type.
a. Name
b. Gender
c. Absences
d. Physical Education (PE)
e. Math
f. Writing
g. Reading
2. Determine the number of boys and girls in the class and create a bar graph or pie chart to display the information.
3. Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.)
4. Calculate how much of the math grade can be explained by the PE grade? How much of the writing grade can be explained by the reading grade?
Standard Test Scores
Name Gender Absences PE Math Writing Reading
Alex Boy 5 49 85 86 80
Anthony Boy 18 51 39 71 75
Douglas Boy 1 82 74 78 79
Jorge Boy 4 56 66 68 60
Joshua Boy 5 83 79 78 77
Luke Boy 0 94 89 84 84
Robert Boy 17 36 36 56 50
Rupert Boy 4 24 55 56 52
Seth Boy 0 61 92 89 83
Wayne Boy 1 65 92 96 91
Blair Girl 3 94 59 66 90
Brooke Girl 2 75 35 43 46
Carmen Girl 0 49 91 91 90
Charlita Girl 16 23 49 55 49
Kim Girl 2 71 90 92 95
Li Girl 1 73 98 93 95
Rachel Girl 2 92 87 92 91
Sara Girl 3 33 87 93 94
Sheetal Girl 0 18 100 97 97
Tawayna Girl 14 31 65 55 63