rental silver spring Size (Sq. ft.) Rent ($) 5241110 An agent for a residential real estate company in a suburb located outside of Washington, DC, has the business objective of developing more...

please provide answers in same excel sheet


rental silver spring Size (Sq. ft.) Rent ($) 5241110 An 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 one-bedroom apartments and collects and stores the data in RentSilverSpring . 6161175 a. Construct a scatter plot. 6661190 8301410 b. Use the least-squares method to determine the regression coefficients b0 and b1. 4501210 5501225 7801480c. Interpret the meaning of b0 and b1 in this problem. 8151490 10701495 d. Predict the mean monthly rent for an apartment that has 800 square feet. 6101680 8351810 6601625e. Why would it not be appropriate to use the model to predict the monthly rent for apartments that have 1,500 square feet? 5901469 6751395 7441150f. Your friends Jim and Jennifer are considering signing a lease for a one-bedroom apartment in this residential neighborhood. They are trying to decide between two apartments, one with 800 square feet for a monthly rent of $1,130 and the other with 830 square feet for a monthly rent of $1,410. Based on (a) through (d), which apartment do you think is a better deal? 8201140 9121220 6281434 6451519 8401105 8001130 8041250 9501449 8001168 7871224 9601391 7501145 6901093 8401353 8501530 9651650 10601740 6651235 7751550 9601545 8271583 6551575 5351310 6251195 7491200 6341185 6411444 8601385 7401275 5931050 8801650 8951340 6921560 starbuck TearViscosityPressurePlate Gap 0.00350.00180.000.0013.7 Starbucks Coffee Co. uses a data-based approach to improv-ing the quality and customer satisfaction of its products. When survey data indicated that Starbucks needed to improve its pack-age-sealing process, an experiment was conducted to determine the factors in the bag-sealing equipment that might be affecting the ease of opening the bag without tearing the inner liner of the bag. (Data extracted from L. Johnson and S. Burrows, “For Starbucks, It’s in the Bag,” Quality Progress, March 2011, pp. 17–23.) One factor that could affect the rating of the ability of the bag to resist tears was the plate gap on the bag-sealing equipment. Data were collected on 19 bags in which the plate gap was varied. The results are stored in Starbucks . 0.00350.00170.000.00 0.45319.00186.001.80 0.85380.00174.001.80 a. Construct a scatter plot. 0.35350.00180.000.00 0.30300.00180.000.00 b. Assuming a linear relationship, use the least-squares method to determine the regression coefficients b0 and b1. 0.70400.00180.000.00 1.90350.00190.000.00c. Interpret the meaning of the slope, b1, in this problem. 0.25350.00180.000.00 0.10319.00186.00-1.80 d. Predict the mean tear rating when the plate gap is equal to 0. 0.15380.00186.00-1.80 3.90350.00180.003.00 e. What should you tell management of Starbucks about the rela-tionship between the plate gap and the tear rating? 0.00380.00174.00-1.80 0.55350.00180.000.00 0.00350.00180.00-3.00 0.05319.00174.00-1.80 0.40319.00174.001.80 4.30380.00186.001.80 0.00350.00180.000.00 13.45 In Problem 13.7 on page 437, you used the plate gap in the bag-sealing equipment to predict the tear rating of a bag of coffee. The data are stored in Starbucks . Use the results of that problem a. At the 0.05 level of significance, is there evidence of a linear relationship between the plate gap of the bag-sealing machine and the tear rating of a bag of coffee? b. Construct a 95% confidence interval estimate of the population slope, b1.