Question: please solve with equations in excel The monthly sales (in millions of dollars) and advertising expenditure (in S1000) of SABA, Inc. for twelve months are

please solve with equations in excel
please solve with equations in excel The monthly sales (in millions of

The monthly sales (in millions of dollars) and advertising expenditure (in S1000) of SABA, Inc. for twelve months are given below. a. Develop a scatter diagram of sales versus advertising. b. Use Excel's Regression function and determine the regression equation, defining sales as the dependent variable and advertising as the independent variable. c. If the company's advertising expenditure is $600,000, what is the predicted sales? Give the answer in dollars. d. What does the slope of the estimated regression line indicate? Give numerical explanation and be very specific.. c. Fully explain the meaning of coefficient of determination. Give numerical explanation. f. At 95% confidence, is the regression model is significant? Give values in your explanation

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 General Management Questions!