Applications of Chi Square Test (In excel please, and provide formula details please)

Verify whether the collected sample is reflective of the students that are enrolled in the university or visiting dining facility. a. At 90% confidence, test the hypothesis that collected sample has same proportion of freshmen, sophomore, junior, and senior students as enrolled in the university. In the answers provide test statistics, p value and conclusion.

b. At 10% significance, test the hypothesis that collected sample has same proportion of freshmen, sophomore, junior, and senior students as visiting dining facility. In the answers provide test statistics, p value and conclusion.

Please explain how to calculate test statistics and p-value. Please don't just provide the answer. Break down the calculations, please.

The data:

Enrollment statistics of the students for this semester. There are 10,000 students currently enrolled with 55% of them male students. A fairly equal number of students are freshman, sophomore, junior, and senior. Dining facility statistics show that almost 40% of their student customer are freshman, 25% are sophomore, 20% are junior, and 15% are senior. They have almost same number of male and female, and the following survey results

Year in school	Visit Frequency		For year in school
1	5		1 = Freshman
1	4		2 = Sophomore
2	1		3 = Junior
1	1		4 = Senior
1	1
4	4
1	1		For Visit Frequency
1	4		1 = Daily
1	5		2 = 2 or 3 times a week
1	3		3 = Weekly
3	5		4 = 2 or 3 times a month
1	3		5 = Once a month or less
3	5
1	1
4	5
2	1
4	4
3	5
1	3
4	1
3	1
2	1
2	1
2	5
3	2
2	5
2	2
2	1
2	1
4	3
4	5
4	3
4	2
4	3
3	1
3	1
2	1
2	2
3	1
4	3
2	1
2	5
4	1
3	1
4	1
4	2
3	2
2	3
3	5
4	1
1	2
4	2
2	2
1	5
1	1
1	5
2	5
3	3
2	2
4	1
2	1
3	1