Question

Marital Status and Drinking

	Drinks per Month
Marital Status	Abstain            1-20	20-40          40-60       over 60
Single	67                 230	84               96              87
Married	411                 633	149            85               102
Widowed	85                    61	17            90              89
Divorced	47                     90	25            102             156

Perform a hypothesis to decide whether there is an association between marital status and alcohol consumption.

Answer 1

Solve using Excel in the following manner:

	ACTUAL
	Abstain	1-20	20-40	40-60	Over 60	Total
Single	67	230	84	96	87	564
Married	411	633	149	85	102	1380
Widowed	85	61	17	90	89	342
Divorced	47	90	156	25	102	420
Total	478	863	233	181	189	1944
	EXPECTED
	Abstain	1-20	20-40	40-60	Over 60		FORMULA FOR EXPECTED VALUE
Single	138.68	250.38	67.60	52.51	54.83		=(B$7*$G3)/$G$7	=(C$7*$G3)/$G$7	=(D$7*$G3)/$G$7	=(E$7*$G3)/$G$7
Married	339.32	612.62	165.40	128.49	134.17		=(B$7*$G4)/$G$7	=(C$7*$G4)/$G$7	=(D$7*$G4)/$G$7	=(E$7*$G4)/$G$7
Widowed	84.09	151.82	40.99	31.84	33.25		=(B$7*$G5)/$G$7	=(C$7*$G5)/$G$7	=(D$7*$G5)/$G$7	=(E$7*$G5)/$G$7
Divorced	103.27	186.45	50.34	39.10	40.83		=(B$7*$G6)/$G$7	=(C$7*$G6)/$G$7	=(D$7*$G6)/$G$7	=(E$7*$G6)/$G$7
	CHI-SQUARE
	Abstain	1-20	20-40	40-60	Over 60		FORMULA FOR CHI-SQUARE
Single	37.05	1.66	3.98	36.01	18.87		=(B3-B11)^2/B11	=(C3-C11)^2/C11	=(D3-D11)^2/D11	=(E3-E11)^2/E11
Married	15.14	0.68	1.63	14.72	7.71		=(B4-B12)^2/B12	=(C4-C12)^2/C12	=(D4-D12)^2/D12	=(E4-E12)^2/E12
Widowed	0.01	54.33	14.04	106.22	93.48		=(B5-B13)^2/B13	=(C5-C13)^2/C13	=(D5-D13)^2/D13	=(E5-E13)^2/E13
Divorced	30.66	49.89	221.78	5.09	91.63		=(B6-B14)^2/B14	=(C6-C14)^2/C14	=(D6-D14)^2/D14	=(E6-E14)^2/E14
Test statistic	804.57	=SUM(B18:F21)
p-value	0.000	=CHISQ.TEST(B3:F6,B11:F14)

H0: There is no association between marital status and alcohol consumption

H1: There is an association between marital status and alcohol consumption

Test statistic = 804.57

Degrees of freedom = (Rows-1)*(Columns-1) = (4-1)*(4-1) = 9

Level of significance = 0.05

p-value = 0.000

Since p-value is less than 0.05, we reject the null hypothesis.

So, there is an association between marital status and alcohol consumption.