1. The operations manager of Yamaha Philippines, a musicalinstrument distributor, feels that demand for Yamaha guitarmay be related to the number of YouTube views for a musicvideo by the popular rock group Eraserheads which uses theguitar in its shows during the preceding month. The managerhas collected the data shown in the following table:YouTube Views (1,000s) Guitar Sales40507060805090100801208111210151316151418a. Graph these data to see whether a linear equation mightdescribe the relationship between the views on YouTube andguitar sales.b. Using the regression equation, interpret the Y intercept andthe slope.c. Predict guitar sales if there were 100,000 views last month.d. Determine and interpret the coefficient of determination andthe coefficient of correlation.e. Test to see if there is a statistically significant relationshipbetween YouTube views and guitar sales at the 0.05 level ofsignificance.

NOTE: We are allowed to do the first three sub-parts only. Let You tube views be x as it is the…

Answered: a. Graph these data to see whether a…

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...

See similar textbooks

Similar questions

4. The number of auto accidents in Athens, Ohio, is related to the regional number of registered automobiles in thou- sands (X1), alcoholic beverage sales in $10,000s (X2), and rainfall in inches (X3). Furthermore, the regression formula has been calculated as: Y=a+b1X1 +b2X2 +b3X3 Where Y = number of automobile accidents a = 7.5 bl = 3.5 b2 = 4.5 b3 = 2.5 Calculate the expected number of automobile accidents under conditions a, b, and c: X, X2 X, (a) 2 3 (b) 5 1 (c) 7 2 N m4
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 1 45 6. 53 2 50 7 59 3 44 59 4 51 9 64 5 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, G. MAD, and MAPE) for this forecasting procedure? How about ? Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Period Forecast, F, 10 11 12 13
Use Holt’s method to create a model that minimizes the MSE for the data set (see picture attached). Use Solver to determine the optimal values of alpha and beta. a. What are the optimal values of alpha and beta? b. What are the forecasts for the next 2 years using this technique?
Global Bikes Inc. (a bicylce manufacturing firm) collected the following data during a study of consumer buying patterns. Observation 1 2 3 4 5 6 7 y= X y 15 70 28 79 38 89 35 86 49 97 42 97 30 82 y = Observation 0.721 + 1890123 a. Create a linear regression line (equation) for the data.(Round your Intermediate calculations and final answers to 3 decimal places.) X 14 16 14 24 21 29 63.229 X y 82 70 68 84 83 91 b. Use the equation determined in part b to predict the expected value of y for x = 49. (Round your Intermediate calculations and final answers to 3 decimal places.)
Sales for the past 6 months at Dalworth Company are given in the following table: Month Sales July 52 August 61 September 53 October 35 November 31 December 28 What is the Mean Absolute Deviation (MAD) for August through December forecasts produced by using exponential smoothing with α = 0.4? (Note: Do not round the forecasts, and choose the closest answer.) Multiple Choice 39.64 8.75 15.28 11.94
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.8 2010 29.2 2011 37.9 2012 4 50.3 2013 59.8 2014 6 66.6 (a) Construct a time series plot. 80 80 70 70 70 70 60 60 50 50 50 30 30 30 30- 20 20 20 20 10 10 10 - 10- 4. 6 7 4 6 4 5 6 7 1 2. 4 6 7 Period Period Period Period What type of pattern exists in the data? O The time series plot shows an upward linear trend. O The time series plot shows a downward curvilinear trend. O The time series plot shows a downward linear trend. O The time series plot shows an upward curvilinear trend. (b) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.) T = (c) What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.) billion Revenue ($ billions) Revenue ($ billions)…
Over one year, a company sold the following numbers of lawn mowers. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales 238 220 195 245 345 380 270 220 280 120 110 85 Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December. Compute the MAD for the forecasts obtained in part (a). What effect does increasing N from 3 to 6 have on the forecasts? Use the arithmetic average of the first six months of data as a baseline to initialize the exponential smoothing. Compute the one-step-ahead exponential smoothing forecasts for July through December, assuming α = 0.20. Compare the accuracy of the forecasts obtained in part (c) with the one-step ahead six-month moving-average forecasts obtained in part (a).
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER 1 2 5678AWN 3 4 8 SALES 219 237 208 171 169 Quarter 9 10 11 12 192 157 132 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast
Which of the following methods lends itself to forecasts for long-term emerging phenomena or revolutionary technologies? A. the sales force estimate technique B. the delphi method C. the jury of executive opinion method D. market testing
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 30 48 70 90 Part 2 Using the least-squares regression LOADING... method, the trend equation for forecasting is (round your responses to two decimal places): y = enter your response here + enter your response here x Y=?+?x
After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses monthly sales as a function of average temperature for the month: Monthly sales=-202.2+86.5x (average temperature) Click the icon to view the additional data. a. Show how the a and 6 values of -202.2 and 86.5 were calculated. Calculate the slope coefficient, b (enter your responses as whole numbers). (745) 12 12 2 =86.5 More Info March 2017 April May June July August September October November December January 2018 February Monthly Sales 5,300 3,990 5,700 6,520 7,600 7,420 Print 6,710 4,870 3,990 3,900 3,320 2,670 Temperature 51 56 Done 64 80 79 87 83 67 58 41 39 40 X
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Feb Mar Apr May Jun Jul Aug Sept Oct 21 23 17 14 11 16 16 18 Nov Dec 20 20 20 24 Month Sales This exercise contains only parts b and c b) The forecast for the next month (Jan) using the naive method=sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month= sales (round your response to one decimal place) Using exponential smoothing with a = 0.30 and a September forecast of 21.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Graph these data to see whether a linear equation might describe the relationship between the views on YouTube and guitar sales. b. Using the regression equation, interpret the Y intercept and the slope. c. Predict guitar sales if there were 100,000 views last month.