General Statistics
Inference - Population 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 Sample mean with Population's
(n is small - t-test)
(P-values and t-test)
or
Open in Excel (Download)
or
Worksheet Format
Comparing Sample mean with Population's
(n is LARGE:  z-statistics)
(P-values and z-score)
or
Open in Excel (Download)
or
Worksheet Format
Comparing Sample proportion with Population's
(n is LARGE)
(P-values and z-score)
or
Open in Excel (Download)
or
Worksheet Format
Comparing Two Sample Means and Proportions

 
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