
MS Excel Step–by–Step Directions 


Section 
TI–83 Step–by–Step Directions (Each link opens in a new window) 
1.1  How to enter data into lists 
1.1  How to make a histogram 
1.1  How to make a stemplot 
1.1  How to make a timeplot 
1.2  How to find 5–number summary, variance
and standard deviation 
1.2  How to make a boxplot 
1.3  How to plot histogram with a normal curve 
1.3  How to find area under the normal curve 
1.3  How to find a zscore given the area 
1.3  How to find and graph the area under a normal curve 
2.1  How to make a scatterplot 
2.2  How to calculate the correlation coefficient, r 
2.3  How to find the least squares regression line 
2.3  How to find the 2–variable statistics 
2.3  How to find the residuals 
3.1  How to choose an SRS (simple random sample) 
5.2  How to find number of combinations 
5.2  How to find binomial probability 
6.1  How to find one sample z confidence interval (using stats) 
6.1  How to find one sample z confidence interval (using data) 
6.1  How to find margin of error 
6.1  How to find minimum sample size [Z–statistic] 
6.2  How to perform one sample z hypothesis test (using stats) 
6.2  How to perform one sample z hypothesis test (using data) 
7.1  How to find one sample t confidence interval (using stats) 
7.1  How to find one sample t confidence interval (using data) 
7.1  How to perform one sample t test (using stats) 
7.1  How to perform one sample t test (using data) 
7.1  How to perform matched pairs t test (using data) 
7.2  How to perform two sample t test (using stats) 
7.2  How to perform two sample t test (using data) 
7.2  How to perform pooled two sample t test 
7.2  How to find two sample t confidence interval (using stats) 
7.2  How to find two sample t confidence interval (using data) 
7.2  How to find pooled two sample t confidence interval 
8.1  How to find one sample z confidence interval for sample proportion 
8.1  How to perform one sample z test for sample proportion 
8.2  How to find two sample z confidence interval for sample proportion 
8.2  How to perform two sample z test for sample proportion 
x.x  How to enter data into matrices 
9.2  How to perform chi–squared test 
x.x  How to perform two sample F test (using stats) 
x.x  How to perform two sample F test (using data) 
x.x  How to perform one–way ANOVA 