Question
Expert Chardonnay Cabernet_Sauvignon 1 17.8 16.6 2 18.6 19.9 3 19.5 17.2 4 18.3 19.0 5 19.8 19.7 6 19.9 18.8 7 17.1 18.9 8
Expert | Chardonnay | Cabernet_Sauvignon | ||
1 | 17.8 | 16.6 | ||
2 | 18.6 | 19.9 | ||
3 | 19.5 | 17.2 | ||
4 | 18.3 | 19.0 | ||
5 | 19.8 | 19.7 | ||
6 | 19.9 | 18.8 | ||
7 | 17.1 | 18.9 | ||
8 | 17.3 | 19.5 | ||
9 | 18.0 | 16.2 | ||
10 | 19.8 | 18.6 |
**ANSWERS IN EXCEL OR GOOGLE SHEET** please.
A group of experts has rated a leading WA winery's two best wines (Chardonnay and Cabernet Sauvignon). Ratings are on scale from 1 to 20, with higher numbers being better. We would like to compare these wine ratings to see which wine is actually better. The ratings are shown in the Excel file (table above).
1. To test this claim, should you conduct a two independent sample analysis or a paired samples analysis? Why?
2. Run a hypothesis test to determine if the different in wine ratings is statistically significant difference. Please state your hypothesis, conduct the hypothesis test, and interpret the results. Does the significance level (10%, 5%, or 1%) matter for this test?1
3. Bonus question (not for points but need to attempt): Create a 95% two-sided confidence interval for the average difference in rating. Provide a brief interpretation of your confidence interval2.
---
1 At 5% level of significance, we reject/failed to reject the null hypothesis that ... , which means that ... .
2 We are 95% sure that the true difference in the wines' ratings is between ... and ... .
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started