excel question! please answer all parts.

The data cable valable below gives the annual cost per square foot of commercial leases for office space in a why and the reciprocal of the number of square feet Use the cost per square foot on the response variable and the reciprocal of the number of our feet as the exploratory variable to complete porta a through m Click the icon to view the datatabi How many leasen te outside ne 95prediction ervais forses of her slee? Does the location of these data indicate a problem with Defined model Hint Are all of these residuals on the same sido, poslive or negative of the regression? There was that letude the 95% prediction interval (you a whole number Does this indicate a problem with the site oder O A Yes of the residuals for these data are negative O Nome residus for these data we every vided between positive and negative OC. Yes, of the residuals for these data are positive OD. No, none of the leases e outside the prediction interval thi Given the context of the problem costs of asing commercial property is several posible turking are that might be responsible for the tre and position des with turp residual.com Which of the following are posibleng arables? Select all that DA The location of the bly D. The type of building OC. The type of business D. The condition of the building OL. The economic conditions in the city OR The store building DO The location of the building within the city (c) The lases with the for largest res have something in common What it and does it help you dently aking sariable? What do the four names with the largest in terms of absolute value in common? DA The walues for these were minimum and the mum values O. The for these ses are near the man ve OC. The value for these are near the minimum O The waves for these new the evalue Does this helpilya ning variable? te predeton interve for these values Cost Square Foot 18.576 18.259 16.615 18.255 17.821 17.825 19.063 16.667 16.573 17.608 18.011 17.729 17.218 20.852 18.547 18.107 17.713 17.919 17.533 18.218 18.405 16.507 17.659 19.362 18.528 1 Number of Square Feet 0.00037947 0.00049115 0.00000947 0.00033593 0.00040821 0.00013289 0.00048672 0.00018265 0.00030282 0.00029999 0.00007225 0.00022183 0.00002824 0.00032304 0.00039778 0.00043388 0.00003055 0.00040895 0.00026675 0.00028347 0.00033192 0.00008564 0.00013065 0.00043747 0.00047707 Cost Square Foot 18.833 17.502 18.305 17.755 17.035 16.483 18.659 17.096 17.367 18.261 16.876 16.802 18.194 20.409 17.758 18.489 18.183 19.478 17.805 17.345 16.861 18.397 18.465 18.258 19.316 1 Number of Square Feet 0.00047138 0.00040091 0.00022631 0.00031546 0.00024573 0.00036728 0.00037808 0.00020655 0.00011411 0.00033904 0.00012208 0.00001808 0.00008453 0.00033465 0.00010437 0.00020328 0.00045848 0.00049482 0.00048311 0.00014198 0.00018029 0.00041544 0.00028515 0.00034554 0.00046663 The data cable valable below gives the annual cost per square foot of commercial leases for office space in a why and the reciprocal of the number of square feet Use the cost per square foot on the response variable and the reciprocal of the number of our feet as the exploratory variable to complete porta a through m Click the icon to view the datatabi How many leasen te outside ne 95prediction ervais forses of her slee? Does the location of these data indicate a problem with Defined model Hint Are all of these residuals on the same sido, poslive or negative of the regression? There was that letude the 95% prediction interval (you a whole number Does this indicate a problem with the site oder O A Yes of the residuals for these data are negative O Nome residus for these data we every vided between positive and negative OC. Yes, of the residuals for these data are positive OD. No, none of the leases e outside the prediction interval thi Given the context of the problem costs of asing commercial property is several posible turking are that might be responsible for the tre and position des with turp residual.com Which of the following are posibleng arables? Select all that DA The location of the bly D. The type of building OC. The type of business D. The condition of the building OL. The economic conditions in the city OR The store building DO The location of the building within the city (c) The lases with the for largest res have something in common What it and does it help you dently aking sariable? What do the four names with the largest in terms of absolute value in common? DA The walues for these were minimum and the mum values O. The for these ses are near the man ve OC. The value for these are near the minimum O The waves for these new the evalue Does this helpilya ning variable? te predeton interve for these values Cost Square Foot 18.576 18.259 16.615 18.255 17.821 17.825 19.063 16.667 16.573 17.608 18.011 17.729 17.218 20.852 18.547 18.107 17.713 17.919 17.533 18.218 18.405 16.507 17.659 19.362 18.528 1 Number of Square Feet 0.00037947 0.00049115 0.00000947 0.00033593 0.00040821 0.00013289 0.00048672 0.00018265 0.00030282 0.00029999 0.00007225 0.00022183 0.00002824 0.00032304 0.00039778 0.00043388 0.00003055 0.00040895 0.00026675 0.00028347 0.00033192 0.00008564 0.00013065 0.00043747 0.00047707 Cost Square Foot 18.833 17.502 18.305 17.755 17.035 16.483 18.659 17.096 17.367 18.261 16.876 16.802 18.194 20.409 17.758 18.489 18.183 19.478 17.805 17.345 16.861 18.397 18.465 18.258 19.316 1 Number of Square Feet 0.00047138 0.00040091 0.00022631 0.00031546 0.00024573 0.00036728 0.00037808 0.00020655 0.00011411 0.00033904 0.00012208 0.00001808 0.00008453 0.00033465 0.00010437 0.00020328 0.00045848 0.00049482 0.00048311 0.00014198 0.00018029 0.00041544 0.00028515 0.00034554 0.00046663