## Basic Statistics Excel Template

Folks , here is the fourth posting of the cpkinfo.com repost (with permission from Dean Christolear, of course). From cpkinfo.com, here is the description of the Basic Statistics Excel Template.

This tool is a great start for college or university students studying statistics, or even for advanced high school students with a penchant for the sciences. So don\’t think that this basic statistics excel template isn\’t for you if you\’re not a six sigma blackbelt or otherwise.

This might also be the ideal tool for you if you don\’t have a purchased copy of the world\’s most revered statistics tool, Minitab.

This high-quality spreadsheet allows you to quickly calculate summary statistics for any data set with up to 1500 data points. No more calculators! Everything is much more user friendly for the beginner and includes a run chart and histogram of the data. Once you start using this spread sheet you\’ll never use the Data Analysis Tool Pack in Excel again!

Features Include:

• Mean
• Standard Error about the mean
• Median
• Mode
• Standard Deviation of the Population
• Standard Deviation of the Sample
• Population Variance
• Sample Variance
• Kurtosis
• Skewness
• Range
• Minimum
• Maximum
• Sum
• Count
• Kth Largest Value
• Kth Smallest Value
• Upper and Lower Confidence Level
• Histogram
• Run Chart