Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, could someone help me solve this homework problem that has 4 parts. The first two questions are mainly putting the equation into excel, and
Hello, could someone help me solve this homework problem that has 4 parts. The first two questions are mainly putting the equation into excel, and the rest is using the graph to interpret to answer the question. Please help if anyone is an expert in excel. This is a managerial accounting problem.
ng information from the prior year Month Sarah is analyzing the relationship betwean advertising expense and sales in order to determine whether to increase or scale back on advertising in the future JanuaryS4,585 S 87,840 94,760 5,555 133,550 8,42592,220 3,380 126,630 ,075 85,540 94.600 6,730 135,900 5,680 121,570 91,000 105,750 4,110 140,220 7,945 March une uly August eptember 10,460 6,550 9,125 October December Required: 1. Use the data above to generate the regression analysis output in Excel when comparing each month's advertising expense to the same month's revenue. Include a plot/graph of the regression line in Excel showing the equation/ function and R-squared. What would be the function (equation) for the regression line? 2. Sarah realizes that there may be a lag between the advertising incurred and the timing of sales revenue. Sarah modifies the analysis by comparing each month's sales revenve to the prior month's advertising expense. Generate another regression analysis after discarding January sales revenve 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/eraph of the regression line in Excel showing the equation function and R-squared. 3 Is the coefficient for advertissng expense significant in requirements #1 and #2? Briefly explain how you came up with solution what proportion of changes tn sales revenue is explained by the amount of advertising expense in both requirements #1 and #2? Briefly explain 4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started