Anova or regression in excel please, with step-by-step instructions and explanations. Please answer the whole question, a, b, and c. I need to check my work.

A survey measured retention with the dining facility.

a. For retention, test if there are differences in mean scores based on the year in school and gender.

b. Do male students, for a given year in school, indicate a different intention of visiting the facility compared to female students, if a new dining option becomes available? Explain how the test results help you to answer this question.

c. Why is it important to test the differences in mean scores of satisfaction based upon year in school and gender?

facility

The data:

Retention	Year in school	Gender		For Retention
1	1	2		1 = Very likely to stay with this faiclity
2	1	1		2 = Somewhat likely to stay with this facility
1	2	2		3 = Neither likely nor unlikely
1	1	2		4 = Somewhat unlikely to stay with this facility
3	1	1		5 = Very unlikely to stay with this facility
4	4	2
3	1	2
3	1	1		For year in school
3	1	1		1 = Freshman
3	1	2		2 = Sophomore
4	3	1		3 = Junior
5	1	2		4 = Senior
3	3	1
5	1	2
3	4	1		For Gender
4	2	1		1 = Male
2	4	1		2 = Female
3	3	1
3	1	1
3	4	1
4	3	1
4	2	2
4	2	1
3	2	1
3	3	1
4	2	1
4	2	1
1	2	1
5	2	1
3	4	1
2	4	2
3	4	1
3	4	1
3	4	1
3	3	1
3	3	2
3	2	1
2	2	1
3	3	1
5	4	1
3	2	2
2	2	1
3	4	1
3	3	1
3	4	1
4	4	1
3	3	1
3	2	2
2	3	1
3	4	2
3	1	1
2	4	2
1	2	1
3	1	2
3	1	2
5	1	1
3	2	1
1	3	2
3	2	1
3	4	1
3	2	2
1	3	1