Descriptive Statistics – Real Estate Data Part 1, statistics homework help

User Generated

revpxhsb

Mathematics

Description

Search the Internet for a realty site.

Select a hometown of someone on your team in the search section on the website you have chosen. When all of the listings populate, make sure that the sort criteria reads "New Listings." This ensures that you are searching a random cross-section of listings rather than favoring one price range.

Review the new listings that populate.

Create an Excel® spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses.

Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms.

Prepare a frequency distribution for listing prices, including relative frequencies.

Create your frequency distribution as identified in Chapters 2, 3, and 4.

Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2.

Summarize your findings from your frequency distribution and your histogram.

Create either a pie chart or a bar graph of the number of bedrooms in your 100 homes.

Evaluate your visual aid.

Calculate measures of central tendency for both listing prices and square footages. Those measures are mean, median, and mode.

Determine the quartiles for both listing prices and square footages.

Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation.

Apply Chebyshev's Theorem and the Empirical Rule to both sets of data.

Compare your findings with your actual data.

Conclude whether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages.

Format your assignment consistent with APA guidelines.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached

Frequency relative frequency
37
0.37
28
0.28
15
0.15
9
0.9
4
0.4
2
0.2
1
0.1
0
0
2
0.2
2
0.2

Frequency

classes
30,000-230000
230,000-430000
430,000-630000
630,000-830000
830000-1030000
103000-1230000
1230000-1430000
1430,000-1630000
1630000-1830000
Above 1830000

40
35
30
25
20
15
10
5
0

Histogram

Frequency

bins

Listing price
Mean
Median
Mode
Standard Deviation
Sample Variance
Range
Minimum
Maximum
Sum
Count

square ft
491832.65
315750
475000
790900.2699
6.25523E+11
7469000
30000
7499000
49183265
100

Mean
Median
Mode
Standard Deviation
Sample Variance
Range
Minimum
Maximum
Sum
Count

2588.11
2363
3251
1233.795998
1522252.564
9110
660
9770
258811
100

Property adress
Listing price
square ft
3219 Almond Creek Dr , Houston , TX 77059
$339,900
13807 Kensington Pl, Houston, TX 77034
$228,900
12206 Nova Dr, Houston, TX 77077
$380,000
11602 Possum Hollow Ln , Houston , TX 77065
$245,000
6620 Eureka St, Houston, TX 77008
$394,900
10619 Opal Ridge Dr, Houston, TX 77095
$382,500
1240 W Pierce St, Houston, TX 77019
$685,000
331 W 32nd St, Houston, TX 77018
$624,500
15801 Elwood Dr, Jersey Village, TX 77040
$269,995
6030 Floyd St, Houston, TX 77007
$1,875,000
1219 W 25th St, Houston, TX 77008
$445,000
6115 Majestic Hill Dr, Houston, TX 77345
$949,000
2505 Hazard St, Houston, TX 77019
$650,000
13822 Taylorcrest Rd, Houston, TX 77079
$1,049,900
1113 Welch St, Houston, TX 77006
$1,695,000
14514 Sandy Creek Dr, Houston, TX 77070
$625,000
1716 Upland Lks, Houston, TX 77043
$540,000
14819 El Miranda Dr, Houston, TX 77095
$269,000
4382 Harvest Ln, Houston, TX 77004
$425,000
12906 Breezy Meadow Ln Houston, TX 77044
$316,500
1219 W 25th St Unit D, Houston, TX 77008
$465,000
2115 Hazard St, Houston, TX 77019
$995,000
1214 Malone St, Houston, TX 77007
$749,000
15413 Leeds Ln, Jersey Village, TX 77040
$285,000
14131 Barryknoll Ln, Houston, TX 77079
$435,000
4507 Sweet Madeline, Houston, TX 77018
$875,000
9938 Emnora Ln, Houston, TX 77080
$315,000
10114 Briar Dr, Houston, TX 77042
$1,395,000
3465 Overbrook Ln, Housto...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags