Question
B, a second table with average rent by district. For each district, have columns containing mean, std deviation, min, and max. Your table will be
B, a second table with average rent by district. For each district, have columns containing mean, std deviation, min, and max. Your table will be evaluated based on correct content and style. Give it a title, make sure it has consistent decimals, make it look professional. Paste that table below. Hint: You can manually do this or a pivot table will do this more easily but you'll have to learn how to use it! Choose the two columns District and rent and go to the Insert - Pivot table.
c. a third table with average living space (in square meters) by district. For each district, have columns containing mean, std deviation, min, and max. Your table will be evaluated based on correct content and style. Give it a title, make sure it has consistent decimals, make it look professional. Paste that table below. Hint: You can manually do this or a pivot table will do this more easily but you'll have to learn how to use it! Choose the two columns District and living space and go to the Insert - Pivot table (the columns must be side to side when you do it). d. Create separate two bar graphs showing average rent and average living space by neighborhood. Give the tables a title, make them look professional, show the data values above each bar. Paste those graphs below. e. Write at least 4-5 sentences about the dataset based on what you have found out from the tables and graphs. What do you see? Which district has the highest/lowest rent? The largest/smallest apartments? Incorporate information about neighborhoods in Des Moines (search online for information here, I permit it), does the information you see match the descriptions of those neighborhoods online? f. What do you anticipate to be the relationships in the data between the independent variables and the dependent variables? (For example, I anticipate increased living space (in square meters) to be positively/negatively related with the rent charged). Write a declarative sentence for each variable in the list rooms, floor, and total_sq and its anticipated effect on the rent charged. g. Estimate a linear regression with rent as a function of rooms, the district indicator variables, floor, maxfloor, topfloor, total_sq, and brick. Create a professional looking table in the style of the example table shown in the Microsoft excel workbook included with the exam. Give it a title, make sure it has consistent decimals, make it look professional. Paste that table below. h. From your table created in part g of this problem, interpret the coefficients on the rooms, top floor, total square meters, and kitchen square meters variables. Write what a 1-unit change for each independent variable would cause to happen in the dependent variable in a sentence, taking into account whether that value is statistically significant. i. From your table created in part g of this problem, interpret the coefficients on the district indicator variables. Write what a 0 to 1 change would signify in a sentence for each district, considering whether that value is statistically significant.3 This may be tricky for some of you, note the amount of points and be exact in your wording. j. Envision yourself as a real estate developer thinking of building an apartment building. Interpreting information from the results you've found write at least 4-5 sentences what you've found, what drives rental prices of apartments? Describe what things are important to take into account when deciding where to build, how to build, etc. based on your results. k. What is the market structure for real estate development? Describe how you believe the market functions (how competitive it is, compare contrast the market's characteristics with the defined characteristics of competitive markets and how that would affect your pricing decisions).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started