Find the regression equation (round to one significant digit) using the salary and age data. Use variable y to denote salary and variable x to denote age. Use the equation to predict the salary for someone who is 40 years old. Please see the attachments as it contains all of the data.

234 X fx A B C D E F Table A-6 n a = 0.05 a = 0.01 4 0.95 0.99 5 0.878 0.959 6 0.811 0.917 7 0.754 0.875 8 0.707 0.834 9 0.666 0.798 10 0.632 0.765 11 0.602 0.735 12 0.576 0.708 13 0.553 0.684 13 0.553 0.684 14 0.532 0.661 15 0.514 0.641 16 0.497 0.623 17 0.482 0.606 18 0.468 0.59 19 0.456 0.575 20 0.444 0.561 25 0.396 0.505 30 0.361 0.463 35 0.335 0.43 40 0.312 0.402 45 0.294 0.378 50 0.279 0.361 60 0.254 0.33 70 0.236 0.305 80 0.22 0.286 90 0.207 0.269 100 0.196 0.256 Table A-6 Critical Values of r +i Excel File Edit View Insert Format Tools Data Window Help 0 AutoSave .orr Q P) '9 v G a Copy of HR Sample Data f" 93: Arial 10 At A\" E = 9'7 3" w , ' ' l' "'59" " " v v v i ; cg rap Text v General v 'rl v 2% v 4/ v Z? v p v n3 v _ _ _ _ I 0 on _ ~ " I 55x Delete v l, v . | S or B I H v v 0 v A v = = = _ a $ v % ' as 2:341:42": $133; 33;; H v o v i112? 23:3. A313? A1 : fx Age v A B C D E F G H 1 Age 1 V Gender 1 V Country 1V1 RaceIEthnicity 1V Department 1" Position 1V1 Management Level 1V1 Salary Vl 2 63 Male United States White Engineering Engineering Program Manager I\" Employee $214,037 3 65 Male United States White Solution Engineers Principal Solution Engineer Employee $182,423 4 50 Male United States White Engineering Senior Director Engineering Senior Director $239,123 5 59 Male United States White Strategic Growth Vice President Corporate Development Vice President $410,714 6 63 Female United States White Field Sales Regional Account Manager Employee $181,848 7 52 Male United States White Technical Support Principal || Technical Support Engineer Employee $141,080 8 43 Female United States White Technical Support Senior Director Technical Support Senior Director $215,776 9 51 Female United States Black or African American Technical Support Senior Technical Support Engineer Employee $89,818 10 50 Male United States Asian IT Senior Director Systems Programming Management Senior Director $253,607 11 52 Female United States White Human Resources SVP Human Resources Senior Vice President $420,420 12 39 Female United States White Renewals Regional Vice President Renewal Sales Regional Vice President $255,771 13 45 Female United States White Marketing Senior Web Editor Employee $99,218 14 45 Male United States White Finance Vice President& Controller Vice President $358,820 15 43 Male United States White Engineering Staff Software Development Engineer Employee $153,246 16 40 Male United States White Solution Engineers Senior Solution Engineer Employee $158,916 17 52 Male United States White Solution Engineers RFP Response Writer Employee $103,920 18 47 Female United States White Product Management Principal Product Management Employee $211,214 19 47 Male United States White Technical Support Senior Technical Support Engineer Employee $77,087 20 60 Female United States White lT Programmer/Analyst Employee $126,735 21 65 Male United States White Field Sales Major Account Manager Employee $273,900 22 60 Male United States White Field Sales Major Account Manager Employee $270,900 23 50 Female United States White Finance Director Accounting Director $209,120 24 35 Male United States Asian Technical Support SeniorTechnical Support Engineer Employee $80,250 25 38 Female United States Asian Technical Support Principal ITechnical Support Engineer Employee $91,662 26 42 Male United States Asian Technical Support Senior Technical Support Engineer Employee $98,449 27 67 Female United States White Engineering Sta Software Development Engineer Employee $161,172 28 59 Male United States White Field Sales Major Account Manager Employee $273,900 29 47 Male United States White Field Sales Major Account Manager Employee $283,900 30 34 Male United States White Technical Support SeniorTechnicaI Support Engineer Employee $81,648 31 37 Female United States White Finance Senior Director Accounting Senior Director $237,760 32 51 Male United States Asian Product Management Director Product Management Director $234,463 33 51 Female United States White Marketing Vice President Product Marketing Vice President $349,040 34 40 Female United States Asian Engineering Statt Software Development Engineer Employee $152,569 35 58 Male United States White Solution Engineers Principal Solution Engineer Employee $244,400 36 47 Male United States White Field Sales Major Account Manager Employee $260,100 37 62 Male United States White Solution Engineers Principal Solution Engineer Employee $160,900 38 49 Male United States White Finance Vice President Finance Vice President $308,420 M on u..- .e a.-." A 1-..1\" -tom 0 .7. .s re 1... 0-16 can Dataset + Ready Accessibility: Good to go El 1-1 - + 120% i Excel File Edit View Insert Format Tools Data Window Help 0 AutoSave .orr Q P) '9 v G a Copy of HR Sample Data f" v )1, Arial v 10 v AA Av E E E '0'? v 253 Wrap Text v General v "r' v j v j v '67: men V V v v p v n3\" ___ _ _ I 0 on '_ J " tibeeIerev ch . s B I H , v 0 v A v = = = : 2 e $ v % ' as 2:341:42": ms; 33;; H v o v 5:12;? 23:3. A323? A1 : fx Age v A B C D E F G H 1 Age 1 V Gender 1 V Country lVl RaceIEthnicity lv Department 1" Position lVl Management Level lVl Salary Vl 38 49 Male United States White Finance Vice President Finance Vice President $308,420 39 30 Male United States Asian Technical Support SeniorTechnical Support Engineer Employee $73,639 40 49 Female United States White Solution Engineers Senior Solution Engineer Employee $186,900 41 49 Male United States White Solution Engineers Principal Solution Engineer Employee $206,900 42 42 Female United States White IT Director Business Applications Director $207,535 43 57 Male United States White Field Sales Vice President Sales Vice President $590,900 44 42 Male United States White Field Sales Major Account Manager Employee $262,100 45 51 Male United States White Field Sales Major Account Manager Employee $273,420 46 49 Female United States White Sales Revenue Enablement Coordinator Employee $65,296 47 36 Male United States White Field Sales Major Account Manager Employee $284,900 48 60 Male United States White Field Sales Major Account Manager Employee $284,900 49 64 Female United States White Solution Engineers Senior Solution Engineer Employee $167,100 50 53 Male United States White Field Sales Major Account Manager Employee $250,420 51 53 Female United States White Alliances Vice President Global Alliances Vice President $382,170 52 64 Male United States White Field Sales Strategic Account Manager Employee $301,300 53 59 Male United States White Solution Engineers Business Value Advisor Employee $311,874 54 33 Male United States White Solution Engineers Solution Architect Employee $175,250 55 49 Male United States Black or African American Professional Services Senior Services Consultant Employee $143,549 56 51 Male United States White Solution Engineers Business Value Advisor Employee $196,400 57 52 Male United States White Professional Services Principal | Services Consultant Employee $142,005 58 60 Male United States White Field Sales Major Account Manager Employee $250,900 59 40 Male United States White Engineering Senior Soware Development Engineer Employee $137,394 50 44 Female United States White Sales Director Sales Operations Director $258,900 51 65 Male United States Asian Customer Success Director Consulting Services Director $282,324 62 51 Female United States White Field Sales Major Account Manager Employee $200,900 63 31 Female United States Asian Professional Services Services Project Manager II Employee $105,446 64 49 Male United States White Professional Services Principal I Services Consultant Employee $140,155 65 44 Female United States White Professional Services Manager Consulting Services Manager $155,701 66 69 Male United States White Professional Services Services Project Manager II Employee $162,338 67 50 Female United States White Finance Credit/Collections Support Specialist "I Employee $69,462 68 49 Male United States White Field Sales Major Account Manager Employee $274,500 69 43 Male United States White Solution Engineers Senior Solution Engineer Employee $162,821 70 43 Male United States Hispanic or Latino Customer Success Director Customer Success Director $238,900 71 38 Male United States White Solution Engineers Senior Solution Engineer Employee $172,901 72 53 Male United States White Solution Engineers Senior Solution Engineer Employee $186,430 73 32 Female United States Asian Finance SeniorAccountant Employee $79,411 74 45 Female United States White Finance Senior Director Financial Planning/Analysis Senior Director Dataset + Ready Accessibility: Good to go El J-l - + 120% i Excel File Edit View Insert Format Tools Data Window Help Q AutoSave .orr Q P) '9 v G a Copy of HR Sample Data f" 93: Arial 10 AA A\" E = 9'7 v 3" w , ' ' l' F\" "'59" " " v v v i ; cg rap Text v General v 'r v J v 4/ v Z? v p v [a v ' J " tit-ix Delete v i, v s: B I 9v v 0 v A v a a a e a a $v% ' $8 4'8 2:312:11: mama; 33,12, ~ o v i112? 2212: A121? A1 : fx Age v A B C D E F G H 1 Age l V Gender l V Country lVl RaceIEthnicity lv Department lVl Position lVl Management Level lVl Salary Vl 75 60 Female United States White Finance Credit/Collections Support Specialist II Employee $59,161 75 38 Female United States White Alliances Channel Account Manager IV Employee $138,720 77 33 Male United States White Field Sales Major Account Manager Employee $250,420 78 50 Male United States Black or African American Field Sales Major Account Manager Employee $284,400 79 35 Female United States White Finance Payroll Analyst/Administrator Employee $61,102 80 56 Female United States White Finance Accounting Support Specialist II Employee $36,295 81 55 Male United States White IT Vice President Information Technology Vice President $420,420 82 44 Female United States White lT Senior Manager Business Applications Senior Manager $148,312 83 40 Female United States White Finance Manager Accounting Manager $133,190 84 52 Female United States White IT Senior Desktop Support Technician Employee $83,709 85 33 Female United States White Human Resources Director HR Business Director $170,420 85 29 Female United States White Customer Success Customer Success Manager Employee $102,720 87 35 Female United States Asian Engineering Senior Software Development Engineer Employee $142,115 88 46 Male United States White Field Sales Major Account Manager Employee $300,900 89 32 Female United States Asian Finance Senior Accountant Employee $93,045 90 33 Male United States Asian Engineering Senior Software Development Engineer Employee $143,093 91 37 Male United States White Solution Engineers Solution Engineer Employee $142,900 92 41 Male United States White Technical Support Senior Technical Support Engineer Employee $75,043 93 45 Female United States White Finance Credit/Collections Support Specialist "I Employee $67,079 94 36 Male United States White Finance Senior Manager Accounting Senior Manager $134,997 95 43 Female United States White Human Resources Director Employee Communications Director $190,745 96 39 Female United States White Professional Services Senior SeNices Consultant Employee $114,284 97 29 Male United States Asian Engineering Software Development Engineer Employee $113,995 98 35 Male United States Asian Engineering Staff Software Development Engineer Employee $146,412 99 25 Male United States Asian Engineering Software Development Engineer Employee $98,752 100 28 Male United States Asian Engineering Software Development Engineer Employee $102,143 101 38 Male United States White Solution Engineers Senior Solution Engineer Employee $215,000 102 64 Male United States White Field Sales Major Account Manager Employee $270,900 103 42 Male United States White Professional Services Services Consultant Employee $116,110 104 49 Male United States Asian Engineering Director Software Development Engineering Director $270,634 105 35 Male United States Asian Technical Support Technical Support Engineer Employee $93,197 106 62 Male United States White Engineering Data Researcher Employee $84,435 107 42 Male United States Asian Product Management Product Management Professional Employee $146,036 108 52 Male United States White Professional Services Services Consultant Employee $128,073 109 48 Female United States White Field Sales Regional Vice President Field Sales Regional Vice President $360,900 110 36 Male United States Asian Engineering Senior Software Development Engineer Employee $129,302 111 31 Female United States White Product Management Senior UX Designer Employee $113,720 Dataset + + 120% Ready Accessibility: Good to go i Excel File Edit View Insert Format Tools Data Window Help Q AutoSave .orr Q P) '9 v G a Copy of HR Sample Data f" 93: Arial v 10 v A A\" E = 4'7 v ab Wra r v G , ' ' l' 1"\" "'59" V V v i ; Cy p ext eneral v 'r v v v v v p v [E v ' \"4/ x Delete v t v Z e B I 9v v 0 v A v a a a s a a $v% ' $8 4'8 2:312:21: 3:13;; 33,125 ~ o v i112? 2212: 43:1: A1 : fx Age v A B C D E F G H 1 Age 1 V Gender i V Country i'i RaceIEthnicity iv Department i'i Position i'i Management Level i'i Salary 'i 112 49 Female United States White Finance Executive Assistant Employee $131,320 113 48 Female United States White Finance Credit/Collections Support Specialist "I Employee $58,711 114 38 Female United States White Finance Senior Accountant Employee $97,280 115 49 Female United States Asian IT Senior Manager IT Operations Senior Manager $138955 116 46 Female United States White Marketing Event Marketing Manager Manager $111,916 117 38 Female United States Asian Finance Sales Compensation Analyst Employee $86,493 118 60 Male United States White Solution Engineers Business Value Adviser Employee $233.400 119 57 Female United States White Technical Support Vice PresidentTechnical Support Vice President $241,570 120 32 Male United States Asian lT Senior Desktop Support Specialist Employee $70,666 121 49 Female United States White Sales Executive Assistant Employee $113,410 122 62 Male United States White Marketing Senior Director Content Senior Director $188,208 123 33 Female United States White Marketing Senior Manager Marketing Channels and Operations Senior Manager $130,543 124 27 Female United States White Marketing Senior Digital Marketing Manager Employee $85,670 125 37 Male United States Two or More Races Customer Success Senior Services Consultant Employee $112838 126 50 Female United States White Customer Success Principal Technical Account Manager Employee $125,200 127 33 Male United States Two or More Races Engineering Senior Manager Site Reliability Engineering Senior Manager $184,555 128 30 Female United States White Marketing Senior Corporate Communications Specialist Employee $96,270 129 26 Male United States Black or African American Sales Business Development Specialist Employee $63,554 130 58 Male United States White Human Resources Vice President Human Capital Vice President $317,982 131 26 Male United States White lT Assoc Programmer/Analyst Employee $66,035 132 52 Female United States White Customer Success Customer Success Manager Employee $115920 133 24 Female United States White Marketing Partner Marketing Manager Employee $56,450 134 44 Male United States White Field Sales Major Account Manager Employee $234,500 135 29 Female United States Asian Technical Support Technical Support Engineer Employee $72279 136 40 Female United States White Marketing Executive Assistant Employee $105,756 137 56 Male United States Asian lT Desktop Support Technician Employee $62,735 138 48 Male United States White Human Resources Director Recruiting Director $220,358 139 33 Female United States White Human Resources Senior HR Business Partner Employee $130,370 140 35 Female United States White Marketing Senior Graphics Designer Employee $86,660 141 38 Female United States White Marketing Product Marketing Manager Employee $125,820 142 30 Male United States Asian Field Sales Enterprise Regional Account Manager Employee $130.420 143 30 Female United States White Human Resources Senior Recruiter Employee $88,420 144 31 Female United States White Finance Senior Financial Planner/Analyst Employee $101,092 145 34 Male United States White Customer Success Customer Success Manager Employee $84735 146 28 Female United States Asian Engineering Soware Development Engineer Employee $98,752 147 40 Female United States White Sales Revenue Enablement Manager Employee $157,959 148 33 Male United States Asian Technical Support Technical Support Engineer Employee $72,146 4 an on own, I New ovum. mm, comm. e,...:,,, MANN\". Ema-MN. mm n'IA Dataset + + 120% Ready Accessibility: Good to go i Excel File Edit View Insert Format Tools Data Window Help Q AutoSave .orr Q P) '9 v G a Copy of HR Sample Data f" 93: Arial v 10 v A A\" E = 9'7 v ab Wra T v G . ' ' l' 1"\" "'59" V V v i ; c