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 bothan excel file and a word file . Given the following data: Real estate prices, or generally the real estate market is a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!