Consider the data set below, which has daily high temperatures in Paducah for the month of January for a number of different years. The data set also contains the long term average for each day of January. Upload a Word File and Excel File to Canvas: Single year 2020, Two years 2019, 2021.

Year Long-term Daily Average 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 1-Jan 43 64 66 46 36 45 30 53 59 37 49 29 44 46 17 47 54 54 2-Jan 43 63 68 48 22 54 25 35 38 33 41 41 48 60 22 41 55 41 3-Jan 43 62 49 50 31 65 23 44 35 40 28 63 49 57 33 43 54 44 4-Jan 43 61 60 55 46 64 25 47 48 43 44 52 39 37 24 43 43 52 5-Jan 43 64 39 59 55 32 24 39 57 43 46 30 43 28 30 57 56 51 6-Jan 43 39 35 53 68 36 31 45 65 42 10 36 47 21 27 64 51 45 7-Jan 43 37 49 46 70 46 29 46 57 45 23 26 52 24 44 60 51 38 8-Jan 43 37 65 44 67 43 16 33 53 55 38 26 55 29 44 64 55 37 9-Jan 43 50 60 46 51 57 21 29 55 57 36 28 52 46 47 44 59 36 10-Jan 43 59 52 46 59 59 23 34 55 66 51 33 29 62 60 38 64 32 11-Jan 43 66 50 55 46 39 36 31 46 62 52 40 37 68 64 37 67 31 12-Jan 43 68 63 62 53 48 37 27 43 69 56 38 43 71 32 44 40 44 13-Jan 43 66 60 61 43 43 44 32 32 50 58 30 41 37 26 44 50 51 14-Jan 43 30 42 62 40 49 54 43 43 28 56 35 60 42 25 35 52 55 15-Jan 43 35 47 61 36 19 56 49 45 33 33 36 56 43 31 39 60 44 16-Jan 43 26 60 27 40 19 52 39 63 33 46 51 38 64 14 45 50 41 17-Jan 43 26 57 36 42 48 48 46 67 46 37 57 35 63 20 49 44 43 18-Jan 43 30 49 41 39 44 56 46 36 47 45 56 22 46 31 47 61 49 19-Jan 43 46 64 40 31 35 60 33 50 57 45 61 26 60 41 55 32 51 20-Jan 43 57 66 41 25 30 57 30 43 46 57 58 35 62 50 28 25 46 21-Jan 43 39 59 43 43 41 56 22 36 35 39 56 31 71 61 28 30 50 22-Jan 44 39 39 39 40 56 44 31 66 23 32 43 31 63 63 51 36 46 23-Jan 44 28 48 41 37 59 55 36 59 46 23 40 35 49 45 53 42 44 24-Jan 44 44 58 43 28 33 55 43 52 34 29 51 39 55 46 39 43 45 25-Jan 44 59 47 39 31 25 39 37 40 41 50 44 56 64 60 31 39 46 26-Jan 44 50 51 51 38 32 34 39 45 47 62 38 48 40 60 45 51 50 27-Jan 44 37 55 46 47 32 41 45 43 52 20 45 42 45 55 48 49 36 28-Jan 44 42 64 30 55 27 37 48 46 64 20 50 55 47 57 53 35 37 29-Jan 45 37 58 41 63 28 24 58 52 71 31 56 50 41 43 31 38 46 30-Jan 45 37 53 34 37 36 28 54 62 56 40 45 65 50 37 22 42 50 31-Jan 45 39 51 29 34 31 34 46 61 41 46 45 68 63 60 36 44 42 Do the following data analysis in Excel: Project Due: Sunday Dec 5, 11:59pm

1. Find the long term average temperature for January by finding the average of the long term daily average column. Use the command =average() and give the cell the name mu. 2. Find the average and standard deviation for the years 2005 to 2021 using the commands average() and =stdev(). Find the average and standard deviation for all other years by highlighting the 2005 results and then clicking and dragging. Copy this calculations to your Word File. 3. Using a one sample t-test with null and = .05 find if your single year is consistent with or not (i.e. do you accept or reject the null?). You must type the formula for the t-statistic into Excel. You must look into the t-table to get the reject region. 4. Using data analysis from the data tab in Excel use t-test: Two-Sample Assuming Unequal Variances to find if your two given years have temperatures that are consistent with each other or not, use = .05 (i.e. do you accept or reject the null for the two sample test.?). From the Excel Two-Sample results use the PValue which is P(T<=t) two tailed. Copy the Excel results to your Word File If you do not have Data Analysis on your computer go to Canvas and look at Getting Data Analysis in Excel. The data above is on Canvas in an Excel File. In writing your results have a conclusion section at the end. In the conclusion section state the purpose of the project what is the project trying to achieve? to show? Include the steps with numbers in the Hypothesis Testing Algorithm. Do this once for the one sample t-test and once for the two sample t-test. In writing up your results use complete English sentences. Give your conclusions (consistent or not) and the reasons for conclusions (accept or reject). Some of the steps for the hypothesis testing algorithm would look something like: Step #0:What is the data? n=31 days of maximum daily temperature, X2004 =42.29032, s2004 = 12.74152 Step #1: The null hypothesis is 2004 = 43.419. Step #2: Type in the appropriate alternative. Step#3: t(data)=42.29043.419 12.742 31 =0.20278 Step#4: Get reject region from the t-curve. Step#5 Compare t(data) to t(reject) and interpret the results (give your conclusions). or Step #0 X2003 =37.00000, s2003 = 10.76723, X2004 =42.29032, s2004 = 12.74152, Step #1: Null: 2003 = 2004 Step #2 Type in the appropriate alternative. Step #3: t(data)=37.0000042.29032 10.767232 31+12.741522 31 =1.76572 Step#4: Get reject region from the t-curve. Step#5 Compare t(data) to t(reject) and interpret the results (give your conclusions). The null is that the average temperature in 2004 is the same as the long term average temperature. Get this from Excel, do not do it by hand. Get this from Excel, do not do it by hand.

Choose the appropriate reject region then copy and paste into Word. t-Test: Two-Sample Assuming Unequal Variances 20032004 Mean 37 42.29032 Variance 115.9333 162.3462 Observations 31 31 Hypothesized Mean Difference 0 df 58 t Stat -1.76572 P(T<=t) one-tail 0.041353 t Critical one-tail 1.671553 P(T<=t) two-tail 0.082706 t Critical two-tail 2.001717 t(rej)= 0 Rej Acc Acc Rej 0 t(rej)= Rej Acc Rej t(rej)= 0 t(rej)= Diagrams from Text Boxes and shapes from Insert, Shapes or Insert, Illustrations, Shapes,