Assignment:
Data for Practice Problems
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
Continue using the information from Inferential Practice Problems and determine the following using the Excel® Analysis ToolPak? when necessary:
a. Calculate all measures of central tendency for data that are interval or ratio in measurement - mean, median, mode
b. Calculate the standard deviation for data that are interval or ratio in measurement
c. Assume this is a sample of students, calculate a t-test that compares boys and girls on the number of absences (you can assume equal variances). Is there a significant difference in absences based on gender?
d. Write out 3 hypotheses related to an ARP topic of your interest that would involve a correlational test or a t-test in the analysis plan.