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 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,...
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 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:...
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...
6. Listed below are actual high temperatures and the high temperatures that were forecast five days...
6. Listed below are actual high temperatures and the high temperatures that were forecast five days earlier. Use a .05 significance level to test the claim of a zero mean difference between the actual high temperatures and the high temperatures that were forecast one day earlier. Use our 4-step procedure. This is a matched or paired samples hypothesis test. Actual high: 80 77 81 85 73 High forecast one day earlier: 78 75 81 85 76 Step 1: Ho____. Ha:...
Data sets for daily high temperatures (in °F) in the months of August and February of...
Data sets for daily high temperatures (in °F) in the months of August and February of 2015, 2017, and 2019: August 2015: 80; 81; 85; 87; 84; 80; 75; 82; 83; 85; 72; 78; 79; 85; 88; 89; 90; 90; 86; 84; 80; 79; 80; 85; 79; 74; 71; 77; 83; 88; 85 February 2015: 31; 33; 23; 37; 33; 22; 37; 42; 36; 29; 32; 32; 15; 24; 12; 12; 23; 28; 15; 13; 24; 37; 30; 23; 33;...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT