Question: Answer questions 19-21 based on the following information. E G H 1 D Forecast WMA3 (0.7,0.2,0.1) ES (a=0.4) 2 X OK Cancel B 1 2

Answer questions 19-21 based on the following
Answer questions 19-21 based on the following
Answer questions 19-21 based on the following
Answer questions 19-21 based on the following information. E G H 1 D Forecast WMA3 (0.7,0.2,0.1) ES (a=0.4) 2 X OK Cancel B 1 2 Period Actual 3 li 100 4 2 103 53 90 64 87 7 S 106 8 6 120 97 110 10 8 95 119 89 12 10 108 13 11 98 14 12 97 15 13 16 Exponential Smoothing Input Input Range: Damping factor Labels Output options Qutput Range: New Worksheet Ply New Workbook Help Chart Output Standard Errors 1 pts Question 19 1 pts When using a 3-period weighted moving average method (with weights 0.7, 0.2, 0.1) to forecast for period 12, what is the correct input for C14 (Column C Row 14) in the excel file above? 0 =0.1*B13+0.2*B12+0.7*B11 0 =0.7*B14+0.2*B13+0.1*B12 O None of the answers is correct O=0.1*B14+0.2 B13+0.7*B12 O=0.7*B13+0.2*B12+0.1*B11 n Question 20 1 pts When using the exponential smoothing method with a=0.4 to forecast for period 13, what is the correct input for "Damping factor"? 0.4 O 0.6 None of the answers is correct Question 21 1 pts When using the exponential smoothing method with a=0.4 to forecast for period 13, what is the correct input for "Output Range"? $D$3:$D$15 $D$4:$D$15 $D$3:$D$14 None of the answers is correct

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!