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 %

Answer 1

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