In this lab, we will explore some statistical concepts in Excel. When you are finished, you will use Moodle to upload the Excel spreadsheet with your completed lab.

Your filename should have the format: ma116Lab06YOURNAME.xls.

1. Go to http://www.nfl.com/teams and enter the points scored for the 2008 Eagles and Steelers into two different columns in an Excel spreadsheet.

2. Calculate the five-number summary for each team and enter it in a cell in your Excel spreadsheet. Note that you can sort the scores into ascending order to help with calculating Q1 and Q3. Clearly label your answers.

3. Calculate the mean and standard deviation for each dataset (you may use the built-in Excel functions to do this), and clearly label your answers.

4. Based on your stats, who do you think would win if each of these teams played? Explain why, putting your answer in Excel.

5. These teams played during the regular season in 2008. Who won? Did the results agree with your prediction? Why, or why not?

6. Toss 10 coins and record the number of heads you obtained. Repeat this 24 more times until you have a list of 25 numbers, each of them between 0 and 10. You may flip the coins "electronically," using the rand() function and following the instructions given in lab.

7. Enter the following table into your Excel spreadsheet, and update it with your numbers.

8. Create a scatterplot of this data. Describe what your curve looks like, including where it is centered and what the spread is.