Question
In: Statistics and Probability
Determine the seventh projection of the following process variable data: Using Exponential Smoothing (α= 2/n+1) Actual...
Determine the seventh projection of the following process variable data:
Using Exponential Smoothing (α= 2/n+1)
Actual Results 100 123 140 110 150 105
Solutions
Expert Solution
α= 2/n+1 = 2/(7+1) = 0.25
Solve Using Excel:
| α | 0.25 | ||
| Projection | Actual (A) | Foercast (F) | A-F |
| 1 | 100 | 100.00 | 0.00 |
| 2 | 123 | 100.00 | 23.00 |
| 3 | 140 | 105.75 | 34.25 |
| 4 | 110 | 114.31 | -4.31 |
| 5 | 150 | 113.23 | 36.77 |
| 6 | 105 | 122.43 | -17.43 |
| 7 | 118.07 |
| Projection | Actual (A) | Foercast (F) | A-F |
| 1 | 100 | =B3 | =B3-C3 |
| 2 | 123 | =C3+$C$1*D3 | =B4-C4 |
| 3 | 140 | =C4+$C$1*D4 | =B5-C5 |
| 4 | 110 | =C5+$C$1*D5 | =B6-C6 |
| 5 | 150 | =C6+$C$1*D6 | =B7-C7 |
| 6 | 105 | =C7+$C$1*D7 | =B8-C8 |
| 7 | =C8+$C$1*D8 |
Projection 7 = 118.07
orchestra answered 2 years agoRelated Solutions
Using exponential smoothing with α of 0.1 and the given forecast for year 1
As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year12345Heart Transplants46.048.055.057.057.0The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries a) Using exponential smoothing with α of 0.1 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year123456Forecast42.0For the forecast made using exponential smoothing with α...
Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop...
Given the following data, use exponential smoothing with a = 0.3
and α =.5 to develop a demand forecasts for period
7. Assume that the forecast for week 1= 19. Use the Mean
Absolute Percent Error to determine which forecasts are more
accurate.
Period
1
2
3
4
5
6
Demand
17
19
15
19
13
18
Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data...
Question: Use the first-order exponential smoothing model with
α = 0.2 to forecast for these data and for the
first six months of the third year. Compute MSD/E,
MAD, MAPE, and Bias.
Month
(t)
Demand
A(t)
1
148
2
125
3
78
4
53
5
25
6
29
7
9
8
68
9
84
10
110
11
147
12
120
13
147
14
109
15
96
16
70
17
42
18
36
19
34
20
28
21
71
22
102...
Use exponential smoothing with trend adjustment. Consider T1 = 2, F1 = 12, α alpha =...
Use exponential smoothing with trend
adjustment. Consider T1 = 2, F1 =
12, α alpha = 0.2 ,
delta = 0.3
PART (A) What is your forecast for period
3?
Part (B) What is the related MAD for your
forecast?
Month
Actual Demand
1
15
2
25
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a. Show the naive forecast, an exponential smoothing
forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc. Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the
MSE.
With the gasoline time series data from the given table, show the exponential smoothing forecasts using...
With the gasoline time series data from the given table, show
the exponential smoothing forecasts using α = 0.1.
week 1 2 3 4 5 6 7 8 9 10 11 12
sales 17 21 19 23 18 16 20 18 22 20 15 22
a.
Applying the MSE measure of forecast accuracy, would you prefer
a smoothing constant of α = 0.1 or α = 0.2 for the gasoline sales
time series? Do not round your interim computations and...
Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of...
Use 5 months moving average and exponential smoothing method
(using alpha=0.3) on the following sale of Maggi. You are supposed
to forecast the sale of Maggi in the 13th Month. Compare
whether there is any difference in forecast based on two methods
and Comment.
Period (Month)
Actual Sale of Maggi
1
1100
2
800
3
1000
4
1050
5
1500
6
750
7
700
8
650
9
1400
10
1200
11
900
12
1000
13
The following data based on assumption for 2 years projection, Analysis the following income statement and...
The following data based on assumption for 2 years projection,
Analysis the following income statement and state whether investor
should invest the company or not (250 words minimum)
YEAR 1
YEAR 2
Revenues
$ 2,995,000
$ 3,200,000
Cost of sales
1,894,000
2,100,000
Gross profit
$ 1,101,000
$ 1,100,000
Accounting
8,000
8,300
Advertising and promotion
17,000
11,000
Bank chargers
51,000
55,897
Compensation and benefits
197,546
234,985
Insurance
5,000
5,550
Lease, facilities
350,600
456,000
Legal and professional
15,900
15,900
Licenses and fees...
Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg...
Using the calculated wavelength, plot a graph of
1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg constant from
the slope of the line. Please write answer as neatly and large as
possible, clearly demonstrating all steps.
Computed wavelengths for each spectral line;
Yellow = 5.89x10^-7m
Violet = 4.38x10^-7m
Blue = 4.91x10^-7m
Red = 6.78x10^-7m
Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg...
Using the calculated wavelength, plot a graph of
1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg constant from
the slope of the line. Please demonstrate using Excel only how to
plot the graph portion and demonstrate clearly on paper how to
determine the Rydberg constant from the slope of the line (showing
all steps in detail)
Computed wavelengths for each spectral line;
Yellow = 5.89x10^-7m
Violet = 4.38x10^-7m
Blue = 4.91x10^-7m
Red = 6.78x10^-7m
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to...
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
- -what is the pH of HCl 0,1M and NaCl 0,1M mixed together solution? -What is the...
- function X=extractDWT(x_train,startS,endS,wStep,wRange) % x_train = input signal % startS = from second % endS = end...
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
ADVERTISEMENT