CENGAGE |MINDTAP Q Search this course ? Chapter 3 Assignment X X Check My Work 2. 3. O Spreadsheet eBook A-Z The file P02_56.xIsx contains monthly values of indexes that measure the amount of energy necessary to heat or cool buildings due to outside temperatures. (Se explanation in the Source sheet of the file. ) These are reported for each state in the United States and also for several regions, as listed in the Locations sheet, fr 2000. For each of the Heating Degree Days and Cooling Degree Days sheets, create a new Season variable with values "Winter," "Spring," "Summer," and "Fall." Winter: (Dec, Jan, Feb) Spring: (Mar, Apr, May) Summer: (Jun, Jul, Aug) Fall: (Sep, Oct, Nov) a. Find the mean, median, and standard deviation of Heating Degree Days (HDD), broken down by Season, for the 48 contiguous states location (code 5999). (I first and last rows for the given location, the ones that contain -9999, the code for missing values. ) Round your answers to two decimal places, if necessary. 48 states HDD (Fall) HDD (Spring) HDD (Summer) HDD (Winter) One Variable Summary HDD 5999 Data HDD 5999 Data HDD 5999 Data HDD 5999 Data Mean 2436.3 X 1106.0. X 63.03 X 873.65 X Std. Dev. 266.30 161.01 X 12.95 X 127.69 X Median 2465.0 1120.0 X 60.00 X 882.00 X Select the appropriate side-by-side box plots of HDD, broken down by season. (i) Boxplots of HDD vs Season for Location 5999 (ii) Boxplots of HDD vs Season for Location 5999 1400 1400