What is the five period moving average for 2002_Q2 (round off to one decimals).

I posted this question and it's been 18 hours that it still hasn't been answered. I only need the last two questions please (:

Make a scatter plot and find Correlation coefficient between the sales and expenses from the data given:

Given: Year     Demand 1             7 2             9 3             5 4             9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?

Sales of a company (in $100,000) for the last 7 years are listed in the following table. Use the data as given in the table, do not include the hundred thousand at the end of the values. Year Q1 Q2 Q3 Q4 1 6 15 10 4 2 10 18 15 7 3 14 26 23 12 4 19 28 25 18 5 22 34 28 21 6 24 36 30 20 7 28 40 35 27 What are the adjusted R^2, and forecasts for Q1, Q2, Q3, and Q4 of Year 8 using this model? 4 decimals. Adjusted R^2: Q1: Q2: Q3: Q4:

The long-term financial forecast plays a crucial part in the company's long-term strategic plan. True or False True False 25 28 étv N 4

part b)

Assume today's date is 12/31/2023. Actual sales and forecast for 2023 are given below. Actual Forecast 2023 72.4 66.9 59.5 61.2 260 2023 69 67 Q3 61 Q4 59 Total 256 Obtain the MAD Q1 Q2 7.2 1.8 -1

Which of the following scenarios is the most credible forecast over the next decade. (Choose ONLY 1 Scenario). Why?   Globalization of Business is Inevitable IB Growth that is Less Global Globalization and IB will Slow

Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates? (Hint, you might want to use excel for this) period 1 2 3 4 5 6 7 8 9 10 13673 6640 2737 3486 141 13186) 5448 3485 7728 16591 8236 3316 855358 11 12 13 15 16 17 18 19 Demand Deseasonalized D₁ Demand D 3200 7658 4420 2384 3654 8680 5795 1953 4742 20 4472 4657 4956 5074 5157 5917 6646 6850 6791 6573 6363 6308 6932 7887 8662 8989 O Level-4696 Trend-343 O Level-3612. Trend-264 O Level 3629; Trend-263 O Level-2528: Trend-185