energy usage furnace water heater kilowatt hours temp setting temp setting 7578 8554 8389 8450 8438 8354 8776 8118 8593 8531 7682 7725 8038 9038 7954 7552 8897 8158 7933 7724 7889 7817 8629 7311 8004 8684 7980 8147 8245 7811 7961 8300 8048 8375 8739 7947 7868 7433 8088 7951 8328 8074 8607 19 23 23 22 22 20 23 21 24 22 19 19 19 23 18 18 24 21 21 19 19 22 24 18 22 22 19 22 21 19 22 22 19 22 24 19 19 19 22 19 22 20 22 53 58 50 49 55 52 66 56 49 65 50 53 52 62 61 64 65 63 60 51 51 54 53 52 57 57 49 52 59 61 49 64 58 52 65 53 59 53 54 54 62 63 62 Enmax has been receiving c Produce a multiple regressio 1- Report to enmax the com 3- Design a half page insert, 8128 8064 9058 8322 8366 8269 8059 8397 7927 7692 8558 8026 8409 8642 7711 7759 8414 8581 8021 7476 8677 8484 8400 7306 8565 7750 8490 8200 8195 8495 7644 8626 7708 9058 8530 8704 7720 7868 8322 8434 8302 8607 8084 8579 8285 19 19 24 22 22 22 22 22 19 18 22 22 21 23 19 19 24 22 19 18 23 23 23 18 22 18 18 24 21 23 18 24 19 24 23 24 18 20 19 22 23 20 21 24 22 60 53 64 59 54 60 62 66 59 54 51 49 57 64 54 51 50 57 59 53 51 60 49 54 58 56 62 58 62 61 50 57 51 63 56 63 62 52 58 49 62 56 64 52 52 8293 8647 7896 8150 8496 7784 8570 7890 8087 8312 8411 8817 20 23 19 21 22 19 23 19 21 22 19 23 64 53 59 52 59 58 61 60 55 62 58 63 Enmax has been receiving complaints about the high cost of Utilities. In an effort to educate customers about how much they could save Produce a multiple regression model with electricity usage as the dependant variable. Run the regression in excel and turn in a copy of y 1- Report to enmax the complete results of your regression model. 2- Use your model to predict the energy usage of a customer who se 3- Design a half page insert, to be sent in next months bills, based on your regression results, that will educate consumers about how muc Half Page insert is to be sent back to the company and provides a clear explaination of our fi out how much they could save by turning down the temperature settings on their furnace and hot water tanks, they took a sample of 100 n excel and turn in a copy of your regression output along with your answer. y usage of a customer who sets their furnace to 22 degrees and their hot water tank to 58 degrees. ******* continued on next page***** ate consumers about how much money they could save by turning down their heat settings. s a clear explaination of our findings. ks, they took a sample of 100 homes in Calgary and asked them what temperature their furnace and water tank were set to. The excel file continued on next page************ tank were set to. The excel file contains the sample data where Enmax matched the electricity used per month (measured in kilowatt hours th (measured in kilowatt hours) with the reported thermometer settings (in degrees Celsius)
