Question

You are an analyst for a real estate brokerage.  Provide an analysis of the below data that would be insightful to the owner of the brokerage. Show the dispersion, averages, and frequencies of the data. Include a histogram, pie chart, and line graph, as well as a brief write up of your observations about the data.

Price	Bedrooms		Size	Pool	Distance	Twnship	Garage	Baths
263.1	4		2300	0	17	5	1	2
182.4	4		2100	1	19	4	0	2
242.1	3		2300	1	12	3	0	2
213.6	2		2200	1	16	2	0	2.5
139.9	2		2100	1	28	1	0	1.5
245.4	2		2100	0	12	1	1	2
327.2	6		2500	1	15	3	1	2
271.8	2		2100	1	9	2	1	2.5
221.1	3		2300	0	18	1	0	1.5
266.6	4		2400	1	13	4	1	2
292.4	4		2100	1	14	3	1	2
209	2		1700	1	8	4	1	1.5
270.8	6		2500	1	7	4	1	2
246.1	4		2100	1	18	3	1	2
194.4	2		2300	1	11	3	0	2

Answer 1

​​​​​​Using minitab we calculate the following measures and construct the graphs..

Histogram of Price, bedrooms, size, pool, distance, township, Price bedrooms size 5.0 0.0 0.0 150 175 200 225 250 275 300 325 2 3 4 56 1800 2000 2200 2400 istance townshi 3.0 10 1.5 0.0 15 20 25 arage baths 10 5- 1.6 1.8 2.0 2.2 2.4
Histogram : ( Y axis – frequency, X axis- variable under consideration. Also the summation of the top of the bins should be equal to the total frequency =15 for each of the histograms)
for price: there are 4 apartments of price in the range of (262.5,287.5) , 3 apartments of price within (237.5,262.5). Rest of the bins are decided similarly.
For bedrooms : the tallest bin says there are 6 bedrooms in 2 apartments. Also there is no apartment with 5 bedrooms. Rest of the bins are decided similarly.
For distance : there are a total of 9 apartments in the range of (11.25,13.75),(13.75,16.25),(16.25,18.75) with 3 apartments belonging to each range. These are reflected in the tallest bins.
Similarly rest of the histograms are decided.

Pie chart: (summing up each of the percentages, we will get 100)
For price : We see that there are 15 different price so the pie chart for price gives equal percentage to each of the 15 prices of 6.7%
For bedrooms : As the frequency table shows, there are different frequencies for different number of bedrooms. For example : there are 6 such apartments with 2 bedroom each. So the pie chart gives a highest percentage of 40% for the 2 bedroom apartments. i.e there are 40% apartments with 2 bedrooms. Similarly the other percentages are decided.
For sizes : From the frequency table we see there are 6 apartments with size 2100 so the pie chart gives a highest % of 40 to the 2100 sizes. Next is 26.7% allotted to 2300 sized apartments. Similarly rest of the percentages are decided.
For pool : there are 12 apartments with 1 pool so the pie chart gives 80% to pool count 12 i.e there are 80% apartments with 1 pool
For distance : there are 2 apartments with distance 13 and 2 apartments with 18 so the pie chart gives 13.3% to each of these two apartments. Rest of the % are decided likewise.
For township : there are 5 apartments with 3 township each so pie chart gives the highest % of 33 to the count 5 of 3 townships.
Pie chart for garage and baths are decided likewise.

Here, Line diagram is not suitable as data is not time series .