Description: A downloadable spreadsheet named CV of r was provided in the assessment instructions for you to use for this question. In some workplaces, the longer someone has been working within an organization, the better the pay is. Although seniority provides a way to reward long-serving employees, critics argue that it hinders recruitment. Jane, the CPO, wants to know if XYZ has a seniority pay system. Question: Based on the salary and age data in the spreadsheet, find the value of the linear correlation coefficient r, and the p-value and the critical value of r using alpha = 0.05. Determine whether there is sufficient evidence to support the claim of linear correlation between age and salary.

Search (Alt+Q) x AutoSave On Fg HR Sample Data . Last Modified: March 6 - Data Help Acrobat File Home Insert Page Layout Formulas Review View & Cut ab Wrap Text General Normal Bad Good Arial 10 ~ A" A" = = Paste [B Copy $ % " Conditional Format as Merge & Center Neutral Calculation Check Cell Formatting Table Format Painter Styles Clipboard Font Alignment Number Undo Al 1 X fx Age G H A B D E F Management Level Age * | Gender Country Race/Ethnicity Department Position Salary Marketing Senior Corporate Communications Specialist Employee $96,270 128 30 Female United States White Employee $63,554 United State Black or African American Sales Business Development Specialist 129 26 Male Vice President Human Capita Vice President 317,982 130 58 Male United States White Human Resources $66,035 United States White T Assoc Programmer/Analys Employee 131 26 Male Employee $115,920 52 Female United States White Customer Success Customer Success Manager 132 Marketing Partner Marketing Manager Employee $56,450 133 24 Female United States White Employee $234,500 134 44 Male States White Field Sales Major Account Manager Employee 29 Female United States Asian Technical Support Technical Support Engineer $72,279 135 Marketing Executive Assistant Employee $105,756 136 40 Female United States White $62,735 Desktop Support Technician Employee 137 56 Male United States Asian IT Director 6220,358 138 48 Male United States White Human Resources Director Recruiting 33 Female White Human Resources Senior HR Business Partner Employee $130,370 139 United States $86,660 United States White Marketing Senior Graphics Designer Employee 140 35 Female United States White Marketing Product Marketing Manager Employee $125,820 141 38 Female Employee $130,420 142 30 Male United States Asian Field Sales Enterprise Regional Account Manager Human Resources Senior Recruiter Employee $88,420 143 30 Female United States White Employee $101,092 Finance Senior Financial Planner/Analyst 144 31 Female United States White $84,735 omer Success Manage Employee 145 34 Male United States White Customer Success $98,752 146 28 Female United States Asian Engineering Software Development Engineer Employee Employee $157,959 147 40 Female United States White Sales Revenue Enablement Manager $72,146 Technical Support Engineer Employee 148 33 Male United States Asian Technical Support Senior Accountant Employee $91,024 149 29 Female United States White Finance Employee $280,900 United States White Field Sales Major Account Manager 150 58 Male Major Account Manager Employee $270,900 151 41 Male United States White Field Sales 152 39 Female Sales Employee $137,480 United States White Revenue Enablement Manager Employee $55,900 153 24 Male United States White Finance Sales Compensation Analyst $260,900 154 48 Male United States White Field Sales Major Account Manager Employee $280,900 Major Account Manager Employee 155 53 Male United States White Field Sales Major Account Manager Employee $270,900 156 59 Male United States White Field Sales Employee $21,584 157 51 Female United States White Facilities Receptionist II Employee $58, 192 158 35 Female United States White Finance Accounting Support Specialist II Employee 285,900 159 57 Male United States White Field Sales Major Account Manager $104, 150 Customer Success Manager Employee 160 28 Male United States Two or More Races Customer Success $102, 192 Asian Product Management UX Designer Employee 161 31 Male United States $280,900 United States White Field Sales Major Account Manage Employee 162 55 Male 54 Male States White Field Sales Major Account Manager Employee $280,900 163 Senior Vice President $428,400 164 56 Female United States White Product Man Senior Vice President Product Management Employee $280,900 165 53 Male United States White Field Sales Major Account Manager Vice President $322,820 Vice President Product Management 166 39 Female United States Asian Product Management Employee $274,400 167 55 Male White Field Sales Major Account Manager United States Senior Manager $163,720 168 34 Female United States White Finance Senior Manager Accounting Professional Services Services Project Manager Employee $115,088 169 46 Female United States White Employee $280,900 40 Female White Major Account Manager 170 United States Field Sales Dataset +Search (Alt+Q) * AutoSave On g HR Sample Data . Last Modified: March 6 - Home Insert Page Layout Formulas Review View Help Acrobat File Bad Good G X Cut ab Wrap Text General Normal Arial 10 ~ A A [B Copy Conditional Format as Neutral Calculation Check Cell Paste E Merge & Center Formatting Table ~ Format Painter Number Styles Alignment Undo Clipboard Font Al i X fx Age G H A B D Position Management Level . Salary Country Race/Ethnicity Department Age * | Gender Senior Corporate Communications Specialist Employee $96,270 United States Marketing Employee $63,554 128 30 Female White Sales Business Development Specialist $317,982 129 26 Male United States Black or African American Vice President Human Capital Vice President 130 58 Male United States White Human Resources IT Assoc Programmer/Analyst Employee $66,035 131 26 Male United States White Employee $115,920 52 Female United States Customer Success Customer Success Manager 132 White $56,450 Partner Marketing Manager Employee 133 Marketing 24 Female United States White Employee $234,500 Major Account Manager 44 Male United States White Field Sales 134 Technical Support Technical Support Engineer Employee $72,279 135 29 Female United States Asian $105,756 Executive Assistant Employee 136 40 Female United States White Marketing Employee $62,735 Desktop Support Technician 137 United States Asian IT 56 Male Human Resources Director $220,358 Director Recruiting 138 48 Male United States White Employee $130,370 Senior HR Business Partner 139 33 Female United State White Human Resources Senior Graphics Designe Employee $86,660 140 35 Female United States White Marketing Employee $125,820 141 38 Female United States White Marketing Product Marketing Manager Employee $130,420 142 30 Male United States Asian Field Sales Enterprise Regional Account Manager $88,420 White Human Resources Senior Recruiter Employee 143 30 Female United States $101,092 Finance Senior Financial Planner/Analyst Employee 144 31 Female United States White Customer Success Customer Success Manager Employee $84,735 145 34 Male United States White Software Development Engineer Employee $98,752 146 28 Female United States Asian Engineering Employee $157,959 147 40 Female United States White Sales Revenue Enablement Manager Employee $72, 146 148 33 Male United States Asian Technical Support Technical Support Engineer Employee $91,024 149 29 Female United States White Finance Senior Accountant $280,900 Major Account Manager Employee 150 58 Male United States Whit Field Sales Employee $270,900 Major Account Manager 151 41 Male United States White Field Sales Employee $137,480 152 39 Female United States White Sales Revenue Enablement Manager $55,900 Vhite Finance Sales Compensation Analyst Employee 153 24 Male United States Employee $260,900 Major Account Manager 154 48 Male United States White Field Sales White Major Account Manager Employee $280,900 155 53 Male United States Field Sales Field Sales Major Account Manager Employee $270,900 156 59 Male United States White Receptionist ll Employee $21,584 157 51 Female United States White Facilities Accounting Support Specialist II Employee $58, 192 158 35 Female United States White Finance Major Account Manager Employee 6285,900 159 57 Male United States White Field Sales Customer Success Customer Success Manager Employee $104, 150 160 28 Male United States Two or More Races Employee $102, 192 161 31 Male United States Asian Product Management UX Designer Employee $280,900 162 55 Male United States White Field Sales Major Account Manager Employee $280,900 163 54 Male United States White Field Sales Major Account Manager Senior Vice President $428,400 Product Management Senior Vice President Product Management $280,900 164 56 Female United States White Major Account Manager Employee United States White Field Sales $322,820 165 53 Male Product Management Vice President Product Management Vice President 166 39 Female United States Asian Employee $274,400 Field Sales Major Account Manager 167 55 Male United States White $163,720 Finance Senior Manager Accounting Senior Manager 168 34 Female United State White $115,088 Services Project Manager Employee 169 46 Female United States White Professional Services $280,900 White Major Account Manager Employee 170 40 Female United States Field Sales DatasetHR Sample Data . Last Modified: March 6 - Search (Alt+Q) x AutoSave On Fg File Home Insert Page Layout Formulas Data Review View Help Acrobat & Cut * 10 ~ A A = 29 Wrap Text General Normal Bad Good Arial Paste LG Copy $ % 9 08 2 Conditional Format as Neutral Calculation Check Cell BIUMAv E Merge & Center Formatting * Table Format Painter Number Styles Alignment Undo Clipboard Font A1 1 X fx Age H A B D E F G Position Management Level Salary Age * 1 Gender Country Race/Ethnicity Department $280,900 170 40 Female United States White Field Sales Major Account Manager Employee Employee $260,900 171 56 Female United States Asian Field Sales Major Account Manage Vice President $354,620 172 51 Male United States White Finance Vice President Corporate Development Senior Directo $316,525 173 36 Male United States Asian Product Management Senior Director Product Management $238,400 United States Product Management Senior Director Product Management Senior Director 174 49 Female Asian Employee $74,025 Services Consultant 175 25 Female United States White Customer Success Product Management UX Designer Employee $132,900 176 37 Female United States White Account Ma Employee $270,420 177 54 Male United States White Field Sales $200,420 178 White Solution Engineers Senior Solution Engineer Employee 29 Male United St Solution Engineers Solution Engineer Employee $155,420 179 30 Male United States White Employee $80,420 Senior Recruiter 180 28 Female United States Hispanic or Latino Human Resources Employee $260,420 62 Male Field Sales Major Account Manager 181 United States White $84,020 Content Specialist Employee 182 35 Female United States White Marketing Senior Director Demand Generation Senior Director $287,920 183 44 Female United States Hispanic or Latino Marketing $280,420 51 Male United States White Major Account Manage Employee 184 Field Sales Employee $88,420 Content Engineer 185 28 Mal United States Asian Engineering $121,420 186 33 Male United States White Finance Manager Accounting Manager $180,420 United States White Professional Services Manager Consulting Services Manager 187 63 Female Regional Account Manager Employee $180,420 188 26 Male United States White Field Sales Employee $127,420 Senior UX Designer 189 36 Female United States Hispanic or Latino Product Management Engineering Content Engineer Employee $88,420 190 25 Male United States Asian Employee $77,420 191 31 Female United States White Marketing Project Manager Creativ Employee $115,920 192 47 Male United States Hispanic or Latino Customer Success Customer Success Manager $60.420 White Business Development Specialist Employee 193 22 Male United States Sales Major Account Manager Employee $280,420 194 40 Male United States White Field Sales United States Field Sales Major Account Manager Employee $300,420 195 43 Male White $60,420 Business Development Specialist Employee 196 25 Male United States White Sales Field Sales Major Account Manager Employee $300,420 197 46 Male United States White Employee $60,420 198 24 Male United States White Sales Business Development Specialist $170,420 Solution Engineer Employee 199 44 Male United States White Solution Engineers Employee $60,920 United States Technical Support Engineer 200 22 Male White Technical Support Sales Business Development Specialist Employee $60,420 201 28 Male United States White $95,420 White Finance Senior Financial Planner/ Analyst Employee 202 26 Male United States $88,420 Content Engineer Employee 203 25 Male United States Asian Engineering Employee $60,420 204 23 Male United States White Sales Business Development Specialist Employee 300,420 205 43 Male United States White Field Sales Major Account Manager $60,420 22 Male United States White Sales Business Development Specialist Employee 206 Employee $125,420 Senior UX Designer 207 30 Female United States White Product Management $280,420 42 Male United States White Field Sales Major Account Manager Employee 208 Vice President White Vice President Engineering $399, 152 209 46 Male United States Engineering $270, 151 Senior Director Engineering Senior Director 210 40 Male United States White Engineering Director $232, 170 Engineering Director Software Development Engineering 211 41 Female United States Asian $255,420 212 33 Male White Field Sales Major Account Manager Employee United States 1. 10 DatasetSearch (Alt+Q) x AutoSave Only HR Sample Data . Last Modified: March 6 . File Home Insert Page Layout Formulas Data Review View Help Acrobat Good & Cut Arial 10 ~ A" A" = ab Wrap Text General Norma Bad [B Copy Conditional Format as Calculation Check Cell Paste Merge & Center Neutral Formatting * Table Format Painter Styles Alignment Number Undo Clipboard Font A1 : X fx Age G H D E F Management Level Salary Age * | Gender Race/Ethnicity Department Position Country Major Account Manager Employee $255,420 212 33 Male United States White Field Sales $69, 126 White Technical Support Senior Technical Support Engineer Employee 213 34 Male United States $104,920 Product Management Professional Employee 214 25 Female United States White Product Management $172,900 White Senior Solution Engineer Employee 29 Male United States Solution Engineers Employee $90, 164 215 47 Male White Technical Support Senior Technical Support Engineer 216 United States United States White Customer Success Employee $106,020 Customer Success Manager Employee $104,920 217 28 Female 218 38 Male United States White T Senior System Administrator $69,280 White Technical Support Technical Support Engineer Employee 219 136,406 43 Male United States Black or African American Professional Services Senior Services Consultant Employee 220 46 Male United States Employee $62,735 IT Senior Desktop Support Technician $117,900 221 45 Female United States White Senior Services Consultant Employee 46 Male United States White Professional Services Employee $66,420 222 Technical Support Engineer 223 32 Male United States White Technical Support $50,420 Desktop Support Specialist Employee 224 23 Male United States Hispanic or Latino T $152,220 225 United States Hispanic or Latino Customer Success Principal Technical Account Manager Employee 36 Male Solution Engineer Employee $200,420 Solution Engineers 226 48 Male United States White 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 Dataset +X AutoSave On ly CV of r . Last Modified: Tue at 5:50 PM . File Home Insert Page Layout Formulas Data Review X Cut Calibri 11 A Paste [ Copy BIU Format Painter Undo Clipboard Font D17 V X v fx A B C D E F 1 Table A-6 IN n a = 0.05 0 = 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 00 9 0.666 0.798 10 0.632 0.765 10 11 0.602 0.735 11 12 0.576 0.708 12 13 0.553 0.684 13 13 0.553 0.684 14 14 0.532 0.661 15 15 0.514 0.641 16 16 0.497 0.623 17 17 0.482 0.606 18 18 0.468 0.59 19 19 0.456 0.575 20 20 0.444 0.561 21 25 0.396 0.505 22 30 0.361 0.463 23 35 0.335 0.43 24 40 0.312 0.402 25 45 0.294 0.378 26 50 0.279 0.361 27 60 0.254 0.33 28 70 0.236 0.305 29 80 0.22 0.286 30 90 0.207 0.269 31 100 0.196 0.256 32 33 34 35 36AutoSave (On ) by HR Sample Data . Last Modified: March 6 Search (Alt+Q) X Home Insert Formulas Data Review View Help Acrobat File Page Layout X Cut 10 ~ A" A" = 27 ab Wrap Text General Norma Bad Good Arial De Check Cell Insert Paste LG Copy Conditional Format as Neutral BI UvvLAV Merge & Center $ ~ % 9 08 28 Calculation Formatting Table Format Painter Number Styles Font Alignment Undo Clipboard A1 : X fx Age G H D E F A Y Salary Y Position Management Level Age * Gender Country Race/Ethnicity Department Employee $214,037 Engineering Program Manager Ill 63 Male United States White Engineering $182,423 Principal Solution Engineer Employee 65 Male United States White Solution Engineers $239, 123 United States White Engineering Senior Director Engineering Senior Director 50 Male Vice President $410,714 Vice President Corporate Development 59 Male United States White Strategic Growth Field Sales Regional Account Manage Employee $181,848 SOO VOM AWN 63 Female United States White Principal II Technical Support Engineer Employee $141,080 62 Male United States White Technical Support Senior Direct $215,776 43 Female United States White Technical Support Senior Director Technical Support Employee $89,818 United States Technical Support Senior Technical Support Engineer 51 Female Black or African American 253,607 Asian Senior Director Systems Programming Management Senior Director 50 Male United States Senior Vice President $420,420 11 United States White Human Resources SVP Human Resources 52 Female Regional Vice President $255,771 12 39 Female United States White Renewal Regional Vice President Renewal Sales $99,218 45 Female United States Marketing Senior Web Editor Employee 13 White United States White Finance Vice President & Controller Vice President $358,820 14 45 Male Employee $153,246 15 43 Male United States White Engineering Staff Software Development Engineer Solution Engineers Senior Solution Engineer Employee $158,916 16 40 Male United States White RFP Response Write Employee $103,920 52 Male d States White Solution Engineer: Employee $211,214 18 47 Female United States White Product Management Principal Product Management Senior Technical Support Engineer Employee $77,087 19 47 Male United States White Technical Support Employee $126,735 20 White IT Programmer/Analyst 60 Female United States Major Account Manager Employee $273,900 21 65 Male United States White Field Sales Employee $270,900 Field Sales Major Account Manager 60 Male United States White Director $209, 120 50 Female United States White Finance Director Accounting Employee $80,250 35 Male United States Asian Technical Support Senior Technical Support Engineer Asian Technical Support Principal I Technical Support Engineer Employee $91,662 38 Female United States Technical Su Senior Technica Employee $98,449 42 Male United States Asian White Staff Software Development Engineer Employee $161, 172 67 Female United States Engineering $273,900 United States White Field Sales Major Account Manage Employee 59 Male Field Sales Major Account Manage Employee $283,900 29 47 Male United States White Employee $81,648 34 Male United States White Technical Support Senior Technical Support Engineer $237,760 37 Female United States White Finance Senior Director Accounting Senior Direct Director $234,463 51 Male United States Asian Product Management Director Product Management 32 $349,040 White Marketing Vice President Product Marketing Vice President 51 Female United States Employee $152,569 34 40 Female United States Asian Engineering Staff Software Development Engineer Employee $244,400 United States White Solution Engineers Principal Solution Engineer 35 58 Male Field Sales Major Account Manager Employee $260, 100 36 47 Male United States White Employee $160,900 Principal Solution Engineer 37 62 Male United States White Solution Engineers Vice President $308,420 38 49 Male United States White Finance Vice President Finance Technical Support Senior Technical Support Engineer Employee $73,639 39 30 Male United States Asian $186,900 Senior Solution Engineer Employee 40 49 Female United States White Solution Engineers $206,900 Solution Engineers Employee United States White Principal Solution Engineer 49 Male $207,535 White IT Director Business Applications Director 42 42 Female United States $590,900 43 57 Male United States White Field Sales Vice President Sales Vice President Employee $262, 100 United States White Field Sales Major Account Manager 44 42 Male DatasetSearch (Alt+Q) x AutoSave On 49 HR Sample Data . Last Modified: March 6 - File Home Insert Page Layout Formulas Data Review Help Acrobat A Cut General Normal Bad Good Arial 10 ~ A A" = E ab Wrap Text Paste LG Copy Conditional Format as E = Merge & Center $ ~ % 9 08 28 Neutral Calculation Check Cell Formatting Table * Format Painter Styles Font Number Undo Clipboard Alignment A1 i X fx Age F G H A B D Position Management Level Salary Age * | Gender Country Race/Ethnicity Department $262, 100 42 Male United States White Field Sales Major Account Manager Employee 44 Employer $273,420 Major Account Manager 45 51 Male United States White Field Sales $65,296 46 49 Female United States White Sales Revenue Enablement Coordinator Employee Employee $284,900 47 36 Male United States White Field Sales Major Account Manager Field Sales Major Account Manager Employee $284,900 48 60 Male United States White Senior Solution Engineer Employee $167, 100 49 64 Female United States White Solution Engineers $250,420 Major Account Manager Employee 50 53 Male United States White Field Sales Vice President Global Alliances Vice President $382, 170 63 Female United States White Alliances Employee $301,300 64 Male United States White Field Sales Strategic Account Manager $311,874 White Solution Engineers Business Value Advisor Employee 59 Male United States Employee $175,250 33 Male United States White Solution Engineers Solution Architect Employe $143,845 49 Male United States Black or African American Professional Services Senior Services Consultant United States White Solution Engineers Business Value Advisor Employee $196,400 51 Male Employee $142,005 52 Male United States White Professional Services Principal I Services Consultant Employee $250,900 60 Male United States White Field Sales Major Account Manage Senior Software Development Engineer Employee $137,394 40 Male United States White Engineering Director $258,900 United States Vhite Director Sales Operations 44 Female Sales Director 6282,324 65 Male United States Asian Customer Success Director Consulting Services $200,900 United States White Field Sales Major Account Manager Employee 51 Female $105,446 Services Project Manager II 31 Female United States Professional Services Employee Asia I States White Professional Services Principal I Services Consultant Employee $140, 155 49 Male $158,701 44 Female White Professional Service Manager United States Manager Consulting Services Professional Services Services Project Manager II Employee $162,338 69 Male United States White Employee $69,462 50 Female United State: White Finance Credit/Collections Support Specialist Ill Major Account Manager Employee $274,500 19 Male United States White Field Sales Employee $162,821 Senior Solution Engineer 43 Male United States White Solution Engineers Director $238,900 43 Male United States Hispanic or Latino Customer Success Director Customer Success Employee $172,901 38 Male United States White Solution Engineers Senior Solution Engineer Senior Solution Engineer Employee $186,430 53 Male United States White Solution Engineers Employee $79,411 32 Female United States Asian Finance Senior Accountant Senior Director Financial Planning/Analysis Senior Director $238,320 45 Female United States White Finance Credit/Collections Support Specialist II $59, 161 Finance Employee 75 60 Female United States White $138,720 Channel Account Manager IV Employee 76 38 Female United States White Alliances 77 33 Male United States Field Sales Employee $250,420 White Major Account Manager Employee $284,400 Major Account Manager 78 50 Male United States Black or African American Field Sales Payroll Analyst/Administrator Employee $61, 102 79 35 Female United States White Finance Employee 80 White Accounting Support Specialist II $36,295 56 Female United States Finance Vice President $420,420 81 55 Male United States White IT Vice President Information Technology Senior Manager Business Applications Senior Manager $148,312 82 44 Female United States White IT Manager Accounting Manage $133, 190 83 40 Female United States White Finance Senior Desktop Support Technician Employee $83,709 84 IT 62 Female United States White $170,420 Human Resources Director HR Business Director 85 33 Female United States White $102,720 Customer Success Manager Employee 86 29 Female United States White Customer Success Dataset +