An analyst wonders if the age distribution of customers coming for service in town is the same as at the mall branch.

He selects 100 transactions at random from each branch and researches the age information for the associated customer. These are the data :

Age

< 30

30 - 55

56 +

Totals

Distribution

In town

24

37

39

100

mall

29

49

20

98

Totals

53

86

59

198

Enter your answers or calculations in the yellow cells.

Write the null hypothesis regarding bank locations in town and mall branch.

H0: The age distribution of customers coming for service in town is the same as at the mall branch.

Which type of test is required (goodness of fit, independence, homogeneity)?

Homogeneity

Compute

Age Groups

< 30

30 - 55

56 +

Expected (E)

In town

mall

Age Groups

< 30

30 - 55

56 +

(O - E)2/E

In town

mall

What is the chi square test statistic? Note: =CHISQ.TEST does not compute the chi-squared test statistic. It computes p-value.

What is the degrees of freedom of the chi-squared test statistic?

Use Excel to compute the critical value at alpha = 0.05.

State your decision about H0 with the significance level.

Are the bank distributions the same (Yes/No)?