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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!