General Statistics
Inference - 2 Populations Statistics
(mean and proportion)
Excel Programs (Interactive web Solutions)



Excel Programs and Worksheet:

(requires Microsoft® Internet Explorer 4.01 or later and the Microsoft Office Web Components)

The following Functions are created for this class - you may click on functions to launch in Internet Explorer.
Update table with new values or entries and appropriate statistics will be automatically calculated.
 
(only change values highlighted in blue against a white background) e.g.
19.46
Hypothesis Testing Worksheet
 
Comparing 2 Sample means
(n is small - t-test)
(P-values and t-test)
or
Open in Excel (Download)
or
Worksheet Format
Comparing 2 Sample means
(n is LARGE:  z-statistics)
(P-values and z-score)
or
Open in Excel (Download)
or
Comparing 2 Sample proportions
(n is LARGE )
(P-values and z-score)
or
Open in Excel (Download)
or
Comparing Sample statistics with Population's
(mean and proportion)

 
Normal Probability Reference Table
or
Open in Excel (Download)
or
z-score / Normal Probability Reference Table
Student t Reference Table
or
Open in Excel (Download)
or
Worksheet Format
Sample Size Estimator
or
Open in Excel (Download)
or
Examples via Formula
Confidence Interval Calculator
or
Open in Excel (Download)
or
Examples via Formula