Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the data set below, calculate the spearmans and pearson's correlation coefficient in excel. What does the calculated correlation value mean? Which method of calculating

For the data set below, calculate the spearmans and pearson's correlation coefficient in excel.

What does the calculated correlation value mean?

Which method of calculating the correlation coefficient is MOST suitable for the dataset and why?

DATA SET:

Hospital Room Size (square footage)

Electricity Bill

3117

186.435

1086

74.73

4276

250.18

4019

236.045

857

62.135

3114

186.27

1132

77.26

3427

203.485

690

52.95

4806

279.33

4052

234.86

173

21.515

1948

119.14

209

23.495

1175

76.625

3223

189.265

3950

229.25

4778

274.79

3089

181.895

1524

95.82

4082

236.51

276

36.18

478

47.29

1482

102.51

3933

237.315

1533

105.315

4095

246.225

4791

284.505

2893

180.115

1950

128.25

2263

145.465

4344

259.92

2805

175.275

4329

123.225

896

37.4

4671

131.775

146

18.65

1910

89

622

30.55

1422

50.55

2241

71.025

564

29.1

2972

89.3

123

18.075

2740

83.5

1342

48.55

246

21.15

1213

45.325

3558

103.95

2782

84.55

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Mathematics Mathematical Reasoning And Proof With Puzzles, Patterns, And Games

Authors: Douglas E Ensley, J Winston Crawley

1st Edition

1118226534, 9781118226537

More Books

Students also viewed these Mathematics questions

Question

Behaviour: What am I doing?

Answered: 1 week ago