For this assignment, use data from W1 Midweek Assignment.ATTACHED
Using Microsoft Excel and following the instructions given in your lecture, compute a one-sample t-test comparing the age of your sample to the age of the general population of college students in traditional on-ground universities. Assume the population mean is 21.
Move your Microsoft Excel output into a Microsoft Word document.
- Write 1 paragraph to explain how you located and determined the critical value of t, and how you determined whether your obtained t-statistic was significant.
- Write a 1-paragraph, APA-formatted interpretation of the results modeled on the example given in your lecture.
>Sheet , Female=1)
= (1= freshman, 2=sophomore, = junior, = senior
Year in college 0 1 18 0 1 0 1 18 0 1 0 1 20 1 .4
1 19 1 1 18 1 1 18 1 1 1 63 1 19 0 2 20 0 2 20 0 2 21 0 2 19 0 2 20 1 2 19 1 2 20 1 2 19 1 2 20 1 2 0 3 21 0 3 20 0 3 20 0 68 3 22 0 68.1 3 20 1 63.8 3 21 1 63.6 3 21 1 63.9 3 20 1 64 3 21 1 3 22 0 4 23 0 4 23 0 4 21 0 4 21 0 4 22 1 64.3 4 21 1 4 21 1 4 23 1 64.3 4 22 1 4
2
1
sex (Male=
0
Year in college
3
4
Subject ID Number
Age
Sex
Height
S1
18
67.2
S2
66.9
S3
20
67.5
S4
66.8
S5
19
67.3
S6
63
S7
63.2
S8
62.8
S9
63.6
S10
21
S11
67.8
S12
68
S13
68.1
S14
67.6
S15
67.9
S16
64
S17
63.9
S18
64.2
S19
64.3
S20
63.8
S21
22
68.3
S22
68.2
S
23
68.5
S24
S25
S26
S27
S28
S29
S30
64.1
S31
69
S32
69.1
S33
69.3
S34
68.8
S35
69.4
S36
S37
65
S38
64.8
S39
S40
64.7
