Mark​ Gershon, owner of a musical instrument​ distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following​ table:                                                                                                            Maroon 5 TV Appearances 3 3 8 5 8 6 Demand for Guitars 2 5 6 4 11 6   This exercise contains only parts​ b, c, and d. ​b) Using the​ least-squares regression​ method, the equation for forecasting is ​(round your responses to four decimal ​places)​:   Y​ =   ​+   ​c) The estimate for guitar sales if Maroon 5 performed on TV 11 times​ =   sales ​(round your response to two decimal​ places).   ​d) The correlation coefficient ​(r​) for this model​ =   ​(round your response to four decimal​ places). The coefficient of determination ​(r2​) for this model​ =   ​(round your response to four decimal​ places).   The percentage of variation in sales that can be explained by TV appearances​ = % ​(round your response to two decimal​ places).

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Mark​ Gershon, owner of a musical instrument​ distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following​ table:
                                                                                                          
Maroon 5 TV Appearances
3
3
8
5
8
6
Demand for Guitars
2
5
6
4
11
6
 
This exercise contains only parts​ b, c, and d.
​b) Using the​ least-squares regression​ method, the equation for forecasting is ​(round your responses to four decimal
​places)​:
 
Y​ =
 
​+
 
​c) The estimate for guitar sales if Maroon 5 performed on TV 11
times​ =
 
sales ​(round your response to two decimal​ places).
 
​d) The correlation coefficient ​(r​)
for this model​ =
 
​(round your response to four decimal​ places).
The coefficient of determination
​(r2​)
for this model​ =
 
​(round your response to four decimal​ places).
 
The percentage of variation in sales that can be explained by TV appearances​ =
%
​(round your response to two decimal​ places).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.