Question: ECON380: Business Statistics Assignment 3 Note : you should submit both an excel file and a word file . Given the following data : Real



ECON380: Business Statistics Assignment 3 Note : you should submit both an excel file and a word file . Given the following data : Real estate prices, or generally the real estate market is a major economic concern for several countries, this is largely because real estate prices are connected to several other economic indicators, most importantly an individual's well-being and security. Factors affecting real estate sales includes: population among other variables.\f1. Draw a scatter plot, comment on the resulting diagram. 2. Generate a single factor regression table in excel. 3. Conclude the least squares regression equation. 4. Discuss the results in detail a. Explain the R squared. b. Based on your answers? does a linear relationship exist between the two variables explain your results according to the scenario. For your reference: https://www.excel-easy.com/examples/regression.html
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
