NEED EXACT NUMBERS PLEASE and how to place into excel The National Sleep Foundat
ID: 3366099 • Letter: N
Question
NEED EXACT NUMBERS PLEASE and how to place into excel The National Sleep Foundation used a survey to determine whether hours of sleeping per night are independent of age (Newsweek, January 19, 2004). The following show the hours of sleep on weeknights for a sample of individuals age 49 and younger and for a sample of individuals age 50 and older. Hours of Sleep Age Fewer than 6 6 to 6.9 7 to 7.9 8 or more Total 49 or younger 39 58 76 67 240 50 or older 32 64 71 93 260 Conduct a test of independence to determine whether the hours of sleep on weeknights are independent of age. Use = .05. Use Table 12.4. Compute the value of the 2 test statistic (to 2 decimals). The p value is What is your conclusion? Using the total sample of 500, estimate the percentage of people who sleep less than 6, 6 to 6.9, 7 to 7.9, and 8 or more hours on weeknights (to 1 decimal). Less than 6 hours % 6 to 6.9 hours % 7 to 7.9 hours % 8 or more hours %
Explanation / Answer
Result:
NEED EXACT NUMBERS PLEASE and how to place into excel The National Sleep Foundation used a survey to determine whether hours of sleeping per night are independent of age (Newsweek, January 19, 2004). The following show the hours of sleep on weeknights for a sample of individuals age 49 and younger and for a sample of individuals age 50 and older.
Hours of Sleep
Age Fewer than 6 6 to 6.9 7 to 7.9 8 or more Total
49 or younger 39 58 76 67 240
50 or older 32 64 71 93 260
Conduct a test of independence to determine whether the hours of sleep on weeknights are independent of age. Use = .05. Use Table 12.4.
Compute the value of the chi square test statistic 4.59 (to 2 decimals).
The p value is 0.2046
What is your conclusion?
calculated chi square 4.59 < critical value 7.815 , Ho is not rejected.
P value method: calculated P=0.2046 which is > 0.05 level, Ho is not rejected.
We conclude that the hours of sleep on weeknights are independent of age.
Using the total sample of 500, estimate the percentage of people who sleep less than 6, 6 to 6.9, 7 to 7.9, and 8 or more hours on weeknights (to 1 decimal). Less than 6 hours % 6 to 6.9 hours % 7 to 7.9 hours % 8 or more hours %
Hours of Sleep
Age
Fewer than 6
6-6.9
7-7.9
8 or more
Total
49 or younger
39
58
76
67
240
50 or older
32
64
71
93
260
Total
71
122
147
160
500
Percentage
14.2
24.4
29.4
32.0
Chi-Square Test
Observed Frequencies
Hours of Sleep
Age
Fewer than 6
6-6.9
7-7.9
8 or more
Total
49 or younger
39
58
76
67
240
50 or older
32
64
71
93
260
Total
71
122
147
160
500
Expected Frequencies
Hours of Sleep
Age
Fewer than 6
6-6.9
7-7.9
8 or more
Total
49 or younger
34.08
58.56
70.56
76.8
240
50 or older
36.92
63.44
76.44
83.2
260
Total
71
122
147
160
500
Calculations
fo-fe
4.9200
-0.5600
5.4400
-9.8000
-4.9200
0.5600
-5.4400
9.8000
(fo-fe)^2/fe
0.7103
0.0054
0.4194
1.2505
0.6556
0.0049
0.3871
1.1543
Data
Level of Significance
0.05
Number of Rows
2
Number of Columns
4
Degrees of Freedom
3
Results
Critical Value
7.815
Chi-Square Test Statistic
4.5876
p-Value
0.2046
Do not reject the null hypothesis
Hours of Sleep
Age
Fewer than 6
6-6.9
7-7.9
8 or more
Total
49 or younger
39
58
76
67
240
50 or older
32
64
71
93
260
Total
71
122
147
160
500
Percentage
14.2
24.4
29.4
32.0
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.