Question
A real estate agent wanted to find the relationship between sale price of houses and the size of the house. She collected data on two
A real estate agent wanted to find the relationship between sale price of houses and the size of the house.
She collected data on two variables recorded in the following table for 15 houses in Seattle. The two variables
are
PRICE= Sale price of houses in thousands of dollars
SIZE= Area of the entire house in square feet.
PRICE 455 278 463 327 505 264 445 346 487 289 434 411 223 323 488
SIZE 2500 2250 2900 1800 3200 2400 2700 2050 2850 2400 2600 2300 1700 2300 2980
a) Using MICROSOFT EXCEL- run the above regression and copy the output into your assignment word document
from which you can write down the least square regression line. Write down the least square regression line
from that specific output. USE THE NAME OF VARIABLES WHEN YOU WRITE THE EQUATION.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started