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,

371 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.

Age_Group	Site_A	Site_B	Site_C
2–17	22	16	4
18–34	125	20	12
35–54	98	16	18
55+	29	3	8

a. Using

alphaαequals= .05​,

perform a​ chi-square test to determine if age group and social networking site used are independent of one another.

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

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

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

I'm really struggling figuring this out. Can someone help and explain how you got the answers using excel?

Answer 1

Tabulated Statistics: Age_Group, Worksheet columns

Rows: Age_Group   Columns: Worksheet columns

	Site_A	Site_B	Site_C	All
2–17	22	16	4	42
Expected count	31.02	6.23	4.75
18–34	125	20	12	157
Expected count	115.95	23.27	17.77
35–54	98	16	18	132
Expected count	97.49	19.57	14.94
55+	29	3	8	40
Expected count	29.54	5.93	4.53
All	274	55	42	371

Cell Contents
      Count
    

Chi-Square Test

	Chi-Square	DF	P-Value
Pearson	26.524	6	0.000

2 cell(s) with expected counts less than 5.

=================================================

=======================================

Use Excel function(CHIINV(0.05,4)

========================================

P-value = 0.0000

========================================