Question

In: Operations Management

Daily high temperatures in St. Louis for the last week were as​ follows: 9595​, 9191​, 9393​,...

Daily high temperatures in St. Louis for the last week were as​ follows:

9595​,

9191​,

9393​,

9494​,

9595​,

8686​,

9090

​(yesterday).

​a) The high temperature for today using a​ 3-day moving average ​=

degrees ​(round your response to one decimal​ place).

​b) The high temperature for today using a​ 2-day moving average ​=

degrees ​(round your response to one decimal​ place).

​c) The mean absolute deviation based on a​ 2-day moving average​ =

degrees ​(round your response to one decimal​ place).

​d) The mean squared error for the​ 2-day moving average​ =

degrees squareddegrees2

​(round your response to one decimal​ place).

​e) The mean absolute percent error​ (MAPE) for the​ 2-day moving average​ =

​(round your response to one decimal

place​).

Solutions

Expert Solution

Moving average forecast can be used to forecast long-term trends and can be calculated for any time period. Mean absolute deviation is the distance between each data unit and mean.


Related Solutions

Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93,...
Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 95, 96, 88, and 90 (yesterday). a) Forecast the high temperature today, using a 3-day moving average. b) Forecast the high temperature today, using a 2-day moving average. c) Calculate the mean absolute deviation based on a 2-day moving average, covering all days in which you can have a forecast and an actual temperature.
Daily high temperatures in St. Louis for the last week were as​ follows: 92​, 94​, 93​,...
Daily high temperatures in St. Louis for the last week were as​ follows: 92​, 94​, 93​, 95​, 95​, 86​, 95 ​(yesterday). ​a) The high temperature for today using a​ 3-day moving average ​= 92 degrees ​(round your response to one decimal​ place). ​b) The high temperature for today using a​ 2-day moving average ​= 90.5 degrees ​(round your response to one decimal​ place). ​c) The mean absolute deviation based on a​ 2-day moving average​ = 3.3 degrees ​(round your response...
Daily high temperatures in St. Louis for the last week were as​ follows: 92 94, 93...
Daily high temperatures in St. Louis for the last week were as​ follows: 92 94, 93 95 97 90 93 ​(yesterday). ​a) The high temperature for today using a​ 3-day moving average ​= degrees ​(round your response to one decimal​ place). ​b) The high temperature for today using a​ 2-day moving average ​= degrees ​(round your response to one decimal​ place). ​c) The mean absolute deviation based on a​ 2-day moving average​ = nothing degrees ​(round your response to one...
Daily high temperatures in St. Louis for the last week were as​ follows: 9292​, 9494​, 9393​,...
Daily high temperatures in St. Louis for the last week were as​ follows: 9292​, 9494​, 9393​, 9595​, 9797​, 9090​, 9393 ​(yesterday). ​a) The high temperature for today using a​ 3-day moving average ​= 93.3393.33 degrees ​(round your response to one decimal​ place). ​b) The high temperature for today using a​ 2-day moving average ​= 91.591.5 degrees ​(round your response to one decimal​ place). ​c) The mean absolute deviation based on a​ 2-day moving average​ = nothing degrees ​(round your response...
Daily high temperatures in degrees Fahrenheit in the city of Lubbock for the last week havebeen...
Daily high temperatures in degrees Fahrenheit in the city of Lubbock for the last week havebeen as follows: 93, 94, 93, 95, 96, 88, 90. Using Excel’s Data Analysis add-in, a. Forecast the high temperature today, using a 3-day moving average. b. Forecast the high temperature today, using a 2-day moving average. c. Forecast the high temperature today, using weighted moving average with weights 0.5, 0.3 and 0.2 for the most recent, second most recent, and third most recent periods,...
High daily temperatures and coffee sales (in hundreds of dollars) were recorded at a local Starbucks...
High daily temperatures and coffee sales (in hundreds of dollars) were recorded at a local Starbucks for eight randomly selected days. Results are listed in the table below. Is here a correlation between temperature and coffee sales? Use α=.05. What is the best predicted sales total for a day with a high temperature of 60° F? x(° F) 32 39 51 60 65 72 78 81 y(hundreds of dollars) 26.2 24.8 19.7 20.0 13.3 13.9 11.4 11.2 r: critical value:...
Write a program that uses an array of high temperatures for your hometown from last week...
Write a program that uses an array of high temperatures for your hometown from last week (Sunday – Saturday). Write methods to calculate and return the lowest high temperature (minimum) and a method to calculate and return the highest high temperature (maximum) in the array. You must write YOUR ORIGINAL methods for minimum and maximum. You MAY NOT use Math class methods or other library methods. Write an additional method that accepts the array as a parameter and then creates...
Write a program that uses an array of high temperatures for your hometown from last week...
Write a program that uses an array of high temperatures for your hometown from last week (Sunday – Saturday). Write methods to calculate and return the lowest high temperature (minimum) and a method to calculate and return the highest high temperature (maximum) in the array. You must write YOUR ORIGINAL methods for minimum and maximum. You MAY NOT use Math class methods or other library methods. Write an additional method that accepts the array as a parameter and then creates...
High daily temperatures and times (in minutes) were given for women who won the New York...
High daily temperatures and times (in minutes) were given for women who won the New York City marathon in recent years. Results are listed in the table below. Is here a correlation between temperature and winning time? Use α=.05. What is the best predicted finishing time for a day with a high temperature of 70° F? x(° F) 55 61 49 62 70 73 51 57 y(minutes) 145.3 148.7 148.3 148.1 147.6 146.4 144.7 147.5 r: critical value: Significant linear...
The accounting record for St. Louis Cardinals, baseball club in St. Louis, MO, reported the following...
The accounting record for St. Louis Cardinals, baseball club in St. Louis, MO, reported the following selected information: Account Amount Cost of Tickets Sold 97,000 Depreciation Expense 36,000 Furniture and Equipment 72,000 Income Tax Expense 13,800 Insurance Expense 29,000 Interest Expense 15,900 Investment Expense 4,600 Marketing Expense 62,000 Prepaid Expense 16,800 Salaries Expense 78,000 Supplies Expense 35,000 Utilities Expense 41,000 Determine St. Louis Cardinal's selling, general and administrative expenses. (a.k.a. Operating Expenses.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT