Question

In: Statistics and Probability

For the data listed below, conduct following in Excel i) Create a forecast with 4-day moving...

For the data listed below, conduct following in Excel

i) Create a forecast with 4-day moving average,

ii) Create a forecast using exponential smoothing method with smoothing constant equal to 0.6,

iii) Compute Root Mean Squared Error (RMSE) and identify which of the two methods produces a forecast with better accuracy.

Day Sales ('000 $)
1 1735
2 1719
3 2025
4 1295
5 717
6 4317
7 2681
8 2669
9 6273
10 2049
11 2585
12 4895
13 2057
14 6955
15 2239
16 2369
17 6889
18 1697
19 309
20 715
21 5231
22 1503
23 1457
24 1785
25 2041
26 249
27 747

Solutions

Expert Solution


Related Solutions

For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate the standard errors 3. compare their forecast accuracy Month/Year Unemployment rate Jan-17 5.1 Feb-17 4.9 Mar-17 4.6 Apr-17 4.1 May-17 4.1 Jun-17 4.5 Jul-17 4.6 Aug-17 4.5 Sep-17 4.1 Oct-17 3.9 Nov-17 3.9 Dec-17 3.9 Jan-18 4.5 Feb-18 4.4 Mar-18 4.1 Apr-18 3.7 May-18 3.6 Jun-18 4.2 Jul-18 4.1 Aug-18 3.9 Sep-18 3.6 Oct-18 3.5 Nov-18 3.5
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter...
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b. 333.875 c. 269.250 d. 243.625 Year QTR Revenue (in $1000) 2015 1 205 2 400 3 200 4 229 2016 1 236 2 219 3 211 4 200 2017 1 280 2 275 3 261 4 322 2018 1 500 2 230 3 310 4 400 2019 1 325 2 241 3 379 4 316
How can I create a normal distribution in excel when the only data I have is...
How can I create a normal distribution in excel when the only data I have is mean and standard deviation?
Forecasting Cash Flow and Burn Rate Create a Cash Flow Forecast on Excel using the following...
Forecasting Cash Flow and Burn Rate Create a Cash Flow Forecast on Excel using the following assumptions: Forecast duration: Years 0 through 5, then Exit Unit Sales: Sell 2000 units your first year and increase 30% per year Price: $100/unit first year and increase 5% per year COGS: Calculate based on a 75% Gross Profit Margin NOTE: to complete the Operating Expense section, break it into two lines: Payroll and Other Payroll: Start with 2 employees in year 0 paid...
4. Use the following table to calculate the amounts listed below: Hellitech Corporation – Selected Data...
4. Use the following table to calculate the amounts listed below: Hellitech Corporation – Selected Data Credit Sales $127,382 Cost of Goods Sold $76,157 Beginning Inventory $10,583 ENDING INVENTORY $13,685 Accounts Receivable BEGINING $5,130 ENDING $5,690. Accounts Payable BEGINING $7,205, ENDING $8,105. What is the: ? Inventory Period ? Accounts Receivable Period ? Accounts Payable Period ? Operating Cycle ? Cash Cycle
give the following data for stock prices and 5-day moving average. what is the closing stock...
give the following data for stock prices and 5-day moving average. what is the closing stock price on april 16th? date price close 5 day MA 4/17/2018 $20.35 $ 20.240 4/18/2018 $20.03 $20.280 4/19/2018 $20.89 $20.462 4/20/2018 $21.13 $20.636
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17,...
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17, 22, 15 Group 2 : 21, 15, 16 Group 3 : 7, 8, 3, 10, 6, 4 Group 4 : 13, 6, 17, 27, 20
Conduct a TWO WAY ANOVA using the following data in Excel. State Schools and Private Schools...
Conduct a TWO WAY ANOVA using the following data in Excel. State Schools and Private Schools Campus 1 : 47, 52, 37, 50, 25, 33, 31, 50 Campus 2: 77, 61, 55, 48, 52, 68, 60, 60
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
Please answer in excel only. How do I create the graphs in excel and show the...
Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT