Please solve the following using EXCEL. Please show all the detailed steps.

Q1: A merchant needs a forecast for the sales of a product (in millions). He thinks that the sale is affected by expenditure on advertising (in millions of dollars). Based on the data set with six observations, the summary statistics are given below (X is expense on advertising expenditure in million dollars and Y is number of products sold in millions): X = 24; Y = 42; X2 = 124; Y2 = 338; XY = 196 Find the Intercept and slope, write the Regression Equation, and interpret the results. Make a forecast for the sale of products (in millions) if the advertising expenditure is 5 million dollars. Calculate the correlation coefficient, coefficient of Determination. Verify the relationship between the coefficient of correlation and the coefficient of Determination. Calculate SSE and MSE and standard error of the slope coefficient and perform the test of significance.