(1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April; (3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000

(1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April; (3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000

Name: Q1) Monthly sales for a six month period are as followsMonthSalesJan18
Uploaded: 2024-03-05T11:52:21.000Z
Channel: Bartleby
Description: Q1) Monthly sales for a six month period are as followsMonthSalesJan18,000Feb22,000Mar16,000Apr18,000May20,000June24,000Compute the sales forecast for July using the following approaches:(1) Four-month moving average;(2) Weighted three-month moving a

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter7: Distance And Approximation

Section7.3: Least Squares Approximation

Problem 31EQ

See similar textbooks

Similar questions

The customer demand for a particular smart phone during Year 0 to Year 5 is given as 1,056,000, 1,032,000, 1,093,000, 1,024,000, 1,066,000, and 1,072,000. Using the Holt forecasting model with trend, what is the forecasted demand in year 10, where w = 0.4 and v = 0.5?a) 1,071,874b) 1,075,573c) 1,077,488d) 1,083,816
Recent publications have addressed the growing concern in the scientific community around the increased prevalence of CAT scans in children between the ages of 7-18 and the growing rate of childhood cancers. Suppose the researcher plans to gather a SRS from a group of children in this age range who have received one or more CAT scans, and a SRS from a group of children who have never received a CAT scan and compare the number of cases of childhood cancers that develop over a prolonged period of time. Assume the following table summarizes the descriptive statistics for his samples. Population Average cases of childhood cancers Standard deviaton Sample size >CAT scan 24.6 2.4 1,894 No CAT scans 11.4 1.9 2,745 A) Carry out the appropriate statistical test to answer the researcher’s hypothesis regarding the difference in average cases of childhood cancers in children aged 7-18 receiving one or more CAT scans versus those that have never received a CAT scan. Use an alpha level…
Suppose that index model for Stocks A and B is estimated from excess returns with the following results : Ra 0.04 +0.6Rm+ea , Rb = - 0.04 + 1.3Rm + eb Risk on the market is 30% , R-squared of A is 30%R - squared of B is 40% , security A residual variance is
From the data in the table it shows the 2019 daily return data for the S&P 500 Index (stocks) and the US 30 year Bond (bonds). How do I test the hypothesis that mean daily return on stocks exceeds the mean daily return on bonds? Please show the steps. S&P500 dailt returns data: Date Price Daily Return 2019-12-31 3230.78 0.294602% 2019-12-30 3221.29 -0.578082% 2019-12-27 3240.02 0.003398% 2019-12-26 3239.91 0.512817% 2019-12-24 3223.38 -0.019545% 2019-12-23 3224.01 0.086614% 2019-12-20 3221.22 0.494478% 2019-12-19 3205.37 0.445929% 2019-12-18 3191.14 -0.043230% 2019-12-17 3192.52 0.033529% US 30 Year Bond Date Price Daily Return 31-Dec-19 2.389 2.32% 30-Dec-19 2.335 0.78% 29-Dec-19 2.317 -0.03% 27-Dec-19 2.318 -0.16% 26-Dec-19 2.321 -0.71% 25-Dec-19 2.338 0.15% 24-Dec-19 2.334 -0.83% 23-Dec-19 2.354 0.31% 22-Dec-19 2.346 0.12% 20-Dec-19 2.344 -0.43%
Monthly sales for a six month period are as follows: Month Sales Jan 18,000 Feb 22,000 Mar 16,000 Apr 18,000 May 20,000 June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April; (3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000
The values of Alabama building contracts (in $ millions) for a 12 -month period follow. 240 350 240 260 280 320 220 310 240 310 240 240 A. Compare the three-month moving average approach with the exponential smoothing forecast using a=0.2 (to 2 decimals). MSE (3-Month) _______ MSE ( a=0.2) __________ Using only the errors for months 4 to 12, the MSE for exponential smoothing is: MSE ( a=0.2) __________ C. Using the approach that provides more accurate forecasts based on MSE, what is the forecast for the next month (to the nearest whole number)? $ _______million
Intergarated products Need to estimate its pc sales for the nextnext year. the most recent six years of revenue data for the companys line of xt personal computers and those of the industry, is found in the table below; Year XT PC Sales (000,000) All Industry PC Sales Revenue 1 2.4 4.6 2 5.9 8.6 3 15.5 10.7 4 27.8 14.8 5 35.9 18.5 6 38.1 19.4 a) Assuming that the sales data above are representative of sales expected next year , use time series regression analysis to forecast next years sales b) determine the correlation correlation for he ime forecast and interpret is meaning c) find the coefficient of determination for the time series forecast and intpret it s meaning d) perform a regression analysis between the annual sales revenues of XT Personal computers and all personal computers if the estimate of next years industry PC sales revenues is $21.9 billion? e) which independent variable should intergrated products coporation IPC choose for its forcasting of sales…
a. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of August b.In the Petroco Service Station problem, for the exponentially smoothed forecast with an α value of .30, compute the mean absolute deviation (MAD) via Excel and/or POM-QM c. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of January would be d.In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of August