Peltier Tech
Chart Add-Ins

Excel Dashboards

Books at Amazon.com

Links to Statistics Resources

Note: this is an incomplete list of statistics resources. My emphasis has been on general information sites, and sites with Excel-related information. I try to include sites that I find useful, and exclude sites that do not impress me. This list was generated by scouring my hard drive for statistics-related content I've downloaded over the years, and backtracking to the source sites. As I find more resources, both buried on my hard drive and while stumbling along on the web, I will add them to this list.

Statistics Resources

General Statistics Resources

• http://www.statsoft.com/textbook/stathome.html
  Electronic Statistics Textbook from StatSoft, makers of STATISTICA.
  Extensive statistics coverage starting with the very basic, and including extensive coverage of advanced topics. Detailed definitions and visual examples.
   
• http://www.itl.nist.gov/div898/handbook/index.htm
  NIST/SEMATECH e-Handbook of Statistical Methods
  Extensive treatment of statistical methods, with detailed definitions and visual examples.
   
• http://mathworld.wolfram.com/topics/ProbabilityandStatistics.html
  MathWorld Probability and Statistics
  Extensive work-in-progress of statistical techniques and descriptions, a subset of a larger mathematics web site from the maker of Mathematica.
   
• http://www.stat.uni-muenchen.de/~knuesel/elv/accuracy.html
  Accuracy of Statistical Packages
  A comparison of several statistical packages, including Excel 97 and XP.
   

Monte Carlo Simulation

• Robert Q. Topper of the Cooper Union Chemical Engineering and Chemistry Department
  
  • http://www.cooper.edu/engineering/chemechem/MMC/tutor.html
    Molecular Monte Carlo Tutorials
  • http://www.cooper.edu/engineering/chemechem/MMC/software.html
    Software and Numerical Tools for the Discriminating Monte Carlo Practitioner
  
   

Statistics Resources for Excel

General Statistics

• http://www.mhhe.com/business/opsci/aczel05/student/excel.mhtml
  Complete Business Statistics, Fifth Edition, McGraw-Hill Higher Education
  Comprehensive set of downloadable Excel templates for statistical analysis.
   
• http://www.mis.coventry.ac.uk/research/discus/discus_home.html
  http://www.mis.coventry.ac.uk/~nhunt/home/
  DISCUSS - Discovering Important Statistical Concepts Using SpreadSheets
  Statistics educational resources by Neville Hunt and Sidney Tyrrell, Coventry University, CV1 5FB, UK.
   
• http://www.mis.coventry.ac.uk/~nhunt/oatbran/
  OATBRAN - Online Analysis Tools By Rodney And Neville
  "The OATBRAN project aims to provide the same functionality as the Excel Data Analysis Toolpak for use online, without macros, with minimal formatting and, hopefully, with fewer bugs."
   
• http://www.deakin.edu.au/~rodneyc/XLSTATS.HTM
  XLStatistics
  "XLStatistics is a set of Microsoft Excel workbooks for statistical analysis of data designed to replace and enhance the tools provided with Excel's Data Analysis Toolbox addin."
   
• http://www.keycollege.com/DM/index.html
  Key College Publishing - Data Matters Resource Center
  Statistics education resources, for Excel and other packages.
  
  • http://www.keycollege.com/DM/toc.html
    Table of Contents.
  • http://www.keycollege.com/DM/activities/excel/06.1.html
    VBA Procedures for Box Plots and Stem-and-Leaf plots.
  
   
• http://www.exceluser.com/help/stat/long001.htm
  ExcelUser - Excel for Statisticians
  Links to articles relating to Excel and statistics.
   
• http://www.qualitydigest.com/oct97/html/excel.html
  Using Excel for Data Analysis
  William W. Dorner shows how Excel can be used to produce serviceable statistical charts, including Shewhart control charts, Pareto charts, and simple box and whisker charts. "Microsoft Excel's capabilities for analyzing data are limited only by your creativity."
   
• http://www.mis.coventry.ac.uk/~nhunt/pottel.pdf
  Hans Pottel's article on Statistical Flaws in Microsoft Excel (PDF)
   
• http://www.anthony-vba.kefra.com/
  Anthony's Excel VBA Tutorial
  Finance, Statistics, Economics, and Mathematics Examples
   

Monte Carlo Simulation

• http://www.vertex42.com/ExcelArticles/mc/index.html
  Monte Carlo Simulation in Excel: A Practical Guide.
  Primer on Monte Carlo techniques, and a review of popular Monte Carlo add-ins for Excel.
   
• http://www.anthony-vba.kefra.com/vba/vba12.htm
  Monte Carlo Simulation on Anthony Sun's VBA Page.
  Tutorial on Monte Carlo simulation, with a simple example worked out in Excel VBA.
   

Statistical Process Control (SPC)

• http://www.spcforexcel.com/articleslist.htm
  SPC Articles and Newsletter, by Business Process Improvement Consulting
  Extensive library of SPC topics, by the producer of a powerful SPC add-in for Excel.
   

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile