# Producing and Interpreting Descriptive Statistics

Good Essays
1273 Words
Grammar
Plagiarism
Writing
Score
Producing and Interpreting Descriptive Statistics
Producing and Interpreting Descriptive Statistics
Lutricia Hunter
Capella University
MBA6018: Data Analysis for Business Decisions
January 18, 2015
Unit 1: Assignment 1

For this practical application assignment, make believe that you are a real estate agent living and working in southern Florida. The senior real estate partner of your firm e-mails you a document containing Florida pool home data, which you've retrieved from the Updates and Handouts section of this unit, and asks you to find ways describe the most important aspects of the home sale data. This technique is called descriptive statistics. The file contains data for 80 properties, including home prices, home sizes, number of bathrooms, niceness ratings, and whether or not there's a pool. This file is used as an example on pages 142–143 of Business Statistics in Practice. Be sure that you have read Appendix 2.1, on pages 80–87, in your textbook, which provides instruction on how to construct a frequency distribution, histogram, and scatter plot in Excel. Compute the following data parameters:
1. Calculate the mean, median, range, and standard deviation of home price and size. For the assignment document you will submit, you can cut and paste the answers from the Analysis ToolPak, or you can place your results in the same Excel sheet as the data, below the existing table. Be sure to label each of your data cells. (For example: Row 84 Column B should contain the calculated Mean of Home Selling Prices; Column A already contains the title, mean; Column C the Mean of Home Size in Square Feet; Row 85 Column B should contain the Home Median price, and so on. Highlight all your results in yellow.) Then cut and paste that spreadsheet into a Word document. Be sure to verbally summarize your data findings in four or five sentences that will help a home buyer make a purchasing decision in the Florida real estate market.
2. Calculate the mode for the number of bathrooms. (You can cut and paste the

## You May Also Find These Documents Helpful

• Good Essays

1. Run a regression between price and area (sqft) for data in “housing ” worksheet.…

• 766 Words
• 4 Pages
Good Essays
• Satisfactory Essays

Summarize the data collected using descriptive statistics. Descriptive statistics should be in the forms of frequency distribution table, measures of mean, median, mode, standard deviation, and graphical display of data.…

• 362 Words
• 2 Pages
Satisfactory Essays
• Good Essays

The median of the data is 3 and the mode is 2. The household size mean is 3.42. The standard deviation is 1.74 and the maximum number of customers has a household size of 2 which is shown in the bar graph and the frequency distribution table.…

• 596 Words
• 3 Pages
Good Essays
• Satisfactory Essays

c. Can we conclude that there is a positive association between the size of the home and the selling price? Use the .05 significance level.…

• 1862 Words
• 8 Pages
Satisfactory Essays
• Good Essays

Case 2: Gulf Real Estate Properties. Please provide a Managerial Report that includes: 1. Appropriate descriptive statistics to summarize each of the three variables for the forty Gulf View condominiums 2. Appropriate descriptive statistics to summarize each of the three variables for the eighteen No-Gulf View condominiums 3. Comparison of your summary results from #1 & #2. Discuss any specific statistical results that would help a real estate agent understand the condominium market. 4. A 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Gulf View condominiums. Also, interpret the results. 5. A 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Gulf View condominiums. Also, interpret the results. Also, consider the following scenario and include your responses in your Report: 6. 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 effort of \$15,000. Using 95% confidence, how large should the sample sizes be?…

• 913 Words
• 4 Pages
Good Essays
• Satisfactory Essays

The mean household size of the customers averages 3.42. The median of the data is 3 and the mode is 2. The standard deviation is given approximately as 1.74. Maximum number of customers has a household size of 2 as is states from the frequency distribution and the bar graph.…

• 654 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

The mean household size of the customers is given as 3.42. The median of the data is 3 and the mode is 2. The standard deviation is given approximately as 1.74. Maximum number of customers has a household size of 2 as is evident from the frequency distribution and the bar graph.…

• 481 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

BIMS management team has been facing a major dilemma of high turnover and extremely low employee morale. BIMS management team has asked Team B to help identify the main cause of the high turnover and low morale and propose an acceptable solution that will result in a decrease of both.…

• 1185 Words
• 5 Pages
Powerful Essays
• Good Essays

1. Define index. Why would a researcher wish to construct an index? Give one example of an index.…

• 663 Words
• 3 Pages
Good Essays
• Satisfactory Essays

QNT 351 Final Exam1) The main purpose of descriptive statistics is to2) The general process of gathering, organizing, summarizing, analyzing, and interpreting data is called3) The performance of personal and business investments is measured as a percentage, return on investment. What type of variable is return on investment 4) What type of variable is the number of robberies reported in your city5) What level of measurement is the number of auto accidents reported in a given month6) The names of the positions in a corporation, such as chief operating officer or controller, are examples of what level of measurement7) Shoe sizes, such as 7B, 10D, and 12EEE, are examples of what level of measurement8) Monthly commissions of first-year insurance brokers are 1,270, 1,310, 1,680, 1,380, 1,410, 1,570, 1,180, and 1,420. These figures are referred to as9) A small sample of computer operators shows monthly incomes of 1,950, 1,775, 2,060, 1,840, 1,795, 1,890, 1,925, and 1,810. What are these ungrouped numbers called10) The sum of the deviations of each data value from this measure of central location will always be 011) For any data set, which measures of central location have only one value12) A sample of single persons receiving social security payments revealed these monthly benefits 826, 699, 1,087, 880, 839, and 965. How many observations are below the median 13) A dot plot shows14) The test scores for a class of 147 students are computed. What is the location of the test score associated with the third quartile15) The National Center for Health Statistics reported that of every 883 deaths in recent years, 24 resulted from an automobile accident, 182 from cancer, and 333 from heart disease. QNT 351 Final Exam. Using the relative frequency approach, what is the probability that a particular death is due to an automobile accident16) If two events A and B are mutually exclusive, what does the special rule of addition state17) A listing of all possible outcomes of an…

• 604 Words
• 2 Pages
Satisfactory Essays
• Better Essays

Our team made revisions from the week two report based on a previously unidentified problem relating to the staff’s weakening morale and a high turnover rate at Ballard Integrated Managed Services, Incorporated. Summarized surveyed data in the BIMS case study will be analyzed by computing descriptive statistics in the form of tables, charts, measures of central tendency, and variability. Conclusions will be drawn from the data and recommendations of the management will be identified.…

• 2077 Words
• 9 Pages
Better Essays
• Good Essays

* First, we should do market research on the target area. For example, we should figure out the demand and supply, the trading volume, and the environment in neighboring. After knowing these information, we should also estimate the possible trend of the property value.…

• 879 Words
• 4 Pages
Good Essays
• Powerful Essays

The histogram is present in appendix A; the descriptive statistics are present in appendix B.…

• 321 Words
• 2 Pages
Powerful Essays
• Satisfactory Essays

1. The following calculations show the mean, median and standard deviation for the case study.…

• 418 Words
• 2 Pages
Satisfactory Essays
• Better Essays

Real Estate provides individuals with a source of investment for his or her future. Owning a piece of real estate could be a business investment, or in the case of this research, a home for an individual or a family. When a person purchases a home there are many things to consider. The most common information to review is square footage, price, amount of bedrooms, bathrooms, and whether the house has a garage. Validating this information versus other statistical review is very important. The buyer must have the necessary information to make the best decision. The data needs to have the widest range of necessary information to give the buyer the largest amount of property to choose from that will fit their criteria.…

• 944 Words
• 4 Pages
Better Essays