May I please get directions on how to make a multiple regression calculation using Excel with the following homework practice question? Thank you.
Data has been gathered to explain executive salaries from a variety of factors.
1of4 SALARY EXP EDUC ASSETS NUMSUP GENDER 164000 4 2 260 1500 male 212000 9 7 430 1500 male 137000 23 6 330 1700 female 194000 21 4 300 1700 male 188000 13 3 290 1800 male 252000 6 5 570 1900 male 207000 14 6 390 1200 male 203000 18 9 360 1800 male 180000 19 5 260 1400 male 209000 24 10 420 1600 male 277000 8 11 640 1300 male 142000 23 3 160 1100 male 191000 7 4 340 1600 male 146000 17 5 300 1900 female 172000 19 4 240 1800 male 177000 14 4 310 1200 male 156000 7 3 380 1300 female 165000 14 4 250 2000 male 230000 2 5 510 1300 male 145000 12 4 190 1200 male 242000 2 6 540 1700 male 229000 24 9 420 1200 male 247000 13 7 520 1400 male 279000 18 11 600 1700 male 203000 18 8 380 1300 male 152000 13 4 230 1300 male 189000 8 4 330 1000 male 150000 8 4 370 1400 female 196000 15 5 380 1700 male 182000 12 4 300 1900 male 175000 165000 268000 161000 267000 154000 150000 229000 265000 152000 152000 141000 70000 241000 165000 139000 234000 122000 192000 131000 232000 260000 268000 91000 172000 137000 258000 251000 198000 226000 210000 17 24 25 12 23 13 15 15 21 12 23 10 15 20 20 22 10 17 18 17 22 \\l 16 H l'H HU'IU'lO-b UJLOOWOWNNNUJLDNOWOOOWWKDUUOWOONl'hNNNUJ-b 20f4 240 420 610 280 580 220 210 600 570 330 230 160 150 570 280 180 600 210 300 290 440 590 570 160 410 150 590 590 350 640 440 2000 male 1000 female 1400 male 1500 male 1200 male 1400 male 1600 male 1800 female 1100 male 1900 female 1800 male 2000 male 1100 female 1000 male 1300 male 2000 male 1900 female 1800 female 2000 male 1500 female 1700 male 1300 male 1200 male 1700 female 1200 female 1100 male 1700 male 1300 male 1700 male 1300 female 1900 male 209000 242000 199000 153000 152000 233000 215000 278000 222000 125000 142000 199000 150000 265000 276000 140000 175000 112000 238000 203000 171000 232000 132000 280000 248000 194000 175000 222000 182000 175000 214000 10 @00me HI' H l'l'H HONNHNUJNH WOW-bm-bU'ILDN-bm-bU'ILDNU'IH 30f4 400 520 350 270 350 470 400 630 610 270 180 540 210 550 600 160 260 210 520 420 270 610 170 620 650 320 480 460 340 430 450 1400 male 1800 male 1000 male 1000 male 1300 female 1300 male 1500 male 1000 male 1900 female 1300 female 1400 male 1900 female 1700 male 1600 male 1900 male 1000 male 1200 male 1400 female 1800 male 1500 male 1400 male 1300 female 1900 male 1100 male 1900 female 1200 male 1300 female 1200 male 1300 male 1000 female 2000 male 140000 214000 220000 233000 160000 181000 172000 100000 15 19 13 25 24 12 12 \\lOO 12 NCDU'IU'I 4of4 320 380 430 650 190 300 290 160 2000 female 1100 male 1200 male 1800 female 1600 male 1500 male 1200 male 1200 female
