Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following question based off of this excel spreadsheet. B C D E F G Company Salaried ($1000s)Y Rank X1 Hourly ($1000s) X2 X3

Answer the following question based off of this excel spreadsheet.

image text in transcribedimage text in transcribed
B C D E F G Company Salaried ($1000s)Y Rank X1 Hourly ($1000s) X2 X3 X4 Size 2 Wegmans Food Markets 56.0000 4.0000 29.0000 Large NetApp 143.0000 5.0000 76.0000 Midsize 4 Camden Property Trust 71.0000 7.0000 37.0000 Small 5 Recreational Equip ment (REI) 103.0000 8.0000 28.0000 Large Quicken Loans 78.0000 10.0000 54.0000 Midsize 7 Zappos.com 48.0000 1.0000 25,0000 Midsize Mercedes-Benz USA 118,0000 12.0000 50.0000 Small 9 USAA 96.0000 20.0000 47.0000 Large 10 The Container Store 71.0000 22.0000 45,0000 Midsize 11 Ultimate Software 166.0000 25.0000 56.0000 Small 12 Plante Moran 73,0000 37.0000 45.0000 Small 13 Baptist Health South Florida 126.0000 42.0000 80.0000 Large 14 World Wide Technology 129,0000 50.0000 31,0000 Small 15 Methodist Hospital 100.0000 53.0000 83.0000 Large 16 Perkins Coie 189.0000 58.0000 63.0000 Small 17 American Express 114,0000 50.0000 35.0000 Large 18 TDIndustries 93.0000 64.0000 47.0000 Small 19 Quik Trip 69.0000 56.0000 44.0000 Large 20 EOG Resources 189.0000 72.0000 81.0000 Small 21 FootSet Research Systems 103,0000 75.0000 51.0000 Small 22 Stryker 71.0000 80.0000 43,0000 Large 23 SRC 84.0000 81.0000 33,0000 Small 24 Booz Allen Hamilton 105.0000 84.0000 77.0000 Large 25 CarMax 57.0000 91.0000 34.0000 Large 26 GoDaddy.com 105.0000 93.0000 71.0000 Midsize 27 KPMG 79.0000 94.0000 59.0000 Large 28 Navy Federal Credit Union 77.0000 95,0000 39.0000 Midsize 29 Schweitzer Engineering Labs 99.0000 97.0000 28.0000 Small 30 Darden Restaurants 57.0000 99.0000 24.0000 - + Large 31 Intercontinental Hotels Group 63.0000 100,0000 26.0000 LargeQuestion 15 points] J Saved Determine the multiple regression equation. {keep 4 decimals] NOTE: We only have 2 dummy variables, and if you do not know why we only have 2 dummy variables (instead of 3}, please revisit the lecture video 9 and 10 in week 11; Also, if the coefficient is negative, your answer should include negative sign. Video 10: Computer skill 5.3: Hovvr to Use Excel to analyze Categorical independent variables .?In. X1+ X2+ X3+ X4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probability With Applications and R

Authors: Robert P. Dobrow

1st edition

1118241257, 1118241258, 978-1118241257

More Books

Students also viewed these Mathematics questions