Question

Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of the two variables: hours worked per week and income earned per year.

b. Compute the correlation coefficient using the relevant Excel function to measure the direction and strength of the linear relationship between the two variables. Display and interpret the correlation 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

Answer 1

Solution:

Here we solve this problem using the minitab statistical software as below

Here discriptive summary of the given data is

descriptive measures	Yearly Income ('000's)	Hours Per Week
minimun	41.4	11.6
maximum	74.6	44.2
1st quartile	51.35	24.75
2nd quartile	56.2	30.5
3rd quartile	63.75	36
mode	55.3	34.5
IQR(inter quartile range)	12.4	11.25
mean	57.281	29.8508
sum	3608.7	1880.6

now find the correlation between both the variable using correl function in Excell and value pf correlation is

r = 0.6715

Comment : Here value of correlation is positive hence we say that there is positive relationship between Yearly Income ('000's) and Hours Per Week and value of correlation is lies between 0.3 to 0.7

hence we say that there is moderate positive linear relationship between Yearly Income ('000's) and Hours Per Week

Thank You..!!

please like it...