For this assignment, use data from W1 Midweek Assignment. ATTACHED
Using Microsoft Excel and following the instructions given in your lectures, compute a t-test comparing males’ and females’ heights. You must determine which type of t-test to compute (between-subject or within-subject).
Move your output into a Microsoft Word document and write a one-paragraph, APA-formatted interpretation of the results modeled on the example given in the 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