Statistics for Business & Economics, Revised (MindTap Course List)
Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 16, Problem 2CP

Rating Wines from the Piedmont Region of Italy

Wine Spectator magazine contains articles and reviews on every aspect of the wine industry, including ratings of wine from around the world. In a recent issue they reviewed and scored 475 wines from the Piedmont region of Italy using a 100-point scale (Wine Spectator, April 30, 2011). The following table shows how the Wine Spectator score each wine received is used to rate each wine as being classic, outstanding, very good, good, mediocre, or not recommended.

Score Rating
95–100 Classic: a great wine
90–94 Outstanding: a wine of superior character and style
85–89 Very good: a wine with special qualities
80–84 Good: a solid, well-made wine
75–79 Mediocre: a drinkable wine that may have minor flaws
below 75 Not Recommended

A key question for most consumers is whether paying more for a bottle of wine will result in a better wine. To investigate this question for wines from the Piedmont region we selected a random sample of 100 of the 475 wines that Wine Spectator reviewed. The data, contained in the file named WineRatings, shows the price ($), the Wine Spectator score, and the rating for each wine.

Managerial Report

  1. 1. Develop a table that shows the number of wines that were classified as classic, outstanding, very good, good, mediocre, and not recommended and the average price. Does there appear to be any relationship between the price of the wine and the Wine Spectator rating? Are there any other aspects of your initial summary of the data that stand out?
  2. 2. Develop a scatter diagram with price on the horizontal axis and the Wine Spectator score on the vertical axis. Does the relationship between price and score appear to be linear?
  3. 3. Using linear regression, develop an estimated regression equation that can be used to predict the score given the price of the wine.
  4. 4. Using a second-order model, develop an estimated regression equation that can be used to predict the score given the price of the wine.
  5. 5. Compare the results from fitting a linear model and fitting a second-order model.
  6. 6. As an alternative to fitting a second-order model, fit a model using the natural logarithm of price as the independent variable. Compare the results with the second-order model.
  7. 7. Based upon your analysis, would you say that spending more for a bottle of wine will provide a better wine?
  8. 8. Suppose that you want to spend a maximum of $30 for a bottle of wine. In this case, will spending closer to your upper limit for price result in a better wine than a much lower price?
Blurred answer

Chapter 16 Solutions

Statistics for Business & Economics, Revised (MindTap Course List)

Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Statistics 4.1 Introduction to Inferential Statistics; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=QLo4TEvBvK4;License: Standard YouTube License, CC-BY