Stat 31 Section 5

TR 2:00 - 3:15pm
Greenlaw 101
Syllabus

Instructor: Elizabeth Shamseldin

Contact Information
Office: Howell 200-B
Phone: 962-7512
Email: shamseld@email.unc.edu

Office Hours
Tuesday: 11:30am - 12:30pm
Tuesday: 3:15 - 4:00pm
Thursday: 12:30 - 1:30pm

Instructional Assistant
Mihee Lee, Howell 108
miwing@email.unc.edu
Office Hour: Wed 2:30 - 3:30pm

 

Important Dates

  • Tuesday, October 4 - First Midterm Exam
  • Monday, October 10 - University Deadline to Drop Course
  • Tuesday, November 8 - Second Midterm Exam
  • Saturday, December 17 (4pm) - Final Exam

 

Annoucements

Date Posted

· Additional Final Review: 3pm Thursday, 12/15 Howell 201

·  Final Review: 1pm Friday, 12/16 Venable 207

·  12/09 Practice Quiz 3:Solutions quiz3F05Solutions.pdf

·  12/01 Practice Quiz 3: quiz3F05.pdf

·  11/17 Excel Due: Tuesday, 11/22 See below

·  11/01 Upcoming Midterm: Tuesday, 11/08 Sections 2.4 - 4.4

·  11/01 Midterm Review: 6pm Monday, 11/07 Greenlaw 101

·  10/25 No Office Hours Tuesday, Oct 25th

·  10/12 HW11 Postponed: Due Tuesday, 10/18

·  9/27 Midterm Review Session: Monday, Oct 3rd: 6:00pm - Greenlaw 101

·  9/27 Upcoming Midterm: Tuesday, Oct 4th: Sections 1.1 - 2.3

·  9/12 Upcoming Quiz: Tuesday, Sept 20th: Chapter One

·  9/01 If Not Registered: See Rosalie in Smith 102B

·  8/30 Upcoming Excel: Due Tuesday 9/06

·  8/30 First Day of Class: Tuesday 8/30


Scores

 

Annoucements

Date Posted

·  11/21 Office Hour Change: Tuesday,11/22 1-1:50pm.  No11:30 office hour.

·  11/17 Excel Due: Tuesday, 11/22 See below

·  11/01 Upcoming Midterm: Tuesday,11/08 Sections 2.4 - 4.4

·  11/01 Midterm Review: 6pm Monday,11/07 Greenlaw 101

·  10/25 No Office Hours Tuesday, Oct25th

·  10/12 HW11 Postponed: Due Tuesday,10/18

·  9/27 Midterm Review Session: Monday,Oct 3rd: 6:00pm - Greenlaw 101

·  9/27 Upcoming Midterm: Tuesday, Oct4th: Sections 1.1 - 2.3

·  9/12Upcoming Quiz: Tuesday, Sept20th: ChapterOne

·  9/01 If Not Registered: See Rosalie in Smith 102B

·  8/30 Upcoming Excel:Due Tuesday 9/06

·  8/30 First Day of Class: Tuesday 8/30


Scores

Due

REVIEW

NOT DUE

 

 

Thurs 12/08

 

 

 

Tues 12/06

 

 

Thurs 12/01

 

 

Tues 11/29

 

 

Tues 11/22

 

 

Thurs 11/17

 

 

Tues 11/15

 

 

Thurs 11/10

 

Review – NOT DUE

 



Thurs 11/03




Tues 11/01




Thurs 10/27




Tues 10/25




Tues 10/18
DUE: BOTH
HW11 & HW12
(Turn-In 11 & 12
Separately)

Tues 10/18




Tues 10/11




Thurs 10/6




Review:
NOT DUE



Thurs 9/29




Thurs 9/22
*Postponed:
Due: Tues 9/27


Tues 9/20




Thurs 9/15




Tues 9/13




Thurs 9/08




Tues 9/06




Thurs 9/01

Homework: Moore/McCabe:

FINAL REVIEW
1.133, 1.141, 2.65, 2.89, 2.103, 2.104a, 2.111, 3.81, 3.90, 4.76
4.113, 4.117, 4.119, 4.123, 5.55, 5.61, 5.63, 6.107, 6.109
8.77ab, 7.13, 7.27abc, 7.35, 7.37

 

HW23
Read Section 7.1
8.21, 8.23a, 7.19* for n=10,20,30,101,1001

*Note: Uses Table D on back cover of book
We will go over in class on Thursday

 

HW22
Read Section 7.1 and pgs 541-542
6.41, 6.45, 6.55a, 6.61, 6.63 

 

HW21
Read Section 6.2
5.31, 6.5, 6.7, 6.25, 6.35, 6.37

 

No HW
Happy Thanksgiving

 

HW20
Read Section 5.2, 6.1
5.11, 5.12, 5.17

 

HW19
Read Section 5.2
5.1, 5.3, 5.5, 5.9

 

HW18
Read Section 5.1
4.105, 4.107, 4.109, 4.110, 4.111, 4.112


HW17
Read Section 4.5
4.92, 4.93, 4.94, 4.95, 4.96, 4.97

 

Review
2.63, 2.83a, 2.87, 2.94, 3.7, 3.19, 3.87, 3.33, 3.53, 3.69

4.11, 4.17, 4.31, 4.32, 4.47, 4.48, 4.65, 4.75, 4.84

 

 

HW16
Read Section 4.5
4.59, 4.69, 4.73, 4.79, 4.83


HW15
Read Section 4.4
4.43, 4.45, 4.51, 4.54, 4.58


HW14
Read Section 4.3
4.4, 4.10, 4.13, 4.29, 4.33


HW13
Read Section 4.1, 4.2
3.62, 3.63, 3.71bc, 3.75

HW12
Read Section 4.1, 4.2
3.29, 3.32, 3.49, 3.51, 3.58




HW11
Read Section 3.3, 3.4
3.4, 3.5, 3.10, 3.13, 3.18


HW10
Read Section 3.1, 3.2
2.85, 2.86, 2.91, 2.92


HW9
Read Section 2.5
2.62, 2.65, 2.71, 2.74


REVIEW
1.13, 1.19, 1.47, 1.68, 1.72, 1.81, 1.99, 1.100, 1.108, 1.122
2.5, 2.13, 2.14, 2.33, 2.53, 2.55, 2.56


HW8
Read Section 2.4
2.42, 2.43, 2.47, 2.58


HW7
Read Section 2.3
2.29, 2.30, 2.32


HW6
Read Section 2.2
2.1, 2.3, 2.7, 2.9, 2.19


HW5
Read Section 2.1
1.93, 1.94, 1.97, 1.98, 1.103, 1.105, 1.119, 1.120


HW4
Read Section 1.3
1.80, 1.82, 1.83, 1.84, 1.86


HW3
Section 1.2
1.50, 1.53 - Cavendish only, 1.72, 1.75, 1.76


HW2
Read Section 1.2
1.42, 1.45, 1.62, 1.63, 1.64


HW1
Section 1.1
1.1, 1.3, 1.8, 1.10, 1.14a

Due


Thurs 12/08

 

 

Tues 11/22

 

 

Tues 11/15

 

Tues 10/25





Thurs 10/13





Thurs 10/6





Tues 9/27





Thurs 9/22
Postponed:
Due Tues 9/27







Tues 9/13







Tues 9/06


Homework: Excel Computer Exercises
NOTE: Staple Excel HW to Text HW due on the same due date.

Excel 10 Tests of Significance

Pgs 110 - 115

Turn In: LABELED results, stating Hypothesis and steps, and conclusion, stated in terms of Ho and Ha,

For exercises 6.7 p 110-112, 6.14 p 113-114, and 6.16 pg 114-115.  ONE SHEET TOTAL.

 

Excel 9 Binomial Distribution

Pgs 95 - 97

Turn In: Histogram as in #11 pg 97

 

 

Excel 8 Means and Variances of Random Variables

Pgs 89 – 90, 92 - 93

Turn In: Table as in #6 pg 93

 

Excel 7
Pgs 73 - 75, pg 79, (See pg 76-77 for RAND() function)
Turn In: Table like #6 on pg 75 and
Histogram described in #6 pg 79 on same sheet.
DO NOT TURN IN: print-out of random samples

Excel 6
Pgs 62 - 67, Skip Goal Seek pg 65: Regression
Turn In: Plot with trendline & equation (Weight vs Fidget) in manual
Turn In: Sheet with calculation of predicted values and residuals


Excel 5
Pgs 53 - 58, 60 - 61: Scatterplots and Correlation
Turn In: Scatterplot and correlation for Example 2.3 (SAT vs %) in manual



Excel 4
Pgs 46 - 50: Density Curves and Normal Distributions
Turn In: Results for exercises 1.15, 1.26, 1.30 in example
Using Excel Help, look up the difference between absolute, relative and mixed references
Turn In: A
brief, typed paragraph explaining the difference

Excel 3
On-line Exercise and Data Set (This corresponds with Problem 1.74 from the textbook.)
The instructions for the exercise are shown step-by-step.
Part a computes mean and standard deviation. Part b implements a linear transformation.
Turn In: Two Sheets: Answers to Red Question at bottom of exercise webpage
In Excel Manual: Read pgs 36 - 37 (Descriptive Stats and AVERAGE function), STDEV function on pg 40
Turn In:
For the same data - one sheet with Descriptive Statistics AND AVERAGE and STDEV functions implemented for part a (non-transformed) data.


Excel 2
Pgs 30 - 34: Time Plots
Do Moore/McCabe Exercise 1.25
Turn In: Two Time plots on one sheet
Do Moore/McCabe Exercise 1.27
Turn In: Two Time plots w/ trendline on one sheet


Excel 1
Pgs 15 - 21: Education Example
Turn In: One bar graph and one pie chart on one sheet
Pgs 23 - 26: Call Center Data
Turn In: Histogram