Baton Rouge house

profilexoon
6640_project_t2.xlsx
Home>Mathematics homework help>Baton Rouge house

Questions

Problem Set 1
The next tab contains data on houses sold in Baton Rouge, Louisiana in mid-2005. The dataset contains the following variables: Price: The price the house sold for Square Feet: The size of the house in square feet Beds: The number of bedrooms in the house Baths: The number of bathrooms in the house Year Built: The year in which the house was built Age: The age of the house in years Pool: Does the house have a pool (yes/no) Fireplace: Does the house have a fireplace (yes/no) Waterfront: Is the house on the waterfront (yes/no) Days on Market: How many days the house spent on the market before it was ultimately sold Occupancy: Is the house occupied by the owner, a tenant, or is it vacant Style: What is the architectural style of the house? Use the data provided to answer the following questions. Problem 1.1 comes from material in week 1, Problems 1.2 and 1.3 relate to material from week 2, and problem 1.4 is related to the concepts and topics from week 3. Should you encounter any difficulties with these problems, the optional problems below are very similar to the questions in this problem set, and the answers to these questions can be found in the back of the textbook. You can also request that the tutor work extensively with you on the optional problems. Problem 1.1
Problem 1.1
Use the Baton Rouge house price data to do the following: (a) Which of the variables are categorical and which are numerical? (b) Which of the categorical variables are nominal and which are ordinal? (c) Which of the numerical variables are ratio and which are interval?
Problem 1.2
Use the Baton Rouge house price data to do the following: (a) Create a frequency table of the architectural styles of the homes sold. (b) Construct a bar chart, a pie chart, and a Pareto diagram. (c) Which graphical method do you think is best to portray these data? (d) Based on this data, what conclusions can you make about architectural styles in Baton Rouge? Excel tips: The easiest way to create the frequency summary table is with the COUNTIF command. The command works like this: =COUNTIF(x,y), where x is the set of cells you want to look in for a particular value, and y is the value you are looking for. For example, =COUNTIF(K:K, "Vacant") would look in the K column for all instances of the term "Vacant", count them up, and give you the number. Excel doesn't have a "canned" option to create a Pareto Diagram, so this is what you need to do: First, construct a column chart with data for both percentage and cumulative percentage. Then, click on one of the columns that represents data from one of the cumulative percentages, choose "change series chart type," and set it to line.
Problem 1.3
Use the Baton Rouge house price data to do the following: (a) Construct a frequency distribution and a percentage distribution of the number of bedrooms in the sold houses. (b) Construct a histogram and a percentage polygon. (c) Plot a cumulative percentage polygon. Excel tips: As a general rule of thumb, the fewer times you type out a formula, the better. If you can accomplish a task by writing one formula and then filling it down with the fill bar, do it that way so you can minimize your chances of making mistakes. One feature that is very useful for accomplishing this task is making use of relative and absolute cell references. Say, for example, in cell C1 you have the expression =A1+B1. If you fill C1 down to C2, C2 will have the equation =A2+B2...when filling down, Excel viewed your cell references as relative, as if you said in C1 to make C1 equal to the sum of the two cells to the left of it. When you fill down to C2, Excel said that C2 should equal the sum of the two cells to the left of it, in this case A2 and B2. In some cases this is exactly what you want Excel to do, but in others you do not want relative cell references. For example, cell D1 may have total nationwide sales for your company, A1:A51 may have the names of the 50 states (plus DC!), and B1:B51 may have total sales within each state. In column C you want to have the percentage of total sales within that state. If in C1 you type =B1/D1, you will get the correct result, but then if you fill D1 down to D51, you will get error messages (or wrong answers) everywhere else. The easiest fix is to use an absolute reference in your equation, which you accomplish with the dollar sign ($). The $ is essentially a way of "locking" in either a row or column in a cell reference. If you type in C1 =B1/D$1, and then fill down, Excel will "lock in" the first row in the reference, so all of your formulae will compute correctly! With knowledge and appropriate application of relative and absolute references, it is possible to create the table in part (a) by typing exactly 4 equations (and filling them down) and nothing else!
Problem 1.4
Use the Baton Rouge house price data to do the following: (a) Compute the mean, median, first quartile, and third quartile for the price variable. (b) Compute the variance, standard deviation, range, interquartile range, coefficient of variation, skewness, and Z scores for the price variable. (c) Are the data skewed? If so, how? (d) Based on the results of (a) through (c), what conclusions can you reach concerning price? (e) Calculate the proportion of house prices that are +/- 1, +/- 2, and +/- 3 standard deviations of the mean. (f) Compare and contrast your findings with what would be expected on the basis of the empirical rule. Excel Tips: Excel has built-in functions to calculate the mean (AVERAGE), median (MEDIAN), quartiles (QUARTILE), variance (VAR for samples, VARP for populations), and standard deviation (STDEV for samples, STDEVP for populations). You might also think to use the MIN and MAX commands in calculating range. Search the Excel helpfile for the appropriate syntax of these commands. You should note that the method Excel uses to calculate quartiles differs slightly from the method outlined in the book. I mentioned the COUNTIF command above, and you may have thought to use COUNTIF to accomplish part (e). However, a single COUNTIF command cannot handle more than one condition, so if you want to use COUNTIF you should absolutely (hint hint) think outside the box a bit. Or, if you are using Excel 2007 or later, there is a COUNTIFS command that handles multiple conditions.

Data

Price Square Feet Beds Baths Year Built Age Pool Fireplace Waterfront Days on Market Occupancy Style
187441 2854 3 2 1965 40 No Yes No 36 Owner Occupied Traditional
148905 2305 2 1 1995 10 Yes Yes No 50 Owner Occupied Traditional
140745 1609 3 2 1987 18 No No No 9 Owner Occupied Traditional
142195 2727 3 2 1975 30 No Yes No 23 Vacant Traditional
108228 1482 2 2 1983 22 No Yes No 22 Vacant Traditional
115169 2106 2 2 1984 21 No Yes Yes 45 Vacant Traditional
148129 1495 3 2 1992 13 No Yes No 19 Vacant Traditional
125265 2076 2 2 1977 28 No No No 37 Vacant Traditional
108256 1939 3 2 1965 40 Yes No No 0 Owner Occupied Traditional
107033 1937 3 2 1983 22 No Yes No 87 Vacant Traditional
121752 1333 2 2 1994 11 No No Yes 47 Vacant Traditional
107285 2345 3 2 1965 40 No Yes No 94 Vacant Traditional
140563 2692 3 2 1976 29 Yes No No 6 Vacant Traditional
141619 2357 2 2 1988 17 No Yes No 33 Vacant Traditional
149870 3651 3 2 1975 30 Yes Yes No 336 Owner Occupied Traditional
114416 2356 3 2 1956 49 Yes No Yes 60 Owner Occupied Traditional
118380 2597 3 2 1965 40 No No No 141 Owner Occupied Traditional
137575 2499 2 1 1968 37 No No No 57 Owner Occupied Traditional
132142 2547 3 2 1966 39 No Yes No 103 Vacant Traditional
132484 2489 3 2 1976 29 No Yes No 26 Vacant Traditional
123705 2149 3 2 1966 39 Yes No No 13 Vacant Traditional
78519 2275 3 3 1965 40 No No No 19 Vacant Traditional
81500 1216 2 1 1967 38 Yes No No 46 Vacant Traditional
114980 2169 3 2 1965 40 Yes No No 37 Vacant Traditional
129815 2828 3 2 1966 39 No No No 6 Vacant Traditional
94034 1953 3 2 1956 49 No Yes No 35 Vacant Traditional
60859 855 3 1 1956 49 No No No 45 Vacant Traditional
120071 2531 2 1 1968 37 No Yes No 7 Owner Occupied Traditional
122370 2529 2 2 1977 28 No No No 122 Owner Occupied Traditional
121751 2036 3 2 1976 29 No Yes No 18 Owner Occupied Traditional
86738 1371 3 1 1976 29 No Yes No 41 Owner Occupied Traditional
94172 1511 2 2 1976 29 No No Yes 8 Owner Occupied Traditional
86572 1650 2 2 1967 38 No No No 54 Owner Occupied Traditional
104943 2766 3 2 1965 40 Yes No No 66 Owner Occupied Traditional
104632 1994 3 2 1976 29 No Yes No 69 Owner Occupied Traditional
100789 3216 3 1 1967 38 No Yes No 46 Vacant Traditional
120521 2317 2 2 1976 29 No Yes No 25 Vacant Traditional
137845 2030 2 2 2001 4 No Yes No 3 Vacant Traditional
77039 2214 3 2 1955 50 No Yes No 10 Vacant Traditional
42565 1002 3 1 1957 48 Yes No No 11 Vacant Traditional
69835 1343 3 1 1956 49 No Yes No 4 Vacant Traditional
80233 1272 3 1 1977 28 No No No 27 Vacant Traditional
72942 1424 2 1 1967 38 No No No 141 Vacant Traditional
85758 1901 3 1 1967 38 No No Yes 377 Vacant Traditional
60286 1868 3 2 1976 29 No No No 67 Vacant Traditional
42535 1549 2 1 1967 38 No Yes No 12 Vacant Traditional
124500 3012 2 2 1977 28 No Yes Yes 5 Owner Occupied Traditional
87534 1521 3 2 1976 29 No No No 7 Owner Occupied Traditional
58041 1404 3 1 1967 38 No No No 94 Vacant Traditional
91119 1928 3 1 1957 48 No No No 40 Vacant Traditional
185465 2745 3 2 1993 12 No Yes No 42 Owner Occupied Traditional
127645 1875 2 2 1977 28 No Yes No 42 Owner Occupied Traditional
131296 2079 3 2 1975 30 No Yes No 18 Owner Occupied Traditional
139413 3171 2 2 1977 28 Yes Yes No 55 Owner Occupied Traditional
100688 1482 2 2 1984 21 No No No 72 Owner Occupied Traditional
103964 2156 3 2 1976 29 No No No 8 Owner Occupied Traditional
128144 2440 3 2 1975 30 No No No 19 Owner Occupied Traditional
134307 1968 2 2 1976 29 No No No 31 Owner Occupied Traditional
133255 1534 3 2 1975 30 No No No 32 Owner Occupied Traditional
69892 1174 2 1 1968 37 No No No 6 Owner Occupied Traditional
138324 2281 3 2 1982 23 No Yes No 87 Vacant Traditional
107269 1776 3 2 1976 29 No Yes Yes 341 Vacant Traditional
216720 3660 2 2 1977 28 No Yes No 16 Vacant Traditional
108677 1959 2 2 2001 4 No Yes Yes 103 Vacant Traditional
157645 1814 3 2 1975 30 No No No 15 Vacant Traditional
143377 2126 3 2 1975 30 Yes Yes No 49 Owner Occupied Traditional
113257 1331 3 2 1976 29 No Yes No 21 Owner Occupied Traditional
129349 1297 3 2 1983 22 No No No 1 Vacant Traditional
280639 2174 2 1 1940 65 No Yes No 4 Owner Occupied Traditional
192858 2645 2 2 1956 49 No Yes No 7 Owner Occupied Traditional
174104 3368 3 2 1956 49 Yes No No 155 Owner Occupied Traditional
102493 2258 2 2 1976 29 No Yes No 189 Owner Occupied Traditional
60473 1774 2 1 1967 38 No No Yes 97 Vacant Traditional
149157 2992 3 2 1956 49 No No No 75 Owner Occupied Traditional
91879 2368 3 2 1966 39 No No No 20 Owner Occupied Traditional
65780 2365 2 2 1957 48 No No No 228 Owner Occupied Traditional
66470 1232 2 2 1996 9 No No No 22 Vacant Traditional
90766 1411 3 2 1938 67 No No No 15 Vacant Traditional
146341 2767 2 1 1958 47 No Yes No 2 Owner Occupied Traditional
123140 3463 3 1 1967 38 No No No 9 Owner Occupied Traditional
62995 1176 3 1 1939 66 No No No 0 Tenant Traditional
57395 1763 3 1 1966 39 No No No 11 Vacant Traditional
67949 1232 3 1 1967 38 No No No 43 Vacant Traditional
66627 1790 3 1 1939 66 No No Yes 124 Vacant Traditional
81874 1460 3 2 1965 40 No No No 0 Vacant Traditional
44314 1824 3 1 1967 38 No No No 72 Vacant Traditional
57192 823 2 1 1967 38 No No No 27 Vacant Traditional
31745 1522 3 1 1956 49 No No No 33 Vacant Traditional
53523 1458 2 1 1957 48 No No Yes 22 Vacant Traditional
29886 1526 3 1 1957 48 No Yes No 179 Tenant Traditional
96187 1958 3 2 1956 49 No No No 41 Tenant Traditional
141004 2228 2 2 1984 21 No Yes No 3 Owner Occupied Traditional
115789 1559 2 2 1967 38 No Yes No 26 Owner Occupied Traditional
73725 1358 3 2 1992 13 No Yes Yes 10 Owner Occupied Traditional
142406 1585 3 2 1983 22 No No No 6 Vacant Traditional
34301 1793 3 1 1967 38 No Yes Yes 33 Vacant Traditional
158643 2010 3 2 1938 67 Yes No No 203 Vacant Traditional
77570 1855 3 2 1976 29 No No No 124 Owner Occupied Traditional
133248 1886 3 2 1998 7 No Yes No 47 Owner Occupied Traditional
58663 1400 2 2 1976 29 No Yes No 15 Vacant Traditional
145384 1962 3 2 1995 10 No No No 0 Owner Occupied Traditional
175782 2713 2 2 1993 12 No Yes Yes 4 Owner Occupied Traditional
125799 1944 3 2 1992 13 No No Yes 30 Owner Occupied Traditional
142568 1583 2 2 1994 11 No Yes No 30 Owner Occupied Traditional
155064 1711 3 2 1993 12 Yes Yes No 71 Owner Occupied Traditional
175508 2432 3 2 1992 13 No Yes No 1 Owner Occupied Traditional
167745 2376 3 2 1992 13 No No No 11 Owner Occupied Traditional
107605 2130 2 2 1989 16 No Yes No 14 Vacant Traditional
173311 2260 2 2 2001 4 No Yes No 195 Vacant Traditional
125031 2336 3 2 1987 18 No Yes No 79 Vacant Traditional
64334 1813 3 2 1993 12 No No No 15 Vacant Traditional
60441 1388 3 1 1977 28 No No No 73 Vacant Traditional
35472 912 3 1 1967 38 No No No 41 Tenant Traditional
62688 1826 2 1 1958 47 No Yes No 17 Vacant Traditional
60857 1875 2 2 1938 67 Yes No Yes 39 Vacant Traditional
143447 1819 2 2 1966 39 No Yes Yes 247 Owner Occupied Traditional
94958 1725 2 2 1956 49 No Yes No 97 Owner Occupied Traditional
94973 1435 2 2 1977 28 No No Yes 27 Vacant Traditional
22629 1412 2 1 1968 37 No Yes No 287 Vacant Traditional
110440 3177 2 2 1976 29 No Yes No 13 Owner Occupied Traditional
148237 2115 3 1 1993 12 No Yes Yes 106 Owner Occupied Traditional
113384 1647 3 2 1999 6 No Yes No 19 Owner Occupied Traditional
152620 1699 3 2 1992 13 No Yes Yes 217 Owner Occupied Traditional
140284 1910 3 2 1998 7 No No No 36 Owner Occupied Traditional
124565 2158 3 2 1999 6 No No No 74 Vacant Traditional
123269 1781 2 2 1993 12 No No No 14 Vacant Traditional
100580 2252 3 2 1975 30 No Yes No 9 Vacant Traditional
170016 1595 2 1 2001 4 No Yes No 176 Vacant Traditional
109781 1158 3 2 2000 5 No No No 3 Vacant Traditional
95393 1401 3 2 1982 23 No No No 30 Vacant Traditional
112569 2289 2 2 1976 29 No No No 86 Vacant Traditional
142608 2466 3 2 1999 6 No No Yes 0 Vacant Traditional
154300 2527 3 2 1999 6 No No No 238 Vacant Traditional
155614 2459 3 2 2000 5 No No Yes 260 Vacant Traditional
159836 2551 3 2 2000 5 No No No 286 Vacant Traditional
169957 2370 3 2 1999 6 No No No 0 Vacant Traditional
59602 1660 3 2 1976 29 No No No 2 Vacant Traditional
133107 2374 3 2 1999 6 No No Yes 226 Vacant Traditional
299769 4183 3 4 1974 31 Yes Yes No 22 Owner Occupied Traditional
85379 1172 2 1 1977 28 No No No 43 Owner Occupied Traditional
119871 2796 3 2 1975 30 No Yes No 187 Owner Occupied Traditional
129995 2316 3 2 1993 12 No Yes No 150 Owner Occupied Traditional
114878 1895 2 2 1999 6 No No No 44 Owner Occupied Traditional
135138 1844 3 2 1999 6 No Yes No 26 Owner Occupied Traditional
77820 960 3 1 1967 38 Yes No No 10 Owner Occupied Traditional
109179 1853 3 2 1998 7 No No No 84 Owner Occupied Traditional
123893 1958 2 2 2000 5 No No No 15 Owner Occupied Traditional
90653 1307 3 1 1983 22 No No No 6 Owner Occupied Traditional
75586 1528 3 1 1966 39 No No No 170 Owner Occupied Traditional
79853 1199 2 2 1983 22 No No No 11 Vacant Traditional
99820 1752 2 2 2001 4 No No No 0 Vacant Traditional
113209 1923 3 2 1999 6 No No No 222 Vacant Traditional
126727 2121 3 2 2000 5 No No No 1 Vacant Traditional
122983 2248 2 2 2000 5 No Yes No 0 Vacant Traditional
124004 2256 3 2 1999 6 No No No 0 Vacant Traditional
105910 1724 2 2 2001 4 No Yes No 0 Vacant Traditional
106396 1854 2 1 2002 3 No No No 30 Vacant Traditional
115601 1880 3 1 2001 4 No No No 0 Vacant Traditional
118587 1994 2 2 2000 5 No No No 102 Vacant Traditional
114474 1963 3 1 2001 4 No No No 21 Vacant Traditional
127118 1970 3 2 1999 6 No No No 131 Vacant Traditional
124304 2173 2 2 2001 4 No No No 0 Vacant Traditional
124758 2132 3 2 1999 6 No No No 204 Vacant Traditional
125267 2140 2 2 2000 5 No No No 65 Vacant Traditional
131993 2398 2 1 2001 4 No Yes No 0 Vacant Traditional
124580 2279 3 2 1999 6 No No No 0 Vacant Traditional
130966 2348 2 2 2000 5 No No No 3 Vacant Traditional
135283 2334 3 1 2001 4 No No Yes 49 Vacant Traditional
139186 2349 2 2 2001 4 No No Yes 77 Vacant Traditional
127538 2242 3 2 1999 6 No No No 39 Vacant Traditional
154285 2767 2 2 2000 5 No No No 127 Vacant Traditional
115828 2458 3 2 1965 40 Yes No No 7 Vacant Traditional
66920 2414 3 1 1976 29 No No No 0 Vacant Traditional
96676 1491 2 1 2002 3 No No No 37 Vacant Traditional
113921 1818 2 2 2001 4 No No No 150 Vacant Traditional
122317 2438 3 1 2001 4 No No No 152 Vacant Traditional
120076 2183 3 2 2000 5 No No No 0 Vacant Traditional
107322 2023 3 2 1999 6 No Yes No 178 Vacant Traditional
112443 1926 2 2 2000 5 No No No 187 Vacant Traditional
116719 1970 2 2 2001 4 Yes No No 119 Vacant Traditional
131968 2094 2 2 2000 5 No No No 204 Vacant Traditional
109113 2057 2 2 1977 28 No Yes No 3 Owner Occupied Traditional
76050 1556 2 1 1968 37 Yes Yes No 168 Owner Occupied Traditional
102527 2669 2 2 1984 21 No No No 137 Owner Occupied Traditional
72264 1293 3 1 1966 39 No Yes No 26 Owner Occupied Traditional
93241 1682 3 1 1966 39 No No No 70 Owner Occupied Traditional
82852 1326 2 1 1978 27 No No No 193 Owner Occupied Traditional
86460 2130 3 2 1966 39 No No No 25 Owner Occupied Traditional
202584 4106 3 3 1964 41 No No No 193 Owner Occupied Traditional
82233 1483 2 1 1977 28 No No No 10 Owner Occupied Traditional
103134 2283 2 1 1958 47 No Yes No 93 Vacant Traditional
43093 1160 2 1 1967 38 No Yes No 77 Vacant Traditional
88448 1984 3 2 1982 23 No Yes No 51 Vacant Traditional
61815 1390 2 1 1967 38 No No No 40 Vacant Traditional
75271 1334 3 1 1983 22 No No No 21 Vacant Traditional
84994 1299 3 1 1984 21 No No No 41 Vacant Traditional
53676 1616 3 2 1965 40 No No Yes 13 Vacant Traditional
78514 1468 2 1 1967 38 No No No 210 Vacant Traditional
73556 1164 3 1 1966 39 No No No 42 Vacant Traditional
76665 1251 2 1 1967 38 No No No 26 Vacant Traditional

1.1

Variable Type-Categorical or Numerical Ratio or Interval Discussion:
Price
Square Feet
Beds
Baths
Year Built
Age
Pool
Fireplace
Waterfront
Days on Market
Occupancy
Style

1.2

ANSWER 1.2 here

1.3

ANSWER 1.3 here

1.4

ANSWER 1.4 here