Question
Confidence Intervals & Hypothesis Testing (I am checking my work to make sure I calculated and used correct formulas in excel, so please provide step
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started