Purchase Solution

Chasewood Apartments, Independent, Dependent Variables, Linear Regression, Relationship, Forecast.

Not what you're looking for?

Ask Custom Question

Chasewood Apartments is a 300-unit complex near Fairway University that attracts mostly university students. The manager has collected the following data and wants to project the number of units leased in Semester 9 using simple linear regression. Here is the information that has been collected:

Semester University Enrollment
(in thousands) Average Lease Price
($) Number of Units
Leased
l 7.2 450 291
2 6.3 460 228
3 6.7 450 252
4 7.0 470 265
5 6.9 440 270
6 6.4 430 240
7 7.1 460 288
8 6.7 440 246

In answering these questions, you must identify and use the correct independent and dependent variables.

a) The apartment manager wants to forecast the Number of Units Leased as a function of time. What is the linear regression relationship the manager should use and what is the forecast for the Number of Units Leased for Semester 9'?

b) Suppose the manager believes that the Number of Units Leased is a function only of University Enrollment. What is the linear regression relationship the manager should use and what is the forecast for the Number o{Units Leased for Semester 9 if the enrollment is expected to 6,700 students for Semester 9'?

c) Suppose the manager believes that the Number of Units Leased is a function only of the Average Lease Price. What is the linear regression relationship the manager should use and what is the forecast for the Number of Units Leased for Semester 9 if the forecast for the Average
Lease Price is $460 for Semester 9?

d) Considering the strength of each of the relationships that you found in pa1is a) through c), would you use any of these to forecast the Number of Units Leased for Semester 9? Explain your answer.

Purchase this Solution
Solution Summary

Your tutorial is 242 words of discussion, including indicating the dependent and independent variables and discussing the strength of the relationships among the variables. Three regressions are completed in Excel for you as well as three graphs to give you a visual of the relationships of the three independent variables on units leased.

Solution Preview

TUTORIAL:

Chasewood Apartments is a 300-unit complex near Fairway University that attracts mostly university students. The manager has collected the following data and wants to project the number of units leased in Semester 9 using simple linear regression. Here is the information that has been collected:

Semester University Enrollment
(in thousands) Average Lease Price
($) Number of Units
Leased
l 7.2 450 291
2 6.3 460 228
3 6.7 450 252
4 7.0 470 265
5 6.9 440 270
6 6.4 430 240
7 7.1 460 288
8 6.7 440 246

In answering these questions, you must identify and use the correct independent and dependent variables.

a) The apartment manager wants to forecast the Number of Units Leased as a function of time. What is the linear regression relationship the manager should use and what is the forecast ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting for WidgeCorp: Applied Managerial Decision-Making

    This means there is a linear relationship between the variables.

  • Simple Regressions and Multiple Regressions

    How are dependent (criterion) and independent variables identified? What is simple linear regression? The simple linear regression is a method to determine the relationship between one dependent variable and one independent variable.

  • Statistics

    The regression equation is based on the variables and Excel as well as SPSS automatically calculates it for you. When doing any kind of regression analysis, the goal is to have at least one independent variable and two dependent variables.

  • Purpose and interpretation of multiple regression analysis

    Using Multiple Regression Analysis Technique, one can predict the values of dependent variables by estimating the values of independent variables.

  • Independent/Dependent Variables; Correlation and Regression

    It is a measure of the correlation (i.e. the linear relationship) between the independent and dependent variables. If there is a strong correlation between those two variables, r will be close to 1 or -1.

  • WidgeCorp

    The relationship between the two is then, used to do linear transformation, where, the dependent variable is assumed to be a linear function of one or more independent variables and an error is introduced to account for all the other factors (Stockburger

  • What is the linear regression and 5-month moving average forecast for the sales data?

    Regression Analysis Regression analysis includes any techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables.

  • Appropriate quantitative forecasting methods

    Regression: mathematical equation relates a dependent variable to one or more independent variables that are believed to influence the dependent variable. 2.

  • Relationship of Linear Regression & Correlation

    Linear regression is used to explain the relationship between a dependent variable and one or more independent variables. The assumptions involved with linear regression are that: 1. There is a linear relationship between the variables.

View More Related Solutions