IMPORTANT: This is an individual assignment, you are NOT allowed to receive or give assistanc This assignment has THREE spreadsheets A sample of 14 days show daily cargo volumes processed at the airport of Atlanta. Another sample of 16 from the airport of Chicago show daily cargo volumes processed at the airport of Observation Atlanta [ton th] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 2 points 1 point Chicago [ton th] 29 37 23 9 40 16 25 13 24 29 15 6 21 14 39 7 36 26 12 37 36 12 36 14 20 29 12 39 20 28 Use the appropriate Excel Add-in to conduct an hypothesis test and generate the output inside this green (ignore the fact that these numbers keep changing, just generate the output) Get the p-value (from the output) to test whether the Atlanta airport daily cargo is greater than the Chica <----enter p-value inside this cell eive or give assistance of any kind processed at the airport of Chicago. the output inside this green box -------> go is greater than the Chicago daily cargo. IMPORTANT: This is an individual assignment, you are NOT allowed to receive or give assistanc This assignment has THREE spreadsheets A sample of 22 workers shows the number of overtime hours in June and in July. Worker June [hr] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2 points 1 point July [hr] 10 9 17 11 20 10 37 23 36 28 33 38 8 13 35 28 40 41 37 34 20 13 23 22 21 20 38 25 32 10 14 34 20 16 19 17 24 28 5 22 8 28 36 39 Use the appropriate Excel Add-in to conduct an hypothesis test and generate the output inside this green (ignore the fact that these numbers keep changing, just generate the output) Get the p-value (from the output) to test whether the mean overtime hours in June is different than the <----enter p-value inside this cell o receive or give assistance of any kind erate the output inside this green box -------> ours in June is different than the number in July. IMPORTANT: This is an individual assignment, you are NOT allowed to receive or give assistanc This assignment has THREE spreadsheets 'Number of overtime hours' versus 'Years of experience': A sample of 444 workers showed the following: <2 number of overtime hours <10 10-20>20 Total Years of Experience 2-5 >5 23 62 78 163 40 45 77 162 Total 15 72 32 119 78 179 187 444 2 points Calculate the Expected frequencies inside this green box -------------------> 2 points Use the Excel formula to get the p-value to test whether 'Number of overtime hours' depends on 'Years of expe <-------- enter p-value formula inside this cell ive or give assistance of any kind owed the following: depends on 'Years of experience'