Explore BrainMass

Explore BrainMass

    Regression Statistics in Microsoft Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Identify a business research issue, problem, or opportunity facing an organization that can be examined using regression analysis. Describe the research issue, problem, or opportunity and the accompanying data. Then, perform a regression analysis on your data using Microsoft® Excel®. Finally, interpret the results of your regression analysis, state the limitations of your analysis, and describe the significance of the results to the organization as a whole. Be sure to attach the results of the regression analysis created in Microsoft® Excel® to your paper.

    See attached file for data.

    © BrainMass Inc. brainmass.com November 24, 2021, 12:50 pm ad1c9bdddf


    Solution Preview

    Please see the attached file.


    1. Introduction

    The durability, fixity and heterogeneity of attributes in real estate properties leads to not only costly search to uncover the prices and attributes of property but also high transaction costs in real estate market as compared to financial markets and other commodity markets. The many frictions associated with the purchase of real estate makes it hard to assess the correct value of the warehouse space. However, the prior research has provided enough evidence that there exists a price signal both in time and space to make the forecasting of real estate prices possible.

    Assessing the correct value of the real estate is an important problem for everyone concerned with the property exchange be it the buyer, the seller or the broker's. Real estate is a heterogeneous asset wherein the specifications are so diverse that it is not easy to identify the comparables to assess the correct value of the property based on the value of the comparables. Even when such information is available the traditional methods of valuation make use of such information arbitrarily, whereas there are sophisticated statistical processes available, which could make full use of the available information. Although the implementation of statistical methods require some understanding of statistics / mathematics and sufficient amount of right data, it could provide substantially better assessment of the value of the real estate.

    Multiple regression analysis can be used to assess the value of a property by developing price as a function of the characteristics of the property. The method provides the process of assessment the attributes of equity and efficiency. By equity we mean that the properties with same characteristics are valued at the same price. By efficiency we mean that the method is able to value the property at its fair market value. Although there are more sophisticated statistical approaches available to predict the value of a property, the multiple regression analysis is straightforward and simple to use. One can perform the regression in MS-Excel and there is no need for any specialized software package to do the analysis.

    This paper demonstrates the use of multiple regression analysis to forecast the warehouse prices. The data for the paper is collected from the recently closed real estate deals in the local market. The issue of whether a regression model formulation suffices for such purpose is discussed and the level of predictive accuracy achieved by it to warrant its application in predicting the future deal values.

    2. Model Development

    To develop the model for estimation of price for warehouse space, we need to look at the possible factors, which may affect the warehouse price. Drawing our knowledge from the microeconomics and real estate market ...

    Solution Summary

    This solution explains how to identify a business research issue.