Reference no: EM131135508
Gulf Real Estate Properties
Gulf Real Estate Properties, Inc. is a real estate firm located in southwest Florida. The company, which advertises itself as an "expert in the real estate market," monitors condominium sales by collecting data on location, list price, sale price, and the number of days it takes to sell each unit. Each condominium is classified as Gulf View if it is located directly on the Gulf of Mexico, or No Gulf View if it is located on the bay or a golf course (near but not on the Gulf). Sample data from the Multiple Listing Service in Naples, Florida, provided sales data for 40 Gulf View condominiums and 18 No Gulf View condominiums. The complete data set is in the file named Real Estate, linked at the bottom of the page.
Managerial Report
Prepare a report (see below) that summarizes your assessment of the nature of the housing market in southwest Florida. Be sure to include the following seven (7) items in your report.
Descriptive statistics (mean, median, range, and standard deviation) to summarize each of the three variables for the 40 Gulf View condominiums. Are there any outliers in the data set for any of the three variables? If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.
Descriptive statistics (mean, median, range, and standard deviation) to summarize each of the three variables for the 18 No Gulf View condominiums. Are there any outliers in the data set for any of the three variables? If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.
Compare your summary results from #1 and #2. Discuss any specific statistical results that would help a real estate agent understand the condominium market.
Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Gulf View condominiums. Interpret your results.
Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for No Gulf View condominiums. Interpret your results.
Assume the branch manager requested estimates of the mean selling price of Gulf View condominiums with a margin of error of $40,000 and the mean selling price of No Gulf View condominiums with a margin of error of $15,000. Using 95% confidence, how large should the sample sizes be for each?
Gulf Real Estate Properties just signed contracts for two new listings: a Gulf View condominium with a list price of $589,000 and a No Gulf
View condominium with a list price of $285,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these units?
Write a report APA Format
Your report must contain the following:
A title page in APA style.
An introduction that summarizes the problem.
The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.
Submit your Excel file in addition to your report.
Attachment:- real_estate.xlsx
|
How long will it take room temperature water to boil
: A 283 g aluminum coffee pot is filled with 650 mL of water. If the power output of the coffee pot is 750W, how long will it take room temperature (20oC) water to boil (100oC)? Aluminum has a specific heat of 0.900 J/goC.
|
|
Synthesizes knowledge as a fundamental part
: Question 1:A ________ is a professional who is relatively well educated and creates, modifies, and/or synthesizes knowledge as a fundamental part of his/her job.
|
|
Evaluating a project that costs
: We are evaluating a project that costs $800,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 60,000 units per year. Price per unit is $40,..
|
|
How much is a capitalization
: The corporation has a hundred million and preferred stock 115 million in common stock in 250 million in bonds. how much is a capitalization? practically speaking it may take only how much to control it?
|
|
What is your estimate of the final selling price
: Assume the branch manager requested estimates of the mean selling price of Gulf View condominiums with a margin of error of $40,000 and the mean selling price of No Gulf View condominiums with a margin of error of $15,000. Using 95% confidence, ho..
|
|
Find the total sound intensity the man
: A man stands at the midpoint between two speakers that are broadcasting an amplified static hiss uniformly in all directions. The speakers are 28.0 m apart and the total power of the sound coming from each speaker is 0.478 W.
|
|
Process of preparing its financial statements
: Holtzman Company is in the process of preparing its financial statements for 2014. Assume that no entries for depreciation have been recorded in 2014. The following information related to depreciation of fixed assets is provided to you. 1. Holtzma..
|
|
The senbet discount tire company
: During the year, the Senbet Discount Tire Company had gross sales of $1.14 million. The firm's cost of goods sold and selling expenses were $533,000 and $223,000, respectively. The firm also had notes payable of $880,000.
|
|
Find the maximum amplitude of the oscillation at which the
: 0.118 kg block is suspended from a spring. When a small pebble of mass 30 g is placed on the block, the spring stretches an additional 5.1 cm. With the pebble on the block, the block oscillates with an amplitude of 12cm. Find the maximum amplitude of..
|