Hi Tutors,

I provided the table below for running the regression analysis in excel using data analysis tools found in excel hometab. The task is clear below underlined in no. 1 2 3 4 below. These are queestions I received for my assignment, thanks! If you require additional info, it just simply means you're not able to solve because this is the actual question given by my lecturer who has taught statistic for 20 years.

Regression Analysis.

Report Brief

The manager of a fast-food restaurant wants to determine how sales in each week are related to the number of discount vouchers (#) printed in the local newspaper during the week. The number of vouchers and sales ($000s) from 10 randomly selected weeks is given below:

Number of vouchers	Sales
4	12.8
7	15.4
5	13.9
3	11.2
19	18.7
10	17.9
8	16.8
6	15.9
3	11.5
5	13.9

Your task is in four parts:

Using the above data, run the least square regression analysis to estimate the impact of number of vouchers have on restaurant's weekly sales. Present the excel summary output in an appropriate table.

1. Interpret the value of intercept coefficient & the slope of the regression line
2. Determine the coefficient of determination and discuss what the coefficients tell you about the relationship between the two variables.
3. Use the regression equation toPredict weekly sales in the fast-food restaurant if 10 vouchers are printed in the local newspaper.
4. Plot the residuals against the predicted values.Plot the residuals against the predicted values of y. Does the variance appear to be constant?

The writing, tables, and figures will all be graded on content and presentation.

Guidelines:

Your report should be understandable to a person who has no background in statistics, while also allowing a data analyst to verify your interpretation of your results.