emergency!!! all one question!! use excel!!! help please, will give you a thumbs if completely answered!

Business at Terry's Tie Shop can be viewed as falling into three distinct categories (1) Christmas - Nov - Dec (2) Father's Day ate May - mid jne) and (3) all other times. Average weekly sales in 5 during the three seasons in the past 4 years are shown below. Determine a forecast for the average weekly sales in year 5 using the data below. Year Season Period Data 2015 1 1 1856 2 2 2012 3 3 985 2016 1 4 1995 2 5 2168 3 6 1072 2017 1 7 2241 2 8 2306 3 9 1105 2018 1 10 2280 11 2408 Nm 12 1120 Use the Trend and Seasonal Method demonstrated to calculated the four SCALED seasonal indexes (correct to 2 decimal places). Season Scaled Seasonal Index 1 2 3 De-seasonalize the data (after you have found the scaled seasonal index values). Find the linear regression equation using the de-seasonalized data: Use 3 decimal places. slope intercept R^2 What are the re-adjusted forecasts for the next Year (Season 1 to Season 3) correct to 2 decimal places? Season 1 Season 2 Season 3 The MAD for the trend and seasonal method (3 decimal places) is Using the original data, use linear regression to find the equation to perform a forecast: Use 3 decimal places. slope intercept R^2 What is the MAD for ordinary linear regression? (Use 3 decimal places). The Trend and Seasonal method is clearly better than ordinary linear regression. Circle the reason which explains why this is the case. O The MAD is higher and the R^2 is higher. The MAD is lower and the R^2 is higher. The MAD is lower and the R^2 is lower. The MAD is higher and the R^2 is lower