(a) Use multiple Linear Regression model to develop and estimated regression equation to predict the selling...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) Use multiple Linear Regression model to develop and estimated regression equation to predict the selling price of the home, based on Sq Footage and Age of the home. Clearly write the regression equation. (b) What % of variability in the selling price can be explained by the Sq Footage and age of the home (c) Use excel to construct plots of the residual (error) against dependent and Independent variables. Based on these plots, are conditions necessary for Valid inference are met? (d) Mainline reality management believes that condition of the house may also contribute substantially towards variability in the sale price of the homes. To capture this, company now collects data on another independent variable (whether home is in mint condition?). The value of this dummy variable is 1 if the house is in mint condition and value is 0 if it is not in mint condition. Include additional variable titled "Mint" in your model (in addition to Sq Footage and age) as listed below and redevelop the regression equation. Clearly write the Regression equation. (e) What % of variability in the selling price can now be explained by included "Mint" as additional independent variable. (f) Using this expanded model, predict the selling price of a home that has 1800 Sq footage, age is 28 years and is in Mint condition. 2. Data from sale of 14 homes by Mainline Reality, Inc is provided below: Sq Footage of Home 1926 2069 1720 1396 1706 1847 1950 2323 2285 Selling Price 95000 119000 124800 135000 142800 145000 159000 165000 182000 183000 3752 200000 2300 211000 2525 215000 3800 219000 1740 Age of Home 30 40 30 15 32 38 27 30 26 35 18 17 40 12 (a) Use multiple Linear Regression model to develop and estimated regression equation to predict the selling price of the home, based on Sq Footage and Age of the home. Clearly write the regression equation. (b) What % of variability in the selling price can be explained by the Sq Footage and age of the home (c) Use excel to construct plots of the residual (error) against dependent and Independent variables. Based on these plots, are conditions necessary for Valid inference are met? (d) Mainline reality management believes that condition of the house may also contribute substantially towards variability in the sale price of the homes. To capture this, company now collects data on another independent variable (whether home is in mint condition?). The value of this dummy variable is 1 if the house is in mint condition and value is 0 if it is not in mint condition. Include additional variable titled "Mint" in your model (in addition to Sq Footage and age) as listed below and redevelop the regression equation. Clearly write the Regression equation. (e) What % of variability in the selling price can now be explained by included "Mint" as additional independent variable. (f) Using this expanded model, predict the selling price of a home that has 1800 Sq footage, age is 28 years and is in Mint condition. 2. Data from sale of 14 homes by Mainline Reality, Inc is provided below: Sq Footage of Home 1926 2069 1720 1396 1706 1847 1950 2323 2285 Selling Price 95000 119000 124800 135000 142800 145000 159000 165000 182000 183000 3752 200000 2300 211000 2525 215000 3800 219000 1740 Age of Home 30 40 30 15 32 38 27 30 26 35 18 17 40 12
Expert Answer:
Answer rating: 100% (QA)
f Using the expanded model we can predict the selling price ... View the full answer
Related Book For
Quantitative Analysis for Management
ISBN: 978-0133507331
12th edition
Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha
Posted Date:
Students also viewed these accounting questions
-
The following chart summarizes the selling price of homes sold last month in the Sarasota, Florida, area. a. What is the chart called? b. How many homes were sold during the last month? c. What is...
-
What factors affect the selling price of your home?
-
A regression performed to predict the selling price of houses found the equation Price = 169,328 + 35.3Area + 0.718 Lotsize - 6543Age Where Price is in dollars, Area is in square feet, Lotsize is in...
-
The enzyme Stell participates in several distinct MAP kinase signaling pathways in the budding yeast S. cerevisiae. What is the substrate for Ste 11 in the mating factor signaling pathway? When a...
-
Bridgeport Inc. has a $30 million revolving credit agreement with its bank at prime plus 3.2% based on a calendar year. Prior to the month of April, it had taken down $15 million that was outstanding...
-
A rich singer has donated $481,976 to endow a university professorial chair in Bohemian Studies. If the money is invested at 11.18%, how much can be withdrawn each year, ad infinitum (indefinitely),...
-
Analyze the wine quality of young red wines data in Table B. 19 for multicollinearity. y X2 X3 X4 x6 X7 Xg Xg x10 19.2 0 3.85 66 9.35 5.65 2.40 3.25 0.33 19 0.065 18.3 0 3.73 79 11.15 6.95 3.15 3.80...
-
Refer to Problem 13-30. Assume that in 2013, Dransfield has changed its processes and trained workers to recognize quality problems and fix them before products are finished and shipped to customers....
-
Below are several amounts reported at the end of the year. Currency located at the company Supplies Short-term investments that mature within three months Accounts receivable Balance in savings...
-
What is each shareholder's realized gain or loss? b. What is each shareholder's recognized gain or loss? c. What is each shareholder's basis in their stock? When does their holding period begin? d....
-
You have a 50,000,000 Yen payable. The spot rate is $0.0092/YEN. The Japanese deposit interest rate is 0.6% and the U.S borrowing rate is 2.5%. Calculate the dollar amount of a money market hedge.
-
Consider the circuit in Figure 1. It is a 4-bit synchronous counter which uses four T-type flip-flops. The counter increments its value on each positive edge of the clock if the Enable signal is...
-
Discussion: Cultural Work and Its Value In this week's discussion, we are exploring cultural works and their value. Think of an object from the world around you that has a particular meaning or...
-
2023. Bank A Bank B Consider the following contingency table with the approved loans in August Consumer loans (approved out of total) Mortgage loans (approved out of total) p of 500 4 of 20 3000 of...
-
Performance improvement plans use _ _ _ _ _ _ to make clear the areas that need improvement. Select one: a . appraisals b . SMART goals c . human resource partners d . threats
-
What do the four generic ways an organization chooses to measures its effectiveness say about an organization?
-
You are an audit manager at Jonas Inc currently engaged on the audit of AXA Ltd which commenced operations about 20 years ago and has since grown significantly and become a prominent company in the...
-
Tell whether the angles or sides are corresponding angles, corresponding sides, or neither. AC and JK
-
Consider the Emarpy Appliance situation in Problem 6-56. If Richard Feehan wants to minimize the total annual inventory cost, how many refrigerators should be produced in each production run? How...
-
The following digraph represents the changes in weather from one day to the next in Lowell, Massachusetts. Determine the associated transition matrix and the overall percentage of sunnydays. 0.2...
-
1. Develop a schedule for hiring new employees. What is the total cost of this schedule? 2. Discuss any limitations that exist for this solution. 3. How would the schedule change if the attrition...
-
One might naively think that a collection \(\left(X_{t}, t \in \mathbb{R}^{+} ight)\)of independent r.v's may be chosen "measurably," i.e., with the map \[\left(\mathbb{R}^{+} \times \Omega,...
-
Chi-squared Law. A noncentral chi-squared law \(\chi^{2}(\delta, \alpha)\) with \(\delta\) degrees of freedom and noncentrality parameter \(\alpha\) has the density \[\begin{aligned}f(x ; \delta,...
-
If \(X\) is a positive random variable, prove that its negative moments are given by, for \(r>0\) : (a) \(\quad \mathbb{E}\left(X^{-r} ight)=\frac{1}{\Gamma(r)} \int_{0}^{\infty} t^{r-1}...
Study smarter with the SolutionInn App