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

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 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 Finance Questions!