I am completely confused about how to do what the questions are asking me. I am unsure of how to set up these numbers in excel and do the calculations. The question in my statistics class is:

Political scientists love to watch The Simpsons, so much so that some will watch it for several hours a day. The following figures are the average number of hours per day that seven political scientists spend watching re-runs of The Simpsons.

1 5 .5 1 9 8 11 3 0

Make the following calculations in Excel.

1. What is the sum of squares for the number of hours these political scientists spent watching The Simpsons?
2. What is the variance?
3. What is the standard deviation?
4. The z scores
5. The mean of the z scores
6. The standard deviation of the z scores