Please show me how to use excel to understand thank you 129

Please show me how to use excel to understand. thank you

12.9 An agent for a residential real estate company has the  
business objective of developing more accurate estimates of  
the monthly rental cost for apartments. Toward that goal, the  
agent would like to use the size of an apartment, as defined  
by square footage to predict the monthly rental cost. The  
agent selects a sample of 25 apartments in a particular residential  
neighborhood and collects the following data  

1750

1200

a. Construct a scatter plot.  
b. Use the least-squares method to determine the regression  
coefficients and  
c. Interpret the meaning of and in this problem.  
d. Predict the monthly rent for an apartment that has 1,000  
square feet.  
e. Why would it not be appropriate to use the model to predict  
the monthly rent for apartments that have 500 square feet?  
f. Your friends Jim and Jennifer are considering signing a  
lease for an apartment in this residential neighborhood.  
They are trying to decide between two apartments, one  
with 1,000 square feet for a monthly rent of $1,275 and  
the other with 1,200 square feet for a monthly rent of  
$1,425. Based on (a) through (d), which apartment do  
you think is a better deal?

Solution