Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 94, 95, 90, 93 (yesterday). A.) The mean absolute deviation based on a 2-day moving average = ____ ___degrees (round your response to one decimal place). B.) The mean squared error for the 2-day moving average =__________ degrees2 (round your response to one decimal place). C.) The mean absolute percentage error (MAPE) for the 2-day moving average = % (round your response to one decimal place)

Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 94, 95, 90, 93 (yesterday). A.) The mean absolute deviation based on a 2-day moving average = __ _degrees (round your response to one decimal place). B.) The mean squared error for the 2-day moving average =__________ degrees2 (round your response to one decimal place). C.) The mean absolute percentage error (MAPE) for the 2-day moving average = % (round your response to one decimal place)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Records pertaining to the monthly number of job-related injuries at an underground coal mine were being studied by a government agency. The values for the past 100 months were as follows: Injuries Frequency of per Month Occurrence 32 40 2 15 3 4 1. 1. Apply the chi-square test to these data to test the hypothesis that the underlying distribution is Poisson. Important note: In the answer box below, just put the numerical test statistic value. Use x.xx format for the numerical value you provide as the answer. Do NOT compare the test statistic with the critical value from a table. Answer:
b. The mean absolute deviation as of the end of week 10 is___ rentals enter your response here. (Enter your response rounded to two decimal places.)
The following data was recorded while observing the increase in the number of butterflies in two different ponds, Pond A and Pond B. Number of Butterflies Present Over 5 Years Year Pond A Pond B 0 50 65 85 1 2 3 4 5 100 O 110 121 133 146 161 110 143 186 What is the rate of growth, r, for each pond and which pond has the fastest average rate of growth over the five years? TA = 1.1, TB = 1.3, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg=27.2 butterflies/yr TA = 1.1, TB = 1.3, mg=27.2 butterflies/yr
Bill Kime's bowling ball factory makes bowling balls of adult size and weight only. The standard deviation in the weight of a bowling ball produced at the factory is known to be 0.39 pounds. Each day for 24 days, the average weight, in pounds, of 9 of the bowling balls produced that day has been assessed as follows Day 1 2 3 4 5 6 Average (lb) 9.9 9.9 10.1 10.1 99 99 Day 7 8 9 10 11 12 Average (lb) Day Average (b) 13 14 15 16 17 18 10.1 10.0 10.0 10.1 10.1 10.0 9.9 10.1 10.1 10.0 10.1 10.1 Day 19 20 21 22 23 24 Average (lb) 99 10.0 10.1 9.9 10.0 10.0 a) Establish a control chart for monitoring the average weights of the bowling balls in which the upper and lower control limits are each two standard deviations from the mean What are the values of the control limits? Upper Control Limit (UCL)=b (Round your response to two decimal places)
An avant-garde clothing manufacturer runs a series of high-profile, risque ads on a billboard on Highway 101 and regularly collects protest calls from people who are offended by them. The company has no idea how many people in total see the ad, but it has been collecting statistics on the number of phone calls from irate viewers: a) Choose the correct Pareto chart below. O A. Frequency (number) LL WROMI O B. Frequency (number) Type R M W I O Description Offensive racially/ethnically Demeaning to men Demeaning to women Ad is Incomprehensible Other RMWO Frequency (number) LONDO Number of Complaints 12 4 13 2 7 WROMI O Frequency (number) OFONSO 12- RM WIO
S Book Hint Print eferences Problem 13-2 (Algo) A metal fabricator produces connecting rods with an outer diameter that has a 1 ± 0.02 inch specification. A machine operator takes several sample measurements over time and determines the sample mean outer diameter to be 1.004 inches with a standard deviation of 0.006 inch. Calculate the process capability index for this example. (Round your answer to 3 decimal places.) Process capability index
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Calculate the upper and lower control limits for this chart.
The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Yearly Maintenance Yearly Maintenance Age (years) Age (years) Cost ($) Cost (S) 6.5 819 8.0 1,394 5.5 1,249 2.5 363 6.5 1,233 2.5 382 7.0 695 9.0 964 6.0 923 8.0 1,573 6.0 881 3.0 1,178 7.0 1,090 3.0 666 7.0 1,722 3.0 749 7.5 1,187 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 365.727 + 110,721 X where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 four-year-old tractors, what is the forecast for the annual maintenance cost? $ |- (Enter your response rounded to two…
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
Calculate the Mean Squared Error for the following data: Actual 90 87 96 102 Forecast 89.3 89.2 93.3 90.7 (Keep two decimal places in your answer)
Prior to conducting double exponential smoothing a simple linear regression is conducted and the trend equation is Y=42+38.3t, so the smoothed constant process value should be C0=38.3 and the smoothed trend value should be T0=42.? TRUE OR FALSE?
An operation analyst is forecasting this year's demand for one of his company's products based on the following historical data: (4 year ago Quantity sold was 10842), (3 year ago Quantity sold was 11881 ), (2 year ago Quantity sold was 16064 ) and the last year Quantity sold was 19273 . The previous trend line had predicted 12250 for three years ago, 13000 for two years ago and 13750 for last year. What was the mean absolute percent error (MAPE) for these forecasts? a. 16.95 b. 2739 c. 0.17 d. 2985