Third, the researcher wishes to use numerical descriptivemeasures to summarize the data on each of the two variables: hoursworked per week and income earned per year.
b. Compute the correlation coefficient using the relevant Excelfunction to measure the direction and strength of the linearrelationship between the two variables. Display and interpret thecorrelation value. Â Â Â Â
Data for HOURSWORKED63 Excel spreadsheet is below:
| Yearly Income ('000's) | Hours Per Week |
| 43.8 | 18 |
| 44.5 | 13 |
| 44.8 | 18 |
| 46.0 | 25.5 |
| 41.4 | 11.6 |
| 43.3 | 18 |
| 43.6 | 16 |
| 46.2 | 27 |
| 46.8 | 27.5 |
| 48.2 | 30.5 |
| 49.3 | 24.5 |
| 53.8 | 32.5 |
| 53.9 | 25 |
| 54.2 | 23.5 |
| 50.5 | 30.5 |
| 51.2 | 27.5 |
| 51.5 | 28 |
| 52.6 | 26 |
| 52.8 | 25.5 |
| 52.9 | 26.5 |
| 49.5 | 33 |
| 49.8 | 15 |
| 50.3 | 27.5 |
| 54.3 | 36 |
| 55.1 | 27 |
| 55.3 | 34.5 |
| 61.7 | 39 |
| 62.3 | 37 |
| 63.4 | 31.5 |
| 63.7 | 37 |
| 55.5 | 24.5 |
| 55.6 | 28 |
| 55.7 | 19 |
| 58.2 | 38.5 |
| 58.3 | 37.5 |
| 58.4 | 18.5 |
| 59.2 | 32 |
| 59.3 | 35 |
| 59.4 | 36 |
| 60.5 | 39 |
| 56.7 | 24.5 |
| 57.8 | 26 |
| 63.8 | 38 |
| 64.2 | 44.2 |
| 55.8 | 34.5 |
| 56.2 | 34.5 |
| 64.3 | 40 |
| 64.5 | 41.5 |
| 64.7 | 34.5 |
| 66.1 | 42.3 |
| 72.3 | 34.5 |
| 73.2 | 28 |
| 74.2 | 38 |
| 68.5 | 31.5 |
| 69.7 | 36 |
| 71.2 | 37.5 |
| 66.3 | 22 |
| 66.5 | 33.5 |
| 66.7 | 37 |
| 74.6 | 43.5 |
| 62.0 | 20 |
| 57.3 | 35 |
| 55.3 | 24 |
