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
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
Get step-by-step solutions from verified subject matter experts
