Segment of city Price ($1000) House Size (100 SQ2) Number of bedroom Number of bathroom Garage siz 202320223122231223332102 NW 290 21 S 95 11 NE 170 19 NW 375 38 W 350 24 23 54 4 2 2 12 2 4 4 3 S 125 10 2 2 W 310 31 4 4 W 275 NW 340 NE 215 NW 295 S 190 22222 25 3 27 5 2 3 4 20 4 33 3 24 4 3 NW 385 36 5 4 W SŹ 430 32 185 14 53 4 2 S 175 18 4 2 NE 190 19 4 2 W 330 29 4 4 NE 405 33 5 4 W 170 23 NW 365 34 45 2 2 S 280 25 NE 205 17 W 260 21 434 4 3 1
Tony Zamora, a real estate investor, has just moved to Clarksville and wants to learn about the local real estate market. He wants to understand, for example, the relationship between geographical segment of the city and selling price of a house, the relationship between selling price and number of bedrooms, and so on. Tony has randomly selected 24 house-for-sale listings from the Sunday newspaper and collected the data listed below. Construct a crosstabulation for the variables segment of city and number of bedrooms.
a. What percentage of the houses in S have 3 bedrooms or less?
b. What percentage of the houses have 3 bedroom and more than 2 bathrooms?
c. What percentage of houses worth more than $395000?
please demonstrate step by step on solving this problem using excel. please sponser a screenshot.
1. a. 16.67
b. 12.5
c. 2
2. a. 4.17
b. 4.17
c. 4.17
3. a. 50.00
b. 4.17
c. 8.33
4. a. 6
b. 4
c. 2
Step by step
Solved in 2 steps with 1 images
