Question
I need with excel formula shown, please Question 4 You run a company called Data for the People that provides statistical consulting services for businesses
I need with excel formula shown, please
Question 4You run a company called "Data for the People" that provides statistical consulting services for businessesIn order to boost your sales, you have decided to experiment with advertising your servicesTab "Advertising Data" reports your level of advertising and sales in a given month.Run a regression of monthly sales as explained by monthly advertising
4.1How much of the variation in sales is explained by variation in advertising?
4.2How many dollars in additional sales is associated with a $500 increase in advertising?4.3Is the relationship estimated between advertising and sales significantly different from zero with an alpha of .001?
4.4Predict the value of sales in a month where 10,000 dollars is spent on advertising4.5Which month is the greatest outlier (i.e. has the largest difference between the predicted and actual level of sales)
Month. Monthly Advertising Spend in Dollars Monthly Sales in Dollars
Oct-19 4000 13191160.24
Nov-19 4000 10233123.9
Dec-19 4000 11941947.89
Jan-20 4000 12751410.51
Feb-20 4000 12045086.95
Mar-20 8000 25195998.51
Apr-20 8000 24507341.52
May-20 8000 24328487.59
Jun-20 3000 9169755.783
Jul-20 3000 9523386.072
Aug-20 3000 8274147.961
Sep-20 0 28814.20085
Oct-20 0 26966.52866
Nov-20 0 28620.22904
Dec-20 0 36617.52363
Jan-21 10000 30633990.17
Feb-21 2000 5640806.105
Mar-21 6000 18151283.03
Apr-21 6000 18850482.91
May-21 5500 16755299.83
Step 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