Tutorial Week 3 - Worksheets

# Tutorial Week 3 - Worksheets - date number of request 28 31...

This preview shows pages 1–2. Sign up to view the full content.

date number of request 4/2/2007 28 Number of observations 248 4/3/2007 31 Mean 17.16 4/4/2007 19 Standard deviation 5.53 4/5/2007 23 Min 4 4 4 4/10/2007 17 1st quartile 13 13 IQR 8 4/11/2007 11 Median 17 17 17 upper 33 4/12/2007 18 3rd quartile 21 21 lower 1 4/13/2007 19 Max 33 33 33 4/16/2007 19 4/17/2007 17 # Requests Frequency Percentage Five-number summary 4/18/2007 13 Min 4 1 0.00 Min 4 4/19/2007 27 5 0 0.00 1st quartile 13 4/20/2007 18 6 0 0.00 Median 17 4/23/2007 23 7 4 0.02 3rd quartile 21 4/24/2007 21 8 5 0.02 Max 33 4/25/2007 17 9 10 0.04 Boxplot numbers 4/26/2007 19 10 5 0.02 4/27/2007 11 11 11 0.04 13 4/30/2007 21 12 19 0.08 4 5/1/2007 25 13 14 0.06 4 5/2/2007 12 14 20 0.08 5/3/2007 23 15 17 0.07 5/4/2007 25 16 12 0.05 5/7/2007 17 17 19 0.08 5/8/2007 30 18 12 0.05 5/9/2007 21 19 18 0.07 calculate upper/lower fence 5/10/2007 12 20 14 0.06 equal or greater than the lower fence 5/11/2007 9 21 14 0.06 equal or less than the upper fence 5/14/2007 14 22 9 0.04 5/15/2007 20 23 11 0.04 5/16/2007 9 24 5 0.02 lower fence: 5/17/2007 23 25 8 0.03 1st quartile - minimum 5/18/2007 20 26 9 0.04 13-4=9 5/22/2007 14 27 2 0.01 5/23/2007 18 28 1 0.00 upper fence: 5/24/2007 16 29 2 0.01 max - 3rd quartile 5/25/2007 19 30 3 0.01 33-21 = 12 5/28/2007 29 31 1 0.00 5/29/2007 19 32 1 0.00 5/30/2007 14 Max 33 1 0.00 5/31/2007 17 248 1.00 6/1/2007 19 6/4/2007 21 6/5/2007 24 Histogram using Data Analysis ToolPack (Menu --> Data --> Data Analysis --> Histogram) 6/6/2007 22 6/7/2007 13 Bin definition Frequency table 6/8/2007 8 label definition (Data Analysis ToolPack Output) 6/11/2007 19 (0-5] 5 1 6/12/2007 25 (5-10] 10 24 6/13/2007 12 (10-15] 15 81 6/14/2007 13 (15-20] 20 75 6/15/2007 7 (20-25] 25 47 6/18/2007 22 (25-30] 30 17 6/19/2007 12 (30-35] 35 3 6/20/2007 26 6/21/2007 22 6/22/2007 22 6/25/2007 22 6/26/2007 21 6/27/2007 20 6/28/2007 16 6/29/2007 12 7/3/2007 11 7/4/2007 24 7/5/2007 8 7/6/2007 12 7/9/2007 23 7/10/2007 16 7/11/2007 13 7/12/2007 20 7/13/2007 15 7/16/2007 12 7/17/2007 18 7/18/2007 14 7/19/2007 19 7/20/2007 14 7/23/2007 14 7/24/2007 17 7/25/2007 21 7/26/2007 18 7/27/2007 11 7/30/2007 21 7/31/2007 24 8/1/2007 30 8/2/2007 19 8/3/2007 12 8/7/2007 15 8/8/2007 25 8/9/2007 12 8/10/2007 10 8/13/2007 12 8/14/2007 14 8/15/2007 16 8/16/2007 11 8/17/2007 9 8/20/2007 29 8/21/2007 16 8/22/2007 19 8/23/2007 12 8/24/2007 18 8/27/2007 17 8/28/2007 9 8/29/2007 14 8/30/2007 14 8/31/2007 7 9/4/2007 25 9/5/2007 16 9/6/2007 15 9/7/2007 12 9/10/2007 16 9/11/2007 20 9/12/2007 15 9/13/2007 15 9/14/2007 20 9/17/2007 13 9/18/2007 9 9/19/2007 17 9/20/2007 21 9/21/2007 22 9/24/2007 22 9/25/2007 17 9/26/2007 14 9/27/2007 19 9/28/2007 15 10/1/2007 23 10/2/2007 14 10/3/2007 14 10/4/2007 13 10/5/2007 13 10/9/2007 15 10/10/2007 9 10/11/2007 11 10/12/2007 9 10/15/2007 17 10/16/2007 26 10/17/2007 13 10/18/2007 13 10/19/2007 11 10/22/2007 23 10/23/2007 14 10/24/2007 18 10/25/2007 20 10/26/2007 14 10/29/2007 17 10/30/2007 13 10/31/2007 10 11/1/2007 15 11/2/2007 13 11/5/2007 26 11/6/2007 19 11/7/2007 12 11/8/2007 22 11/9/2007 26 11/13/2007 8 11/14/2007 21 11/15/2007 16 11/16/2007 17 11/19/2007 32 11/20/2007 24 11/21/2007 11 11/22/2007 20 11/23/2007 15 11/26/2007 26 11/27/2007 20 11/28/2007 17 11/29/2007 19 11/30/2007 19 12/3/2007 21 12/4/2007 17 12/5/2007 14 12/6/2007 18 12/7/2007 12 12/10/2007 30 12/11/2007 15 12/12/2007 15 12/13/2007 15 12/14/2007 11 12/17/2007 25 12/18/2007 7 12/19/2007 26 12/20/2007 19 12/21/2007 8 12/24/2007 18 12/27/2007 9 12/28/2007 13 12/31/2007 14 1/2/2008 7 1/3/2008 23 1/4/2008 10 1/7/2008 21 1/8/2008 20 1/9/2008 26 1/10/2008 17 1/11/2008 9 1/14/2008 20 1/15/2008 19 1/16/2008 15 1/17/2008 16 1/18/2008 4 1/21/2008 20 1/22/2008 10 1/23/2008 18 1/24/2008 15 1/25/2008 13 1/28/2008 26 1/29/2008 14 1/30/2008 17 1/31/2008 18 2/1/2008 16 2/4/2008 12 2/5/2008 16 2/6/2008 21 2/7/2008 21 2/8/2008 12 2/11/2008 23 2/12/2008 17 2/13/2008 27 2/14/2008 17 2/15/2008 17 2/18/2008 16 2/19/2008 21 2/20/2008 10 2/21/2008 26 2/22/2008 13 2/25/2008 25 2/26/2008 14 2/27/2008 14 2/28/2008 15 2/29/2008 8 3/3/2008 12 3/4/2008 20 3/5/2008 20 3/6/2008 25 3/7/2008 14 3/10/2008 33 3/11/2008 23 3/12/2008 15 3/13/2008 22 3/14/2008 9 3/17/2008 24 3/18/2008 18 3/19/2008 15 3/20/2008 11 3/25/2008 11 3/26/2008 19 3/27/2008 12 3/28/2008 12 3/31/2008 23 0 5 10 15 20 25 5 10 15 20 25 30 35 0 20 40 60 80 100 Chart Title Axis Title Axis Title

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Frequency Table (Select data --> Menu --> Insert --> PivotTable) group technique Count - technique
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern