Question

Suppose a marketing research firm would like to examine if the social networking site that a person primarily uses is influenced by his or her age. In a randomly drawn​ sample, 361 social network users were asked which site they primarily visited. These data are presented in the following table along with each​ person's age group. Complete parts a. through c. below. Alpha = .05

Social Networking Site

Age_Group	Site_A	Site_B	Site_C
2–17	27	16	1
18–34	110	25	11
35–54	97	19	18
55+	27	3	7

A). (If possible, please show how to do these problems using excel.)

Calculate the​ chi-square test statistic. If​ necessary, combine age groups.

​(Round to two decimal places as​ needed.)

B).

Find the​ chi-square critical​ value, χ2α.

​(Round to two decimal places as​ needed.)

C).

Determine the result of the test. Choose the correct answer below.

A.

RejectReject

Upper H 0H0.

The test statistic

fallsfalls

into the rejection region.

B.Reject

Upper H 0H0.

The test statistic does not fall into the rejection region.

C). What conclusions can be made based on these results?

D). Determine the​ p-value using technology and interpret its meaning.

E). Interpret the meaning of the p-value

The p value is the probability of observing ____ as extreme or more extreme than the one observed under the assumption that the _____ is true. A p-value is less than the significance level alpha means that the ____ is ______ enough that the ____ should be rejected. For this test the p value is _____ alpha=.01, so ______ the ______. There is ____ evidence to indicate ____________________________.

Answer 1

Sorry, I don't have any software so, not able to solve D & later E part.

Rest parts are solve.

Age gp	site A	site B	site C	Total
02 to 17	27	16	1	44
18-34	110	25	11	146
35 - 54	97	19	18	134
55 +	27	3	7	37
Total	261	63	37	361

Contingency table is calculated below :

Row	Col	fo	fe	fo-fe	(fo-fe)^2	((fo-fe)^2/fe)
1	1	27	32	-5	23	0.728
1	2	16	8	8	69	9.018
1	3	1	5	-4	12	2.731
2	1	110	106	4	20	0.187
2	2	25	25	0	0	0.009
2	3	11	15	-4	16	1.050
3	1	97	97	0	0	0.000
3	2	19	23	-4	19	0.822
3	3	18	14	4	18	1.325
4	1	27	27	0	0	0.002
4	2	3	6	-3	12	1.851
4	3	7	4	3	10	2.713
						20.437

X2 ( Chi-square ) = 20.437