I NEED HELP UNDERSTANDING HOW TO SOLVE THIS PRACTICE QUESTION ON EXCEL:

NEED STEP BY STEP PROCESS ON EXCEL PROGRAM

An analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as at a branch located near the mall. He selects 100 transactions at random from each branch and researches the age information for the associated customer. These are the data :

		Age
	less than 30	30-55	56 or older	Total
In town	25	37	38	100
mall	30	48	22	100
Total	55	85	60	200

-What is the null hypothesis if you want to check if the age patterns of customers are independent of bank location?

-What are the expected numbers for each cell in a 3 by 3 table if the null hypothesis is true?

-Use the chi square test to accept or reject the null hypothesis. What is the chi square test statistic?

-What is the chi square critical value and how many degrees of freedom does it have? Assume alpha is .05.

-What do you conclude?