You may use Minitab/ Excel for all of your calculations for all the problems, but must attach the relevant output (Minitab or Excel);You may use Minitab/ Excel for all of your calculations for all the problems, but must attach the relevant output (Minitab or Excel); You may use Minitab/ Excel for all of your calculations for all the problems, but must attach the relevant output (Minitab or Excel); You may use Minitab/ Excel for all of your calculations for all the problems, but must attach the relevant output (Minitab or Excel); You may use Minitab/ Excel for all of your calculations for all the problems, but must attach the relevant output (Minitab or Excel)13,9An agent for a residential real estate company in a suburb located outside of Washington,DC, 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 48 apartments in a particular residential neighborhood and collects the following data:Data for 13.9a. Construct a scatter plotb. Use the least-squares method to determine the regression coefficients b0 and b1c. Interpret the meaning of b0 and b1 in this problem.d. Predict the monthly rent for an apartment that has 800 square feet.e. Why would it not be appropriate to use the model to predict the monthly rent for apartments that have 1500 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 800 square feet for a monthly rent of $1130 and the other with 830 square feet for a monthly rent of $1410. Based on (a) through (d), which apartment do you think is a better deal?13,21 In Problem 13.9 , an agent for a real estate company wanted to predict the monthly rent for one bedroom apartments, based on the size of the apartment (stored in rent-sliverspring). Using the results of that problem.A, determine the coefficient of determination, r^2, and interpret its meaning.B, determine the standard error of the estimate.;