Calculate the average price and average value

Reference no: EM133715755

Question: 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

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

Reference no: EM133715755

Questions Cloud

Shock is delivered : After the shock is delivered (or if no shock is advised) you will switch from single-provider to multiple-provider CPR.

Discuss four broad activities that erode the value : Discuss four broad activities that erode the value of the kenyan currency. State key financial disciples that would reduce the pressure for foreign currency

History of stroke affecting the right side : History of stroke affecting the right side, right foot contracture, weakness, and right-sided heart failure Current situation

Which will cost you more, leasing or buying : The estimated value of the car at the end of 4 years is $11310. Without consideration for forgone interest, which will cost you more, leasing or buying

Calculate the average price and average value : Calculate the average price and average value, and time (days on market). Calculate the correlation between price and value, create a scatter plot of these

Explain the possible impact of each question : WCM 510- Explain the possible impact of each question, including whether it would improve the likelihood of success during the discussion(s).

How the the community alliance for youth empowerment : Explain how the the Community Alliance for Youth Empowerment (CAYE) relates to human rights issues. Explain how the problem affects other social justice issues.

Why were subprime mortgages so risky : Why were subprime mortgages so risky? Explain how bundling up many mortages into CDOs helps manage the risk of people not being able to pay their mortgage

What is the amount of withdrawal that is taxable : What if the $16,000 withdrawal is used to pay qualified education expenses for their daughter who is attending college?

User Account

All Pages