Confidence Intervals & Hypothesis Testing

(I am checking my work to make sure I calculated and used correct formulas in excel, so please provide step by step break down of excel process.)

Question

Perform analysis on satisfaction based on frequency of visit variable. At 5% significance level, test the hypothesis that those who visit dining facility daily are less satisfied than those who don't visit facility daily. In the answers provide test statistics, p value and conclusion. Use subscript 1 for daily visitor and 2 for those who don't visit dining facility daily.

Refer to this table for assistance:

	Satisfaction
Frequency of visit	Mean	SD
Daily	2.96	1.098
Not Daily	3.432	0.765

And this data:

Overall satisfaction	Frequency of visit		For overall satisfaction
4	5		1 = Very unsatisfied
4	4		2 = Somewhat unsatisfied
3	1		3 = Neither unsatisfied nor satisfied
5	1		4 = Somewhat satisfied
4	1		5 = Very satisfied
3	4
4	1
3	4		For frequency of visit
4	5		1 = Daily
4	3		2 - 5 = Not Daily
3	5
3	3
4	5
1	1
5	5
2	1
3	4
3	5
4	3
1	1
3	1
2	1
3	1
2	5
3	2
3	5
3	2
1	1
2	1
4	3
3	5
3	3
4	2
4	3
4	1
4	1
4	1
3	2
3	1
2	3
3	1
3	5
4	1
4	1
3	1
2	2
3	2
4	3
5	5
4	1
4	2
5	2
3	2
3	5
3	1
3	5
4	5
3	3
4	2
2	1
3	1
2	1