Wednesday, July 22, 2015

Statistics and Excel

What are the chances

"Excel is the widely used statistical package, which serves as a tool to understand statistical concepts and computation to check your hand-worked calculation in solving your homework problems. The site provides an introduction to understand the basics of and working with the Excel. Redoing the illustrated numerical examples in this site will help improving your familiarity and as a result increase the effectiveness and efficiency of your process in statistics."

Dr. Hossein Arsham

The site is very clearly written. While some of the concepts are advanced, Dr. Arsham explains them in simple terms. It is a good introduction to the Analysis ToolPak.

Here are some of the subjects covered:

  • Descriptive Statistics
  • Normal Distribution
  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations
  • Linear Correlation and Regression Analysis
  • Moving Average and Exponential Smoothing
The University of Baltimore: Statistical Data Analysis

See all Topics

No comments: