Jamie Boyd
Data Analysis
1.
Many downhill skiers eagerly look forward to the winter months and fresh snowfalls. However, winter
also entails cold days. How does the temperature affect skiers' desire to be on the slopes? To answer
this question, a local ski resort recorded the temperature for 50 randomly selected days and the
number of lift tickets sold. Both variables are stored in the attached homework_4_dataset.xls file (use
sheet #1). Use a graphical technique to describe the data and interpret your results.
2. Three men were trying to make the football team as punters. The coach had each of them punt the ball 50
times and the distances were recorded in columns 1, 2, and 3 in the attached homework_4_dataset.xls file (use
sheet #2). Use formulas such as AVERAGE and STDEV and then specify the range of cells for which to
compute the mean and the standard deviation. Example: =AVERAGE(B2:B33), etc.
a. Compute the mean and standard deviation for each punter.
Mean
P1= 39.22
P2= 39.36
P3= 40.14
Standard Deviation
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '05
 Jensen
 Standard Deviation, Mean, Jamie Boyd

Click to edit the document details