Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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