YEAR DISK DRIVES 140 2 160 3 190 heo200 5 210
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Given data is
Q: Month 1 2 3 4 5 No. of Cases 105 115 120 120 125 Month 6 7 8 9 10 No. of Cases 125 130 140 145 150…
A: Given data is
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: Week ofPints usedAugust, 31360September, 7372September, 14412September, 21381September,…
Q: Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows,…
A: Qualitative forecasting is a methodology in forecasting which primarily focuses on the judgement,…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Least square regression model consider Y=a+bx. Here, a indicating intercept and b indicating the…
Q: Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six…
A: Absolute Error = | Actual sales - Forecast | MAD = Average of Absolute Error
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Here, the question is for linear regression using the least square method. We have to find the trend…
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: to find:the forecast for October 12 month using a three-week moving averagethe forecast for October…
Q: Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using…
A: Weighted Moving Average using the weights of .8, .15, and .05 ExponA use an alpha level of .75ExponB…
Q: answer the following question
A: Find the Linear regression equation calculation below: So the a and b values are 35.00 and 1.03…
Q: a) Construct a time series plot. What type of pattern exists in the data? The data appear to follow…
A: 3-month moving average forecast = Average of the past three months' value will become the forecast…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: MonthPeriod (x) Number of Accidents (y)Jan125Feb240Mar370Apr490
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. Business…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Trend analysis is an analytical tool that is used by the organization to identify the trend as well…
Q: Answer the following questions 1. Calculate the slope for the regression line. (show all working)…
A: The simple linear regression model shows the relationship between a dependent variable and one or…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Given data is
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Least square regression is a important statistical method to find regression line. Formula Y = a +…
Q: eBook Problem 6-23 (Algorithmic) The medical community unanimously agrees on the health benefits of…
A: Year (x)Percentage of adults…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: x = number of month
Q: The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of…
A: The seasonal demand for last 4 years is given below:Forecasted demand for Year 5 = 685
Q: Assume that the initial forecast for February is 65.0 (in $ thousands) and the initial trend…
A: There are various methods of forecasting. One of the methods is the trend-adjusted exponential…
Q: brand Managemen nterested in estin ing luture sales voluf to delern y the hew bran ace it with…
A: Determine the regression equation:
Q: Sales of PQR-Cool air conditioners have grown steadily during the past 5 years: The sales manager…
A: Ans) Explanation of how forecast will be calculated using exponential Smoothing and 3 period moving…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Given data is
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: The least square regression model considers Y=a+bx. Here, "a" indicates intercept and "b" indicates…
Q: a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = .1.…
A: Forecasting is the process of predicting the future demand based on the previous data or demand.
Q: $4.10 475 sing simple linear regression and given that the price per cup is $1.80, the forecasted…
A: The simple regression model is in the form: Y=a+bX where: Y= dependent variable a= y-axis intercept…
Q: Arnold Tofu owns and operates a chain of "hamburger" restaurants in northern Louisiana. Sales…
A: 1) Using Excel: In Excel select columns of profit and sales, go to insert tab select scatter chart.…
Q: Demand for oil changes at Garcia's Garage has been as follows: Month January February March April…
A: Ans)
Q: are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12…
A:
Q: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS…
A: Most Recent Quarter = 0.50 Second most recent Quarter = 0.25 Third most recent Quarter = 0.25
Q: Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to…
A: Given that: Employees Salary 28 99 31 102 38 136 38 127 43 157 47 121 48 173 49…
Q: Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten…
A: A simple moving average (SMA) measures the average of a chosen range of values, normally closing…
Q: Demand for oil changes at Garcia's Garage has been as follows Month January February March April May…
A: Linear regression forecasting is a statistical technique used to predict or forecast future values…
Q: a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error.…
A: Given time series data stated below, for this stated data, I would use a naive forecasting…
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: Find the given details below:Note that the given image is unclear, so we assume that Sep-14's pints…
Q: The following data are for calculator sales in units at an electronics store over the past nine…
A: Given Sales data-
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: M5TV Appearances(X) Demand for Guitars (Y) XY X2 Y2 3 2 6 9 4 3 5 15 9 25 8 6 48 64 36 5 4…
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: Formulae used: Simple Moving Average = (A1 + A2 + …… + An)n Weightage Moving Average = (A1×W1+…
Q: Using the least-squares regression method, the trend equation for forecasting is (round your…
A: Regression analysis is one of the methods of forecasting. It shows the effect of different variables…
The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: a) b) Compute the mean squared error (MSE) when using linear regression. c) Compute the mean absolute percent error {MAPE). |
Step by step
Solved in 4 steps
- The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Jan Feb Mar AprMonth 1 2 3 4Number of Accidents 25 40 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = ? + ?xThe number of patients coming to the Healthy Start Maternity clinic has been increasing steadilyover the past eight months. You are provided with some historical data as follows:Month Clinic attendance(in thousands)1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7b. Use simple linear regression to forecast annual demand for months 9 and 10 by using thetabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation. iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week of Pints used Aug 31 360 Sep 7 370 Sep 14 412 Sep 21 383 Sep 28 371 Oct 5 371 A) The forecasted demand for the week of October 12 using a 3-week moving average = 375 B) Using the 3-week weighted moving average, with weights of 0.10, 0.35, 0.55, using 0,55 for the most recent week, the forecasted demand for the week of October 12=[__] pints (round your response to two decimal places and remember to use the weights in appropriate order- the largest weight applies to most recent period and smallest weight applies to oldest period.)
- The following table gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 - a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.30, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Week Of c) If the forecasted demand for the week of August 31 is 360 and a = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14…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 Demand for Guitars Y = 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): + 4 2 X 5 7 5 9 7 6 7 6 10 7Please please answer that early please
- Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 3 8 9 6 7 6 3 7 10 11 Year Year Forecast (000) 1 5 1 5 2 5 4 4 4 5 11 Registrations (000) Use exponential smoothing with a smoothing constant of 0.4 to forecast the registrations at the seminar for years 2 through 12. To begin the procedure, assume that the forecast for year 1 was 5,000 people signing up (round your responses to one decimal place): 2 3 5 6 7 8 10 16 9 11 12 10 D 11 12 a) What is the MAD? Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is thousand registrations (round your response to one decimal place). b) What is the MSE? The mean squared error based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is (round your response to two decimal…tab s lock 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 month Ges collected the data shown in the following table V esc 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): c) The estimate for guitar sales if Maroon 5 performed on TV 9 times = d) The correlation coefficient (r) for this model The coefficient of determination (2) for this model= The percentage of variation in sales that can be explained by TV appearances = Q A N @ 2 W S 31/1 X ** 3 8.0 F3 E D C $ Maroon 5 TV Appearances Demand for Guitars sales (round your response to two decimal places). (round your response to four decimal places). (round your response to four decimal places). 4 889 R F % 5 V d Es FS Y = T G % (round your response to two decimal places). A 6…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 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
- Problem 3Let's say you are playing the stock market and below period 2020 data was provided. For "stock A" you use a 2 month moving average. For "stock B" you use exponential smoothing with (a = 0.3). What is the Forecast in Stock B for January 2021? Stock A Stock B ... Jan 0.11 Jan 14 Feb 0.20 Feb 11 Mar 0.03 Mar Apr May 1.20 Apr May 6. 0.50 9 Jun 0.03 Jun 12 Jul 0.10 Jul 16 Aug 0.11 Aug Sep 14 Sep 0.56 8 Oct 0.78 Oct Nov 0.44 Nov 4 Dec 0.10 DecAfter 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