Year OC Music Company has been in business for 4 years. Data about the sales of each quarter were collected below. The manager wants use these data to forecast sales of the 5th year. Please copy an Quarter Sales paste it to Excel and run regression analysis. Answer the following 4 questions. Please also upload your EXCEL file on Canvas, otherwise you will NOT receive any point for this problem. Q1 Q2 EN Q3 Q4 10 Q1 Q2 23 Q4 14 Q1 O Q2 Q3 Q4 16 Q1 12 Q2 Q3 Q4 22 hp SUJI TASCHEN3331895/quizzes/secured#lockdown Question 15 10 pts How much of the variations in sample value of dependent variable does the model explain? Do not use percentage. Rounded to two decimal places. For example, you should enter 0.45, not 45%. Question 16 5 pts Use the model to forecast for sales of the first quarter in the 5th year. Rounded to two decimal places. D Question 17 5 pts Use the model to forecast for sales of last quarter in the 5th year. Rounded to two decimal places. 5 pts Question 18 Calculate the MSE for this time series forecast. Rounded to two decimal places. 5 pts D Question 19 Calculate the MAE for this time series forecast. Rounded to two decimal places. hp SUJI TASCHENQuestion 16 Use the model to forecast for sales of the first quarter in the 5th year. Rounded to two decimal places. Question 17 Use the model to forecast for sales of last quarter in the 5th year. Rounded to two decimal places. Question 18 Calculate the MSE for this time series forecast. Rounded to two decimal places. Question 19 Calculate the MAE for this time series forecast. Rounded to two decimal places. No new data to save. Last checked at 2:26 hp SUJI TASCHEN