4. the researcher wishes to usenumerical descriptive measures to summarize the data on each of thetwo variables: hours worked per week and incomeearned per year.
- Prepare and display a numerical summary report for each of thetwo variables including summary measures such as mean, median,range, variance, standard deviation, smallest and largest valuesand the three quartiles.                           Â
Notes:Use QUARTILE.EXC command to generate the threequartiles.
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 of Hours worked and yearly income as below
| Yearly Income ('000's) | Hours Per Week |
| 43.8 | 18 |
| 44.5 | 13 |
| 44.8 | 18 |
| 46.0 | 25.5 |
| 41.2 | 11.5 |
| 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.5 |
| 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.8 | 43.5 |
| 62.0 | 20 |
| 57.3 | 35 |
| 55.3 | 24 |
| 56.1 | 20 |
| 61.5 | 41 |
