Part A

Use the “House Prices and Characteristics.xlsx” file posted with this assignment to obtain the correlation coefficient between the “Selling Price” and the “Size” variables in Excel.

You must submit your Excel file with the output as part of the assignment.

Part B

Interpret the correlation coefficient that you obtained in part (a), i.e., explain what the number means.

Selling Prices of Houses and other Characteristics Size (in
Selling Price (in
Square Number of Number of Garage
Thousands of $)
Feet)
Bedrooms
Baths
Dummy
172.7
2200
4
2
0
207.5
2300
5
2.5
0
198.9
2200
3
2
1
209.3
1900
6
2
1
252.3
2600
4
2
1
192.9
1900
4
2.5
1
209.3
2100
5
1.5
0
345.3
2600
8
2
1
326.3
2100
6
3
1
173.1
2200
2
1.5
1
187
1900
2
2
0
257.2
2100
2
2
1
233
2200
3
1.5
1
180.4
2000
2
2
0
234
1700
2
2
1
207.1
2000
2
2
1
247.7
2400
5
2
1
166.2
2000
3
2
1
177.1
1900
2
2
1
182.7
2000
4
2.5
0
216
2300
4
2
0
312.1
2600
6
2.5
1
199.8
2100
3
2
1
273.2
2200
5
3
1
206
2100
3
1.5
0
232.2
1900
3
1.5
1
198.3
2100
4
1.5
1
205.1
2000
3
2
0
175.6
2300
4
2
1
307.8
2400
3
3
1
269.2
2200
5
3
1
224.8
2200
3
2.5
1
171.6
2000
3
2
0
216.8
2200
3
2
1
192.6
2200
6
2
0 Pool
Dummy
1
1
1
1
0
1
0
0
0
1
0
0
0
0
0
0
0
1
0
1
0
0
0
0
1
1
1
1
1
1
0
0
1
0
1 Distance from
Town Center
(in Miles)
16
21
10
15
8
14
20
9
11
21
26
9
14
11
19
11
16
16
10
14
19
7
19
16
9
16
19
20
24
21
8
17
16
15
14 236.4
172.4
251.4
246
147.4
176
228.4
166.5
189.4
312.1
289.8
269.9
154.3
222.1
209.7
190.9
254.3
176
228.4
166.5
189.4
269.9
154.3
222.1
209.7
254.3
207.5
209.7
294
176.3
294.3
224
125
236.8
164.1
217.8
192.2
155.4
186.7
179
188.3 2200
2200
1900
2300
1700
2200
2300
1600
2200
2400
2000
2200
2000
2100
2200
2200
2500
2200
2300
1600
2200
2200
2000
2100
2200
2500
2100
2200
2100
2000
2400
1900
1900
2600
2300
2500
2400
2400
2500
2400
2100 5
3
3
6
6
4
3
3
4
7
6
5
2
2
5
3
4
4
3
3
4
5
2
2
5
4
3
4
2
2
7
3
2
4
4
3
2
4
5
3
6 2
2
2
3
2
2
1.5
2.5
2
3
3
2.5
2
2
2
2
2
2
1.5
2.5
2
2.5
2
2
2
2
2
2
2.5
2
2
2
1.5
2
2
2
2.5
2
2.5
2
2 1
0
1
1
0
1
1
0
1
1
1
1
0
1
1
1
1
1
1
0
1
1
0
1
1
1
0
1
1
0
1
1
0
1
0
0
0
0
0
1
1 0
0
0
0
1
0
0
1
0
0
0
1
0
0
1
1
1
0
0
1
0
1
0
0
1
1
1
1
0
1
0
1
0
1
0
0
0
1
1
1
1 20
23
12
7
12
15
17
19
24
13
21
11
13
9
13
18
15
15
17
19
24
11
13
9
13
15
10
19
13
17
8
6
18
17
19
12
16
16
21
10
15 227.1
173.6
188.3
310.8
293.7
179
188.3
227.1
173.6
188.3
189.4
312.1
289.8
269.9
154.3
222.1
209.7
190.9
190.9
254.3
176
228.4
166.5
189.4
177.1
182.7
216
312.1
199.8
273.2
206
232.2
198.3
205.1
175.6
307.8
269.2 2900
2100
2300
2900
2400
2400
2100
2900
2100
2300
2200
2400
2000
2200
2000
2100
2200
2200
2200
2500
2200
2300
1600
2200
1900
2000
2300
2600
2100
2200
2100
1900
2100
2000
2300
2400
2200 4
4
5
8
6
3
6
4
4
5
4
7
6
5
2
2
5
3
3
4
4
3
3
4
2
4
4
6
3
5
3
3
4
3
4
3
5 2
2.5
1.5
2
3
2
2.5
1.5
2
3
2
3
3
2.5
2
2
2
2
2
2
2
1.5
2.5
2
2
2.5
2
2.5
2
3
1.5
1.5
1.5
2
2
3
3 1
1
0
1
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
1
1
0
0
1
1
1
0
1
1
0
1
1
1 0
1
0
0
0
0
1
0
0
0
0
0
0
1
0
0
1
1
1
1
0
0
1
0
0
1
0
0
0
0
1
1
1
1
1
1
0 8
14
20
9
11
8
14
20
9
11
24
13
21
11
13
9
13
18
18
15
15
17
19
24
10
14
19
7
19
16
9
16
19
20
24
21
8

• 1493959767-final.docx

ComputerScienceExpert

(11)

Status NEW Posted 05 May 2017 04:05 AM My Price 11.00

-----------

Attachments

file 1493959771-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer