Question: Please provide excel worksheet with and without formulas. I will not be able to complete this problem without them. If they are provided a thumbs


Intro The following table shows the square footage and most recent sales price for several houses in the same neighborhood of a city A B Price 1 House Sq. ft. ($1,000) 2 A 1,400 540 3 B 1,750 790 4 800 400 5 D 1.150 490 6 E 2,100 780 F 1,200 540 8 G 980 380 9 H 1,630 850 5 7 8 Part 1 - Attempt 1/10 for 10 pts. Regress the prices on the square footage. What is the intercept of the regression line? 0+ decimals Submit Part 2 Attempt 1/10 for 10 pts. You're interested in buying a house with an area of 1,270 square feet. What price should you expect to pay in $1,000)? 0+ decimals Submit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
