Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Partial Differential Equations For Scientists And Engineers

Authors: Stanley J Farlow

1st Edition

0486134733, 9780486134734

More Books

Students also viewed these Mathematics questions

Question

1. How has the prototype approach identified key features of love?

Answered: 1 week ago