Data analysis problem for finance 230

Here is the data.

Gulf View Condominiums			No Gulf View Condominiums
List Price	Sale Price	Days to Sell	List Price	Sale Price	Days to Sell
495.0	475.0	130	217.0	217.0	182
379.0	350.0	71	148.0	135.5	338
529.0	519.0	85	186.5	179.0	122
552.5	534.5	95	239.0	230.0	150
334.9	334.9	119	279.0	267.5	169
550.0	505.0	92	215.0	214.0	58
169.9	165.0	197	279.0	259.0	110
210.0	210.0	56	179.9	176.5	130
975.0	945.0	73	149.9	144.9	149
314.0	314.0	126	235.0	230.0	114
315.0	305.0	88	199.8	192.0	120
885.0	800.0	282	210.0	195.0	61
975.0	975.0	100	226.0	212.0	146
469.0	445.0	56	149.9	146.5	137
329.0	305.0	49	160.0	160.0	281
365.0	330.0	48	322.0	292.5	63
332.0	312.0	88	187.5	179.0	48
520.0	495.0	161	247.0	227.0	52
425.0	405.0	149
675.0	669.0	142
409.0	400.0	28
649.0	649.0	29
319.0	305.0	140
425.0	410.0	85
359.0	340.0	107
469.0	449.0	72
895.0	875.0	129
439.0	430.0	160
435.0	400.0	206
235.0	227.0	91
638.0	618.0	100
629.0	600.0	97
329.0	309.0	114
595.0	555.0	45
339.0	315.0	150
215.0	200.0	48
395.0	375.0	135
449.0	425.0	53
499.0	465.0	86
439.0	428.5	158

Prepare a managerial report the case study below. Data is on the Gulf Real Estate Properties: Case Problem 2 in Chapter 8, p. 3451. File: GulfProp Answer the questions provided in the case in the report. The purpose of the report is to use descriptive statistics for the agent to gain insight into the properties listed by Gulf. Include the following: Table of descriptive statistics; mean, median, mode, standard deviation, skewness, range, minimum, maximum. General Observations. Make a general statement about the statistics describing the data. Provide an interpretation of each of the variables. For example, you might say that the mean list price for condos with a view is $474K and highly variable ranging from X to Y. Which condominiums are more expensive, which are more variable, where are the least expensive? Are there any outliers? How long to sell and what is the difference in sale price vs. asking price? Provide the requested confidence intervals for questions 4 and 5. Solve for the sample size in question 6 using a margin of error of 40,000. The margin of error when n=40 is $59,600 for Gulf view condos and the margin of error for no view condos where n=18 is $21,800. You want to reduce the margin of error by increasing the sample size. Question 7 can be addressed by comparing the list price with the selling price across the samples. Prepare a managerial report the case study below. Data is on the Gulf Real Estate Properties: Case Problem 2 in Chapter 8, p. 3451. File: GulfProp Answer the questions provided in the case in the report. The purpose of the report is to use descriptive statistics for the agent to gain insight into the properties listed by Gulf. Include the following: Table of descriptive statistics; mean, median, mode, standard deviation, skewness, range, minimum, maximum. General Observations. Make a general statement about the statistics describing the data. Provide an interpretation of each of the variables. For example, you might say that the mean list price for condos with a view is $474K and highly variable ranging from X to Y. Which condominiums are more expensive, which are more variable, where are the least expensive? Are there any outliers? How long to sell and what is the difference in sale price vs. asking price? Provide the requested confidence intervals for questions 4 and 5. Solve for the sample size in question 6 using a margin of error of 40,000. The margin of error when n=40 is $59,600 for Gulf view condos and the margin of error for no view condos where n=18 is $21,800. You want to reduce the margin of error by increasing the sample size. Question 7 can be addressed by comparing the list price with the selling price across the samples