Statistical Charting In Excel

Home | MS Office Training| Custom Applications| Sample Code | Join I Get It! Development

Statistical Charting In Excel Make the most of Excel's charting and statistical abilities		Package Contents:
The purpose of this package, the handout material from the Far West Research and I Get It! Development seminar on Charting and Statistical Analysis in Excel, is to describe the charting capabilities of Microsoft Excel, particularly as they relate to statistical data analysis. Readers are not required to be familiar with inferential statistics, but it is recommended to have a working knowledge of descriptive statistics, such as the mean, the median, the standard deviation, the range, etc. Our emphasis in this package is to focus on exploring the data with the help of statistical graphics. By doing so, our goal will be to answer the following question: what preliminary conclusion(s) can we reach by visually inspecting the data and by using summary (descriptive) statistics?		Statistical Graphics White Paper Spreadsheet samples with viewable VBA code to create: -Horizontal dot plots -Vertical dot plots -Stem-and-Leaf charts -Quartile Plots (variation on Tukey's box plot shown below) Cost: $ 35.00 US
In addition to the white paper explaining the use of the charting in statistical analysis, the package includes several Excel workbooks containing viewable (an modifiable) VBA source code for the creation of the custom charts. Also available (with your password) are videos showing step by step how to perform the necessary steps in Excel. Have a look at the table of contents of the white paper, view the custom graphs, or go directly to the download page.

last updated March, 2008