Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Advertising ($ thousands) Number of Agents Annual Sales ($ millions) 249 15 30 183 16 32 310 21 49 246 18 45 288 13 36
Advertising ($ thousands) | Number of Agents | Annual Sales ($ millions) |
249 | 15 | 30 |
183 | 16 | 32 |
310 | 21 | 49 |
246 | 18 | 45 |
288 | 13 | 36 |
248 | 21 | 43 |
256 | 20 | 40 |
241 | 19 | 41 |
Data for several different real estate companies is given. For each one we have the amount spent on advertising, the number of agents in the company and the annual sales (in millions) | |
a) | Find out if there is a significant relationship between Sales and Advertising and Number of Agents. |
b) | If the above is true, further examine if both x-variables are significant |
c) | Using the best model in this situation predict Sales when Advertising is 250,000 amd there are 17 agents. |
I want to know a), b) and c) answers and excel fomulars!
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