Question: Please use Multivariable regression in Excel to complete the question. Thank you! Sales Height Suit Cost Salary Expenses $ 100,000 180 1000 48 6000 $

Please use Multivariable regression in Excel to complete the question. Thank you!
| Sales | Height | Suit Cost | Salary | Expenses |
| $ 100,000 | 180 | 1000 | 48 | 6000 |
| $ 120,000 | 190 | 2000 | 30 | 5000 |
| $ 50,000 | 190 | 4000 | 35 | 4000 |
| $ 140,000 | 212 | 1300 | 80 | 4000 |
| $ 80,000 | 182 | 2500 | 70 | 3000 |
| $ 90,000 | 185 | 3400 | 60 | 3700 |
| $ 60,000 | 156 | 3000 | 30 | 4500 |
| $ 135,000 | 191 | 2000 | 80 | 6000 |
| $ 100,000 | 150 | 1800 | 69 | 4000 |
| $ 145,000 | 208 | 1700 | 89 | 8000 |
| $ 125,000 | 194 | 1800 | 65 | 6500 |
| $ 45,000 | 146 | 3000 | 40 | 2300 |
You just graduated and are now working in a car dealership. Your boss is wondering what makes a good salesperson and collected data for the dealership, which is found in the Q6 tab of the associated Excel file. (a) How does height affect the sales? (b) How does expenses affect the sales? (c) How does height affect the suit cost? (d) Predict the sales figure for an employee who is 187 cm tall, wears a $4,500 suit, is given a salary of $98,000, and racks up $7,000 of expenses
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
