Stat 217
Lab 3

1: Background 2: Files Needed 3: Data Collection 4: Explore Data 5: Thought Questions 6: Inference 7: Simulation 8: Discussion 9: Conclusions 10: Applications 11: Summary

Explore the data

The arrival times can be found in this Excel file: PartyArrival.xls. Our first task is to convert these arrival times into "minutes after 9:30pm."

In cell B2, type =HOUR(A2)

In cell C2, type =MINUTE(A2)

In cell D2, type =SECOND(A2)

Then in E2, use this formula: =(B2+C2/60+D2/3600-21.5)*60

Give this column an appropriate one-word name

(a) Take a screen capture of the first few rows and paste into your lab report. Explain what these numbers now represent (and describe how they were calculated).

 

(b) Create a graph of these results. You can do so in the Theory-Based Inference applet (open in a separate window):

• Select the E column in Excel (by clicking on the E), copy to your clipboard, toggle to the applet, use the pull-down menu to select One Mean, and check the Paste Data box, check the Includes header box, clear the existing data, click inside the Sample Data window and paste. Press Use Data.

Include a screen capture of the dotplot and the summary statistics in your lab report.

(c) Write a paragraph describing this distribution in context. [Hint: This distribution is a bit more interesting than most and may not fit into our short-hand descriptions very easily. Also be sure to reference the numerical summaries.]