1. In the Microsoft Excel document included with your exam materials you will find a spreadsheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. In the Microsoft Excel document included with your exam materials you will find a spreadsheet titled "Des Moines Apts" containing information about apartments in the Des Moines, Iowa area. You will also find a codebook with descriptions of each variable and the units it is expressed in. a. (6 points) Prepare a table of summary statistics for all available variables listed. Include mean, standard, deviation, minimum, and maximum. One thing to note is that the district variable is redundant so do not have a numerical value for that variable, you will only be able to include the percentage makeup of the apartments represented in each district as shown below. As those districts are simply describing the location, do not include std deviation, min, or max for those. Check the example tables for a reference on the recommended appearance. Paste that table below. b. (4 points) Create 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. (4 points) Create 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. (4 points) 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. (5 points) 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 on the 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. (6 points) What do you anticipate to be the relationships in the data between the independent variables and the dependent variables? In the next step you will be asked to estimate how rent changes based on the other variables in the dataset. (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. (5 points) 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. (8 points) 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 would cause in the dependent variable in a sentence for each variable, taking into account whether that value is statistically significant. i. (10 points) From your table created in part e 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. This may be tricky for some of you, note the amount of points and be exact in your wording. j. (10 points) 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. k. (6 points) What kind of market is 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). ECON 301 Managerial Economics Exam 1 Example Summary Statistics Variable Motel Occupancy Rate Room price Competitor price Income District Sherman Hill Downtown East Village Description % monthly rate in US $'s Intercept Room price Competitor price Income in US $'s in 000s of US $'s % of sample Mean 0.56 76.00 Coefficient 50.174 0.144 -0.083 0.026 75.64 62.74 ECON 301 Managerial Economics Exam 1 Example Linear Regression Results Dependent Variable: Motel Occupancy Rate (%) Standard 10% 80% 10% Std Dev 0.02 4.65 14.44 11.10 Error 7.847 0.117 0.041 -2,007 0.064 0.404 t stat p-value 0.000 0.230 0.058 0.690 Min 0.53 67.45 39.20 42.90 6.394 1.235 Max 0.60 83.90 83.90 83.90 These are false numbers I made up for an example 1. In the Microsoft Excel document included with your exam materials you will find a spreadsheet titled "Des Moines Apts" containing information about apartments in the Des Moines, Iowa area. You will also find a codebook with descriptions of each variable and the units it is expressed in. a. (6 points) Prepare a table of summary statistics for all available variables listed. Include mean, standard, deviation, minimum, and maximum. One thing to note is that the district variable is redundant so do not have a numerical value for that variable, you will only be able to include the percentage makeup of the apartments represented in each district as shown below. As those districts are simply describing the location, do not include std deviation, min, or max for those. Check the example tables for a reference on the recommended appearance. Paste that table below. b. (4 points) Create 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. (4 points) Create 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. (4 points) 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. (5 points) 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 on the 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. (6 points) What do you anticipate to be the relationships in the data between the independent variables and the dependent variables? In the next step you will be asked to estimate how rent changes based on the other variables in the dataset. (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. (5 points) 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. (8 points) 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 would cause in the dependent variable in a sentence for each variable, taking into account whether that value is statistically significant. i. (10 points) From your table created in part e 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. This may be tricky for some of you, note the amount of points and be exact in your wording. j. (10 points) 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. k. (6 points) What kind of market is 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). ECON 301 Managerial Economics Exam 1 Example Summary Statistics Variable Motel Occupancy Rate Room price Competitor price Income District Sherman Hill Downtown East Village Description % monthly rate in US $'s Intercept Room price Competitor price Income in US $'s in 000s of US $'s % of sample Mean 0.56 76.00 Coefficient 50.174 0.144 -0.083 0.026 75.64 62.74 ECON 301 Managerial Economics Exam 1 Example Linear Regression Results Dependent Variable: Motel Occupancy Rate (%) Standard 10% 80% 10% Std Dev 0.02 4.65 14.44 11.10 Error 7.847 0.117 0.041 -2,007 0.064 0.404 t stat p-value 0.000 0.230 0.058 0.690 Min 0.53 67.45 39.20 42.90 6.394 1.235 Max 0.60 83.90 83.90 83.90 These are false numbers I made up for an example
Expert Answer:
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0077861629
8th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus
Posted Date:
Students also viewed these accounting questions
-
In Appendix A, you will find a table titled 10-Year Summary of Financial and Operating Results for Home Depot. Review the various performance measures listed in the table. Choose at least one measure...
-
In Appendix A, you will find a table titled "Five-Year Summary of Financial and Operating Results" for Home Depot. Review the various performance measures listed in the table. Choose at least one...
-
Determine taxable income. Show all adjustments in the Microsoft Excel spreadsheet. Footnote references are provided to assist you. 1. 2. The Dr. has filed his prior tax returns on the cash basis. a....
-
Nanette works for Piroz and is paid a basic wage of $1,000 a week. Piroz operates the following bonus scheme: (1) Each employee gets a bonus of $4 for every unit they produce in excess of 2,000 units...
-
Janutis Co. has just issued fixed rate debt at 10 percent. Yet, it prefers to convert its financing to incur a floating rate on its debt. It engages in an interest rate swap in which it swaps...
-
How might sustainability issues be incorporated into the design of facilities and workplaces? Provide examples and explain your reasoning.
-
What are the eight strategies you can apply to achieve your financial goals?
-
Polk Company manufactures basketballs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of July 2017...
-
Exam 1 Later Today, you borrowed $285,000 to bary a house. The mortgage rate is 4.2 percent. The loan is to be repaid in equal monthly payments over 20 years, with the first payment due one month...
-
The Milk 4 All Company is considering branching into the ice-cream business. It will need a machine costing $1,000,000 to produce the ice cream. The machine will be depreciated over ten years to zero...
-
Ten years ago the Jacksons bought a house, taking out a 30 year mortgage for $160,000 at 6.5%. This year (exactly 10 years later) they refinanced the house, taking out a new 30 year mortgage for the...
-
Find a formula for f 1(x). Identify the domain and range of f 1. f(x)=7x-151 Find a formula for f (x). f 1 (x) = X 15 7 7 (Simplify your answer. Use integers or fractions for any numbers in the...
-
The diagram below represents bwo concurrent forces acting on an object that are drawn to a scale of 1 cm = 5.0 newtons. 201 +33N=C 400+1089=2 C = 35.6 N 38.6 N What is the magnitude of the force...
-
Thomas Company began its operations in 2 0 2 7 and applies overhead costs to jobs using a pre - determined overhead rate equal to 6 0 % of direct labor cost. During 2 0 2 7 , Thomas Company began...
-
2. What is the current in the 2.0 resistor in the circuit shown in the figure? [3] 10 V 222 6 6 V 492
-
Managers have to be prepared to lead their organizations through varying economic conditions. Explain why it is important to understand GDP data, and how changes inunemployment and inflation impact...
-
8. Strain gauges are very sensitive to temperature and prone to errors, explain how would you compensate for temperature variations and compensate for this kind of error
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
In each of the following cases, state which of the two companies is likely to be characterized by the higher ratio. a. Debt-equity ratio: a shipping company or a computer software company b. Payout...
-
A project has a life of 10 years and a payback period of 10 years. What must be true of project NPV?
-
A new furnace for your small factory will cost $27,000 a year to install and will require ongoing maintenance expenditures of $1,500 a year. But it is far more fuel- efficient than your old furnace...
-
You are provided the following information about a company for two years (in millions): a. Days Sales in receivable index b. Gross margin index c. Sales growth index Any thoughts about this company?...
-
Go to the Association of Certified Fraud Examiners' website and find the 2004 Report to the Nation on Occupational Fraud and Abuse. a. How long does the average fraud scheme last? b. Applied to the...
-
Using the Internet or print media, find some examples of off-balance sheet ideas.
Study smarter with the SolutionInn App