Third, the researcher wishes to use numerical descriptive measures to summarize the data on each of...

70.2K

Verified Solution

Question

Statistics

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

Answer & Explanation Solved by verified expert

3.7 Ratings (493 Votes)

Solution Here we solve this problem using the minitab statistical software as below Here discriptive summary of the given data is descriptive measures Yearly See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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