The sales data from period 1-7 are as the follows: 58, 66, 69, 81, 75, 73,...
Gender HeartRate male 70 male 71 male 74 male 80 male 73 male 75 male 82 male 64 male 69 male 70 male 68 male 72 male 78 male 70 male 75 male 74 male 69 male 73 male 77 male 58 male 73 male 65 male 74 male 76 male 72 male 78 male 71 male 74 male 67 male 64 male 78 male 73 male 67 male 66 male 64 male 71 male 72 male 86 male 72...
The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 In Excel, create forecasts for periods 6-13 using each of the following methods: -------- -5 period simple moving average; Using a 5 period simple moving average, the forecast for period 13 will be: 68 -4 period weighted moving average (0.63, 0.26, 0.08, 0.03); Using...
In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving average. Using a 5 period simple moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
The following data are the joint temperatures of the O-rings (F) for each test firing or actual launch of the space shuttle rocket motor (from Presidential Commission on the Space Shuttle Challenger Accident, Vol. 1, pp. 129-131): 82 47 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53 67 75 61 70 81 76 79 75 76 58 31 Round your answers to 2 decimal places...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74 Using a 5 period simple moving average, the forecast for period 13 will be: QUESTION 2 Using the 4 period weighted moving average, the forecast for period 13 will be: QUESTION 3 With exponential smoothing, the forecast for period 13 will be: QUESTION 4 With linear regression, the forecast for period 13 will be: QUESTION...
Boats (tens of thousands) Manatees 66 55 65 38 69 34 67 49 74 42 75 59 78 53 84 69 81 82 87 79 90 81 94 93 92 74 98 67 99 78 102 91 100 73 98 91 97 97 93 82 88 89 87 80 90 71 92 68 idrresponding numbe o ms for 880.000 registered Use the accompanying paired data consisting of registered boats (tens of thousands) and manatee fatalities from boat encounters. Let x...
Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. The following data are the joint temperatures of the O-rings (°F) for each test firing or actual launch of the space shuttle rocket motor (from Presidential Commission on the Space Shuttle Challenger Accident, Vol. 1, pp. 129-131): 83 46 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53...
I need help on calculating a current overall average for this data in MatLab. I need to make another vector for the data where each position is a current average. I've looked around online to try and get an idea of what to do and I saw the things about there being a moving average function or using filter. But we haven't talked about those in my class so I can't use them. I think a for loop could do...
A can opener manufacturer has had monthly sales for a seven-month period as follows: Month Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .20...
1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. 21 Mar. 20 Apr. 17 May 22 Jun. 20 Aug. 22 a. Plot the monthly data on a sheet of graph paper.b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using 60 for August, 30 for July, and. 10 for June (4) Exponential smoothing with a smoothing constant equal to.20, assuming a March-forecast of...