SessionDateStatistics with ProbabilityWeBWorKText #1HomeworkText #2
1Introduction to ExcelP. 1 - 5, 9 - 11 and 13 - 23
2Graphical Descriptive Techniques2.1 - 2.4P. 25: 1, 2, 3; P. 39: 1, 3; P. 47: 1, 3SORT, FREQUENCY
P. 28 - 29
3Measures of Central Location and Variability3.2 - 3.5P. 79: 1, 9; P. 86: 1, 2, 11; P. 98: 1, 5;
P. 105: 1, 2, 6
AVERAGE( : ), VARP( : ), STDEVP( : )
P. 36 - 45
4Covariance and Coefficient of Correlation2.5, 3.7P. 54: 1, 5; P.128: 1, 3COV(X,Y), CORREL(X,Y)
P. 189 - 193
5Least Squares Method and Regression12.1 - 12.3P. 542: 1, 5; P. 548: 1, 2, 3SLOPE, INTERCEPT
P. 205 - 210
6Assigning Probabilities to Events; Probability Rules4.1 - 4.3P. 150: 1, 3, 4, 7, 10, 11, 12; P. 156: 1, 2,
7, 9, 10
7Experiments Having Equally Likely Outcomes4.4P. 164: 1, 2, 3, 6, 9, 10, 12, 14
8Conditional Probability and Independence4.5P. 177: 1, 2, 3, 4, 7, 11, 15, 18, 28, 29, 33,
35, 38
9Relative Frequency Distribution and z-scoresFREQUENCY( bin:data )
P. 45 - 48, P. 59 - 76
10First Examination
11Random Variables, Probability Distributions5.2P. 215: 1, 3, 4, 9, 10, 15, 17, 18
12Expected Value and Variance5.3
5.4
P. 225: 1, 3, 4, 5, 9, 11, 19, 23, 27, 30
P. 236: 2, 3, 5, 10, 11, 17, 18, 19
13Binomial Distribution5.5P. 244: 2, 3, 5, 10, 11, 21, 23BINOMDIST(s,n,p,false)
P. 104 - 108
14Poisson Distribution5.7P. 253: 1, 3, 5POISSON(x,mean,false)
P. 111 - 115
15Continuous Random Variables6.2P. 264: 1, 2, 3, 6, 7
16Normal Random Variables6.3, 6.4P. 269: 1, 2, 3, 5, 7, 19; P. 276: 3, 4, 5NORMSDIST(z), NORMSINV(p)
P. 115 - 122
17Finding Normal Probabilities6.5, 6.7P. 281: 1, 3, 5, 9, 13; P. 289: 1, 3, 9, 13
18Sample Mean7.3P. 303: 1, 3, 5
19Distribution of the Sample Mean7.4.1P. 311: 1, 3, 5, 7, 11, 13
20Distribution of the Sample Variance of a Normal Population7.6P. 325: 1
21Midterm Examination
22Estimating Population Means8.2P. 334: 1, 3, 5, 7, 9
23Hypothesis Testing with Known Standard Deviation9.2 - 9.3.1P. 392: 1, 3
P. 400: 1, 3, 5, 7, 9, 11
P. 408: 1, 3, 5
P. 131 - 153
24Inference about a Population Mean with Unknown Standard Deviation9.4P. 417: 1, 3, 5, 13, 17TDIST(x,df,tails), TINV(p,df),
P. 140 - 153
25Class Project Presentation
26Class Project Presentation
27Chi-Squared Goodness of Fit Test13.2P. 615: 1, 3, 7, 11CHIDIST(x,df), CHIINV(p,df)
P. 249 - 255
28Chi-Squared Test for Independence - Contingency Table13.3P. 626: 1, 3, 5, 9, 11
29Review
30Final Examination