Please answer every question posted in the pictures below. will give thumbs up, please type out answers clearly too. thank you

Test Information Description Below is an example of operating revenue for ConEdison (Gas and Steam) during the past 3 years (2010-2012). Period Data 1 3462 2 3017 3 3707 4 3139 5 3349 6 2993 7 3620 8 2967 3078 10 2775 11 3438 12 3128 Instructions Multiple Attempts The test allows attempts. This is attempt number 1 Force Completion This test can be saved and resumediate Your answers are saved to alysis 1 lysis QUESTION 1 20 points SA Use the Trend and Seasonal Method demonstrated to calculated the four SCALED seasonal indexes (correct to 3 decimal places) Quarter Scaled Seasonal Index 01 02 03 ject 1 04 QUESTION 2 15 points De-seasonalize the data (after you have found the scaled seasonal index values) Find the linear regression equation using the do-seasonalced data Use 2 decimal places slope Intercept R2 QUESTION 3 QUESTION 4 10 points Save Ador The MAD for the trend and seasonal method 2 decimal places) is QUESTION 5 15 points Using the onginal data, use linear regression to find the equation to perform a forecast Us 2 decimal places slope internet 2 Chemises Chicken to www Sawant QUESTION 6 10 points Sine Art What is the MAD for ordinary linear regression? (Use 2 decimal places). QUESTION 7 5 points The Trend and Seasonal method is clearly better than ordinary linear regression Circle the reason which explains why this is the case The MAD is higher and the R2 is higher The MAD is lower and the R2 is lower The MAD lower and the R2 is higher The MAD ister and the R2 is lower