Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started