c) Using the spreadsheet data in Table 1 given below with energy use and HDD by...

 

Transcribed Image Text:

c) Using the spreadsheet data in Table 1 given below with energy use and HDD by month for 2020, develop a scatter plot and show the linear equation and Regression factor. Is this a line of good fit and why? d) If the reference temperature is 18 C, find the average monthly outside temperature values using table 1. e) Using model obtained from part (c), what is the monthly energy use for HDD=175? Month Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 HDD 409 370 239 142 76 9 6 2 78 204 Table 1 258 302 Energy use (kWh) 586307 494548 388225 182125 127000 77130 35546 20769 147408 285373 301048 410458 c) Using the spreadsheet data in Table 1 given below with energy use and HDD by month for 2020, develop a scatter plot and show the linear equation and Regression factor. Is this a line of good fit and why? d) If the reference temperature is 18 C, find the average monthly outside temperature values using table 1. e) Using model obtained from part (c), what is the monthly energy use for HDD=175? Month Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 HDD 409 370 239 142 76 9 6 2 78 204 Table 1 258 302 Energy use (kWh) 586307 494548 388225 182125 127000 77130 35546 20769 147408 285373 301048 410458

Answer rating: 100% (QA)

Lets work through each part c Scatter Plot and Linear Regression First well create a scatter plot us... View the full answer