Florida Pool Home Data
Home	Price	Size	Number of Bathrooms	Niceness Rating	Pool?
($1000s)	(Square Feet)	yes=1; no=0
1	260.9	2666	2.5	7	0
2	337.3	3418	3.5	6	1
3	268.4	2945	2.0	5	1
4	242.2	2942	2.5	3	1
5	255.2	2798	3.0	3	1
6	205.7	2210	2.5	2	0
7	249.5	2209	2.0	7	0
8	193.6	2465	2.5	1	0
9	242.7	2955	2.0	4	1
10	244.5	2722	2.5	5	0
11	184.2	2590	2.5	1	0
12	325.7	3138	3.5	7	1
13	266.1	2713	2.0	7	0
14	166.0	2284	2.5	2	0
15	330.7	3140	3.5	6	1
16	289.1	3205	2.5	3	1
17	268.8	2721	2.5	5	1
18	276.7	3245	2.5	2	1
19	222.4	2464	3.0	3	1
20	241.5	2993	2.5	1	0
21	307.9	2647	3.5	6	1
22	223.5	2670	2.5	4	0
23	231.1	2895	2.5	3	0
24	216.5	2643	2.5	3	0
25	205.5	2915	2.0	1	0
26	258.3	2800	3.5	2	1
27	227.6	2557	2.5	3	1
28	255.4	2805	2.0	3	1
29	235.7	2878	2.5	4	0
30	285.1	2795	3.0	7	1
31	284.8	2748	2.5	7	1
32	593.7	8256	2.5	2	0
33	247.5	2659	2.5	2	1
34	274.8	3241	3.5	4	1
35	264.4	3166	3.0	3	1
36	204.1	2466	2.0	4	0
37	273.9	2945	2.5	5	1
38	238.5	2727	3.0	1	1
39	274.4	3141	4.0	4	1
40	259.6	2552	2.0	7	1
41	285.6	2761	3.0	6	1
42	216.1	2880	2.5	2	0
43	261.3	3426	3.0	1	1
44	236.4	2895	2.5	2	1
45	267.5	2726	3.0	7	0
46	220.2	2930	2.5	2	0
47	300.1	3013	2.5	6	1
48	260.0	2675	2.0	6	0
49	277.5	2874	3.5	4	1
50	274.9	2765	2.5	2	1
51	259.8	3020	3.5	2	1
52	235.0	2887	2.5	1	1
53	591.4	8132	2.0	3	0
54	228.5	2698	2.5	4	0
55	266.6	2847	3.0	2	1
56	233.0	2639	3.0	3	0
57	343.4	3431	4.0	5	1
58	334.0	3485	3.5	5	1
59	289.7	2991	2.5	6	1
60	228.4	2482	2.5	2	0
61	233.4	2712	2.5	1	1
62	275.7	3103	2.5	2	1
63	290.8	3124	2.5	3	1
64	230.8	2906	2.5	2	0
65	310.1	3398	4.0	4	1
66	247.9	3028	3.0	4	0
67	249.9	2761	2.0	5	0
68	220.5	2842	3.0	3	0
69	226.2	2666	2.5	6	0
70	313.7	2744	2.5	7	1
71	210.1	2508	2.5	4	0
72	244.9	2480	2.5	5	0
73	235.8	2986	2.5	4	0
74	263.2	2753	2.5	7	0
75	280.2	2522	2.5	6	1
76	290.8	2808	2.5	7	1
77	235.4	2616	2.5	3	0
78	590.3	8603	2.5	2	0
79	234.4	2804	2.5	4	0
80	238.7	2851	2.5	5	0
Mean
Median
Mode
Standard Deviation

For this practical application assignment, imagine 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 and asks you to find ways to 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 is a pool. This file is used as an example on pages 142143 ofBusiness Statistics in Practice. If you are using Excel, read Appendix 2.1 on pages 8087 in your textbook, which provides instruction on how to construct a frequency distribution, histogram, and scatter plot in Excel. SAS users can reference the SAS tutorials located in the third study activity of this unit.

Compute the following data parameters:

1. Calculate the mean, median, range, and standard deviation of home price and size. For the assignment document, copy and paste the output (graph) from the Excel Analysis ToolPak or SAS Enterprise Guide into a Word document. 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 answers from the Excel Analysis ToolPak or SAS Enterprise Guide. Then verbally summarize this data to help a buyer make a purchasing decision in the Florida real estate market.
3. Produce a histogram that shows the number of houses by price range, in increments of $50,000 (for example, $0$50,000; $50,001$100,000 and so on). Then verbally summarize how this histogram will help a buyer make a purchasing decision in the Florida real estate market.
4. Produce a scatter plot showing the relationship between price and home size. In a cell under your scatterplot, indicate whether the relationship is positive or negative and whether the results are what you expect. Then verbally summarize how this scatter plot output will help a buyer make a purchasing decision in the Florida real estate market.

Assignment Submission

Compile all of your answers in a single Microsoft Word file (submitted as a .docx file), pasting in the tables and graphics you created to demonstrate your work. Cearly title your tables and graphics, including each row and column. For example, for the table in question 1, you might use the following labeling: Row 1, Column B contains the "Mean of Home Selling Prices," Row 1, Column C contains the "Mean of Home Size in Square Feet," and so on. Highlight the results of your data calculations within each table.

Submit your report to the assignments area for grading. Please note that assignments must be submitted to the assignments area for grading. Work e-mailed or otherwise presented cannot be graded in accordance with Capella Grading Standards. Because of the nature of statistics-based assignments, your instructor cannot give feedback on drafts of your work. Instead, if you have questions as you complete assignments, you are encouraged to attend the weekly supplementary instruction sessions or to consult the archived sessions for suggestions. Refer to the scoring guide prior to submission to ensure you meet all evaluation criteria.