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
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.
| $214,037 | 63 | |
| $182,423 | 65 | |
| $239,123 | 50 | |
| $410,714 | 59 | |
| $181,848 | 63 | |
| $141,080 | 52 | |
| $215,776 | 43 | |
| $89,818 | 51 | |
| $253,607 | 50 | |
| $420,420 | 52 | |
| $255,771 | 39 | |
| $99,218 | 45 | |
| $358,820 | 45 | |
| $153,246 | 43 | |
| $158,916 | 40 | |
| $103,920 | 52 | |
| $211,214 | 47 | |
| $77,087 | 47 | |
| $126,735 | 60 | |
| $273,900 | 65 | |
| $270,900 | 60 | |
| $209,120 | 50 | |
| $80,250 | 35 | |
| $91,662 | 38 | |
| $98,449 | 42 | |
| $161,172 | 67 | |
| $273,900 | 59 | |
| $283,900 | 47 | |
| $81,648 | 34 | |
| $237,760 | 37 | |
| $234,463 | 51 | |
| $349,040 | 51 | |
| $152,569 | 40 | |
| $244,400 | 58 | |
| $260,100 | 47 | |
| $160,900 | 62 | |
| $308,420 | 49 | |
| $73,639 | 30 | |
| $186,900 | 49 | |
| $206,900 | 49 | |
| $207,535 | 42 | |
| $590,900 | 57 | |
| $262,100 | 42 | |
| $273,420 | 51 | |
| $65,296 | 49 | |
| $284,900 | 36 | |
| $284,900 | 60 | |
| $167,100 | 64 | |
| $250,420 | 53 | |
| $382,170 | 53 | |
| $301,300 | 64 | |
| $311,874 | 59 | |
| $175,250 | 33 | |
| $143,849 | 49 | |
| $196,400 | 51 | |
| $142,005 | 52 | |
| $250,900 | 60 | |
| $137,394 | 40 | |
| $258,900 | 44 | |
| $282,324 | 65 | |
| $200,900 | 51 | |
| $105,446 | 31 | |
| $140,155 | 49 | |
| $158,701 | 44 | |
| $162,338 | 69 | |
| $69,462 | 50 | |
| $274,500 | 49 | |
| $162,821 | 43 | |
| $238,900 | 43 | |
| $172,901 | 38 | |
| $186,430 | 53 | |
| $79,411 | 32 | |
| $238,320 | 45 | |
| $59,161 | 60 | |
| $138,720 | 38 | |
| $250,420 | 33 | |
| $284,400 | 50 | |
| $61,102 | 35 | |
| $36,295 | 56 | |
| $420,420 | 55 | |
| $148,312 | 44 | |
| $133,190 | 40 | |
| $83,709 | 52 | |
| $170,420 | 33 | |
| $102,720 | 29 | |
| $142,115 | 38 | |
| $300,900 | 46 | |
| $93,045 | 32 | |
| $143,093 | 33 | |
| $142,900 | 37 | |
| $75,043 | 41 | |
| $67,079 | 45 | |
| $134,997 | 36 | |
| $190,745 | 43 | |
| $114,284 | 39 | |
| $113,995 | 29 | |
| $146,412 | 35 | |
| $98,752 | 25 | |
| $102,143 | 28 | |
| $215,000 | 38 | |
| $270,900 | 64 | |
| $116,110 | 42 | |
| $270,634 | 49 | |
| $93,197 | 35 | |
| $84,435 | 62 | |
| $146,036 | 42 | |
| $128,073 | 52 | |
| $360,900 | 48 | |
| $129,302 | 36 | |
| $113,720 | 31 | |
| $131,320 | 49 | |
| $58,711 | 48 | |
| $97,280 | 38 | |
| $138,955 | 49 | |
| $111,916 | 46 | |
| $86,493 | 38 | |
| $233,400 | 60 | |
| $241,570 | 57 | |
| $70,666 | 32 | |
| $113,410 | 49 | |
| $188,208 | 62 | |
| $130,543 | 33 | |
| $85,670 | 27 | |
| $112,838 | 37 | |
| $125,200 | 50 | |
| $184,555 | 33 | |
| $96,270 | 30 | |
| $63,554 | 26 | |
| $317,982 | 58 | |
| $66,035 | 26 | |
| $115,920 | 52 | |
| $56,450 | 24 | |
| $234,500 | 44 | |
| $72,279 | 29 | |
| $105,756 | 40 | |
| $62,735 | 56 | |
| $220,358 | 48 | |
| $130,370 | 33 | |
| $86,660 | 35 | |
| $125,820 | 38 | |
| $130,420 | 30 | |
| $88,420 | 30 | |
| $101,092 | 31 | |
| $84,735 | 34 | |
| $98,752 | 28 | |
| $157,959 | 40 | |
| $72,146 | 33 | |
| $91,024 | 29 | |
| $280,900 | 58 | |
| $270,900 | 41 | |
| $137,480 | 39 | |
| $55,900 | 24 | |
| $260,900 | 48 | |
| $280,900 | 53 | |
| $270,900 | 59 | |
| $21,584 | 51 | |
| $58,192 | 35 | |
| $285,900 | 57 | |
| $104,150 | 28 | |
| $102,192 | 31 | |
| $280,900 | 55 | |
| $280,900 | 54 | |
| $428,400 | 56 | |
| $280,900 | 53 | |
| $322,820 | 39 | |
| $274,400 | 55 | |
| $163,720 | 34 | |
| $115,088 | 46 | |
| $280,900 | 40 | |
| $260,900 | 56 | |
| $354,620 | 51 | |
| $316,525 | 36 | |
| $238,400 | 49 | |
| $74,025 | 25 | |
| $132,900 | 37 | |
| $270,420 | 54 | |
| $200,420 | 29 | |
| $155,420 | 30 | |
| $80,420 | 28 | |
| $260,420 | 62 | |
| $84,020 | 35 | |
| $287,920 | 44 | |
| $280,420 | 51 | |
| $88,420 | 28 | |
| $121,420 | 33 | |
| $180,420 | 63 | |
| $180,420 | 26 | |
| $127,420 | 36 | |
| $88,420 | 25 | |
| $77,420 | 31 | |
| $115,920 | 47 | |
| $60,420 | 22 | |
| $280,420 | 40 | |
| $300,420 | 43 | |
| $60,420 | 25 | |
| $300,420 | 46 | |
| $60,420 | 24 | |
| $170,420 | 44 | |
| $60,920 | 22 | |
| $60,420 | 28 | |
| $95,420 | 26 | |
| $88,420 | 25 | |
| $60,420 | 23 | |
| $300,420 | 43 | |
| $60,420 | 22 | |
| $125,420 | 30 | |
| $280,420 | 42 | |
| $399,152 | 46 | |
| $270,151 | 40 | |
| $232,170 | 41 | |
| $255,420 | 33 | |
| $69,126 | 34 | |
| $104,920 | 25 | |
| $172,900 | 29 | |
| $90,164 | 47 | |
| $106,020 | 28 | |
| $104,920 | 38 | |
| $69,280 | 43 | |
| $136,406 | 46 | |
| $62,735 | 45 | |
| $117,900 | 46 | |
| $66,420 | 32 | |
| $50,420 | 23 | |
| $152,220 | 36 | |
| $200,420 | 48 | |
| Table A-6 | ||
| n | = 0.05 | = 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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
