1. What is the Average temperature of all the States in the US during winter? How would you interpret the Result? [4ptsl 2. What is the Average temperature of all the States in the US during summer? How would you interpret the Result? [aptsi 3. What the median temperature during winter? During Summer? [2pts.l ii: What state has the maximum temperature during summer?[1ptl 5. What state has the minimum temperature during winter? i1pt} Standard Deviation: {1pt} Interpretation: {Sptsl Variance: ilpt] Interpretation: {Sptsl Excel Screenshotr'File: {luptsl Descriptive Statistics using Excel Calculate the Mean, Median, Mode, Standard Deviation, Range, Variance, Minimum and Maximum using Microsoft Excel. You may use the Descriptive Excel Add-in or by using the manual excel computation. Answer the questions that follow. Send your answers in Excel File or You can Screenshot the excel file together with your answers. 1. State Temp in Winter Temp in Summer Alabama 46.5 78.6 Alaska 2.6 52.3 Arizona 43.6 78.1 Arkansas 41.5 78.8 California 46.2 73.4 Colorado 25.8 65.2 Connecticut 28.5 69.2 Delaware 36.1 74.2 Florida 59.4 81 Georgia 47.8 78.7 Hawaii 67.4 72.2 Idaho 25.4 63.7 Illinois 28.3 73.4 Indiana 29.4 72.4 Iowa 21.7 71.6 Kansas 31.9 76.4 Kentucky 35.9 74.5 Louisiana 50.9 81.1 Maine 16.8 63.7 Maryland 34.7 73.3 Massachusetts 27.4 68 Michigan 21.7 66.2 Minnesota 12.4 66.8 Mississippi 46.7 79.5 Missouri 32.3 75.4 Montana 21.2 64.2 Nebraska 25.7 71.8 Nevada 32.2 69 New Hampshire 21.1 65.5 New Jersey 33 72.2 New Mexico 36.1 71.4 New York 23.3 66.5 North Carolina 42.1 75.7 North Dakota 12.2 66.6 Ohio 29.5 70.9 Oklahoma 39.1 79.6 Oregon 34 63.7 Pennsylvania 28.4 68.6 Rhode Island 31.4 68.8 South Carolina 46.1 78.4 South Dakota 19.5 69.9 Tennessee 39.1 75.6 Texas 47.9 81.1 Utah 28.2 69.6 Vermont 19.4 65.1 Virginia 36.8 73.2 Washington 33 63.8 West Virginia 32.8 70.2 Wisconsin 17.2 66.8 Wyoming 21.2 63.5 What is the Average t I the States in the US during winter? How