Type up your solutions in a word document. Label each answer accordingly (1a, etc.) Put the answer in order. Copy Excel output onto your word document. Do not include the data. You may need to refer to the matched pairs section of Chapter 20 of your ebook.

Does a football filled with helium travel farther than one filled with ordinary air? To test this, the Columbus Dispatch conducted a study. Two identical footballs, one filled with helium and one filled with ordinary air, were used. A casual observer was unable to detect a difference in the two footballs. A novice kicker was used to punt the footballs. A trial consisted of kicking both footballs in a random order. The kicker did not know which football (the helium-filled or the air-filled football) he was kicking. The distance of each punt was recorded. Then another trial was conducted. A total of 39 trials were run. Here are the data for the 39 trials, in yards that the footballs traveled. The difference (helium minus air) is the response variable. M. B. Laferty "OSU scientist gets a kick out of sports controversy," The Columbus Dispatch, November 21, 1993.

Helium 25 16 25 14 23 29 25 26 22 26 Air 25 23 18 16 35 15 26 24 24 28 Difference 0 -7 7 -2 -12 14 -1 2 -2 -2 Helium 12 28 28 31 22 29 23 26 35 24 Air 25 19 27 25 34 26 20 22 33 29 Difference - 13 9 1 6 -12 3 3 4 2 -5 Helium 31 34 39 32 14 28 30 27 33 11 Air 31 27 22 29 28 29 22 31 25 20 Difference 0 7 17 3 -14 -1 8 -4 8 -9 Helium 26 32 30 29 30 29 29 30 26 Air 27 26 28 32 28 25 31 28 28 Difference -1 6 2-3 2 4 -2 2 -2A B C 1 Trial Air Helium 25 25 2 23 16 3 18 25 YOUAWN 4 16 14 5 35 23 6 15 29 8 26 25 9 8 24 26 10 9 24 22 11 10 28 26 12 11 25 12 13 12 19 28 14 13 27 28 15 14 25 31 16 15 34 22 17 16 26 29 18 17 20 23 19 18 22 261 20 19 33 35 21 20 29 24 22 21 31 31 23 22 27 34 24 23 22 39 Sheet1 +