In 2022, the average monthly residential natural gas bill for customers in Cheyenne, Wyoming, is $67.95. How is the monthly average gas bill for a Cheyenne home related to the company they get service, the square footage, and number of rooms of the home? The following data show the average monthly bill over the past year,the company they get service, the square footage, and number of rooms of a sample of 30 Cheyenne homes. Average 1:;[:::;"}1' Square | Number | Company i Taa Footage | of Rooms Name Year 70.20 2537 6 Black Hills a) Develop an estimated regression equation that can be used to predict 81.33 3437 8 Star a residence's average monthly gas bill for the last year given its square footage. 45.86 976 6 Star b) Develop an estimated regression equation that can be used to predict 59.21 1713 7 Black Hills a residence's average monthly gas bill for the last year given the company name and number of rooms. 117.88 3979 11 Star c) At the 0.05 level of significance, test whether the two independent variables added 1in part (b). 57.78 1328 7 Black Hills the company name and the number of rooms, contribute significantly to the estimated 47.01 1251 6 Black Hills regression equation in part (a)? Explain the test results. 52.89 827 5 Black Hills 32.90 645 4 Star 67.04 2849 5 Star Note: Your answer should be on the same sheet. 76.76 2392 7 Star 60.40 900 5 Black Hills 44.07 1386 5 Black Hills 26.68 1299 4 Black Hills 62.70 1441 6 Star 45.37 562 4 Black Hills 38.09 2140 4 Star 45.31 908 6 Black Hills 52.45 1568 5 Star 96.11 1140 10 Black Hills 82.23 1100 8 Star 97.21 1200 5 Black Hills 86.32 985 4 Black Hills 79.25 750 4 Black Hills 102.36 1400 8 Star 99.32 1150 9 Black Hills 69.75 960 8 Star 89.68 850 7 Star 112.89 1055 10 Star 68.68 790 8 Black Hills