Michelle has a chart that analyze the relationship between advertiisng expense and sales to see if she increase or decrease on advertising expense.

Here is the chart with the collected information:

Month	Advertising Expense	Revenue
Jan	4,585	87,840
Feb.	7,945	94,760
March	5,555	133,550
April	8,425	92,220
May	3,380	126,630
June	4,075	85,540
July	10,460	94,600
August	6,730	135,900
Sept.	5,680	121,570
Oct.	6,550	91,000
Nov.	9,125	105,750
Dec.	4,110	140,220

Question 1. Use the data above to generate a regression anaylysis (a summary output). Then create a scatter graph that includes the regression line on Excel and present the equation/function and R-squared.

I just want to inform you for the equation, got y= -3,2593x + 129942 and R-squared, I got 0.1215. I used the advertising expense as the x-intercept and the revenue as my y-intercept. Please see if you got the same answer as I did so I know I am doing the step correctly.

Question 2. Michelle realizes that there may be a lag between the advertising incurred and the timing of sales revenue. Michelle modifies the analysis by comparing

each month's sales revenue to the prior month's advertising expense. Generate another regression analysis after discarding January sales revenue and December

advertising expense in order to compare each month's sales to the prior month's advertising expense. What would be the function (equation) for this regression line?

Include a plot/graph of the regression line in Excel showing the equation/function and R-squared.

For this one, the equaltion I have y= -2.0046x + 113925 and the R-squared, I have 0.0229. The x-intercept is advertising expense and y-intercept is the revenue. Please inform me that I am using the x and y-intercept correctly. Question 3. For requirments of #1 and #2, is the coefficient for advertising expense significant. Please explain on how you find the solution. Question 4. What proportion of changes in sales revenue is explained by the amount of advertising expense in both requirements #1 and #2? Please give some explanation. The assignment is not hard and it does not take a lot of time. Please, if anyone is an expert at working on excel and data on excel as well managerial accounting, please help me and give me feedback that I arrive at my answer correctly for question 1 and 2. Thanks.