Financial analysis requires sharp Excel skills, Real Estate Finance and Investments is no different. Starting next week, we will begin covering quantitative topics in Real Estate Finance. To practice,please complete the following analytical and data management tasks on th e Excel file:

Price($000)	Assessed Value	Type	Time
194.10	178.17	0	10
201.90	180.24	0	10
188.65	174.03	1	11
215.50	186.31	1	2
187.50	175.22	1	5
172.00	165.54	1	4
191.50	172.43	1	17
213.90	185.61	1	13
169.34	160.80	1	6
196.90	181.88	0	5
196.00	179.11	1	7
161.90	159.93	1	4
193.00	175.27	1	11
209.50	185.88	0	10
193.75	176.64	1	17
206.70	184.36	1	12
181.50	172.94	1	5
194.50	176.50	0	14
169.00	166.28	1	1
196.90	179.74	0	3
186.50	172.78	1	14
197.90	177.90	0	12
183.00	174.31	1	11
197.30	179.85	0	12
200.80	184.78	0	2
197.90	181.61	0	6
190.50	174.92	1	12
197.00	179.98	0	4
192.00	177.96	1	9
195.90	179.07	0	12

2. Sort the data from smallest to largest by price.
4. Calculate the average price and average value, and time (days on market).
6. Calculate the correlation between price and value, create a scatter plot of these two variables with proper labels