StatLit Tools
03/11/17

Authors Popular StatLit News Authors-Academic Statistical Literacy Numeracy Statistical Reasoning

Standardizing StatLit Papers StatLit Videos StatLit TextBook StatLit Tools US-ISLP StatLitSite David & Phyllis Whitin

This page contains various tools that may be helpful.  All these tools are web-accessible and are freely available for use.    Tom Burnham (pictured above) created the VB tools (Reading/Writing drill); Milo Schield created the Excel demonstrations and documentation.
  1. Chance Demonstrations.  Coincidence (Runs, Clusters, Birthday problem),  Four Envelope problem,  Law of Very Large Numbers

  2. Surveys: These help people evaluate their strengths and opportunities for improvement in various aspects of statistical literacy 

  3. Describe & Compare Percentages and Rates using Ordinary English.

  4. Standardizing:  Using graphs, these web programs show users the impact of controlling for a related factor. 

  5. Part-whole Grammar Reading and Writing Drills: This web programs help users develop their skills in using ordinary English to describe and compare rates and percentages as presented in pie charts, in statements, in tables and in graphs.   The author (Tom Burnham) of these cutting-edge programs is shown above.

  6. Odysseys2sense: A lively game of civil discourse.

  7. Using Excel pivot tables to create summary statistics

  8. Model Data Using Excel

  9. Create Histograms using Excel

  10. Create Discrete Distributions using Excel

  11. Create Log-Normal Distributions using Excel

  12. Create Distributions Empirically using Excel

  13. Create Sampling Distributions using Excel

  14. Create and Compare Confidence Intervals using Excel.

  15. Simple Models for Statistical Significance

  16. Create Hypothesis Tests using Excel


1. CHANCE-COINCIDENCE DEMONSTRATIONS:

2. SURVEYS:
This web site contains several surveys along with results from various groups.
  • Five Table survey.  This short survey (~7 minutes) asks respondent which statements accurately describe the circled percentage in five different tables. This survey is available in a web version with immediate grading and feedback on errors, and in a paper version.
  • 2008 Statistical Literacy Skills Survey (20 Questions).  This survey was based on the longer 2002 W. M. Keck Statistical Literacy Survey.   For details on the construction of this instrument, see Schield (2008) titled "Statistical Literacy Skills Survey."
  • 2002 W. M. Keck Statistical Literacy Survey.  This very long survey (~50 minutes) is available in Perseus-powered web version that acquires the data but gives no interactive feedback, and in a paper version. The results and analysis of this survey are also available.

3. DESCRIBE AND COMPARE PERCENTAGES, RATES AND AVERAGES USING ORDINARY ENGLISH:
    
Isaacson data set (240 rows, 8 columns).


4. STANDARDIZING:
Standardizing is a new graphical technique for taking into account the influence of a related factor. 
This site contains several articles on confounding, standardization and Simpson's Paradox.

Here are two web-based interactive Excel programs that demonstrate standardization.

For a broader mathematical background on Simpson's paradox, see


5. RATIO GRAMMAR READING-WRITING DRILLS:   Tom Burnham Accomplishments (1995-2014)
Go to the Grammar Read-Write Index page for details on browser choice, compatibility mode, and for various demos (video, PowerPoint w audio and PowerPoint slides).

6. ODYSSEYS2SENSE: a game of lively discourse.    Website:

7. USING EXCEL TO PRESENT AND CREATE SUMMARY STATISTICS

Presentation:

  • XL0Z: Moodle Split Screen: Excel vs. URL.  Slides.
  • XL1A: Use nominal frequency data to create pie & bar count & percent charts:  Demo output     Slides (12)   Data Input
  • XL1B: Use two-way count data to create pie & bar charts:    Count & %: Output   Input      Count (2C):   Output   Slides (10)  Input
  • Use ordinal pivot-table data to create pie & bar count & percent charts:  Demo output     Slides   Data Input
  • Create centered stacked 100% bar-charts for ordinal data using Excel 2013.    Both Even and Odd # Choices: Output
           Even number of choices:  Output  Slides  Data                 Odd number of choices:  Output   Slides  Data
  • XL1C: Create time-based line graphs. Linear and Log-Ratio display.    Demo Output    Slides (12)   Data

Creation of statistical summary data:

  • XL1D: Create Pivot tables of counts, averages, statistics and percentages (100% column, 100% row and half table of percentages) 
        Excel 2013  Output    Slides (24)    Data.         Excel 2008 Demo Output   Slides   Data.    Excel 2003 Demo slides: 1up  6up
  • XL1E: Create Ranks and Percentiles.   Demo Output    Data Input

8.  MODEL DATA USING EXCEL     Pulse dataset

  • XL2A: Chart Trendline: Linear  1Y1X (3 graphs)  Slides (23) 
  • XL2B: Chart Trendline: Non-Linear   1Y1X    (7 graphs)  Slides (12)  
  • XL2C: Chart Trendline: Linear  Two different Y scales on same graph.  2Y1X (4 graphs)  Slides  (36)
  • XL2D: Chart Trendline: Linear  Three-factor 1Y/2Groups/1X.  New (pivot table, 2 graphs):  Slides (12)   [[Do XL2C first]
     
  • XL3A: Toolpak: Linear Regression using Data Analysis 1Y2BC  Output  slides  Input
  • XL3B: Toolpak: Linear Regression using Data Analysis 1Y2CC:  [Bad ** Output  slides  Input ** Bad]
  • XL3E: Segmented OLS Linear Regression:    Slides        Math vs. Statistics NNN (2016 draft)
     
  • Logistic Regression using OLS1: Nudged probabilities.  Handles multiple X.  Accuracy better than linear OLS; less than logit MLE.
    XL4A  OLS1A Male|Ht  Demo Slides Data.        XL4B OLS1B  Male|Ht+Smoker  Demo Slides Data.
    XL4C  OLS1C Male|Wt  Demo Slides Data .       XL4D OLS1D  Male|Ht+Wt         Demo Slides Data
  • XL4E: Discriminant Analysis using MLE Logistic Regression:  Demo    Pulse 1Y2X.  Using OLS1D: Slides
  • Logistic Regression using OLS2: Grouped data.  Chart Trendline 1Y1X    Data Analysis 1Y2X     Log-odds-Grouped Data OLS
  • Logistic Regression using OLS3 shortcut.   Output    Slides   Input    [Interesting but can't handle multiple X]
     
  • Logistic Regression:  MLE using Solver
    XL4F: 1Y1X-Ht  2 steps:  Demo Slides Input.    3 steps: Demo Slides Input.    XL4G: (1Y2X).   3 steps:  Demo   Slides   Input
     Analysis using SPSS  Howell  More1 More 2      Minitab Binary Logistic Regression
     
  • Logistic Regression: Compare MLE with OLS1.  Slides  Demo    Data (xlsx)  [Handles multiple X] 
  • Logistic Regression: Compare MLE with OLS3.  Slides    Data (xlsx)  [Interesting but can't handle multiple X] 
     
  • R^2 and Partial Correlation as a function of Added Variable Correlations.  (1/22/2017)

9.  CREATE HISTOGRAMS USING EXCEL:

  • Summarize quantitative data using functions (COUNTIF or FREQUENCY) or the Data Analysis command (HISTOGRAM).
           Create column chart from summary data in bins and transform into a Histogram.    

10.  CREATE DISCRETE DISTRIBUTIONS USING EXCEL:

  • XL4A: Create Binomial, Hypergeometric and Poisson Distributions using Excel.   Discrete Probabilities: Overview   
         Excel 2013:    Demo Output (pdf)   Slides    Data  XLSX    
  • Explore Binomial, Hypergeometric and Poisson Distribution PDF and CDF for statistical significance.
         #Excel 2013:   Slides       Demo Output (pdf)    PDF & CDF Calculator XLSX
  • XL4Z: Calculator for three discrete distributions:   Excel file

11.  LOG-NORMAL DISTRIBUTIONS USING EXCEL:  


12. CREATE DISTRIBUTIONS EMPIRICALLY FROM RANDOM PROCESSES USING EXCEL    NNN 2014: Slides (pdf)  PPT

  • XL6G: Matching groups from random assignment


13. SAMPLE STATISTICS FOR PERFECTLY REPRESENTATIVE SAMPLES:


14. CREATE SAMPLING DISTRIBUTIONS USING EXCEL:


15. CREATE AND COMPARE CONFIDENCE INTERVALS USING EXCEL:

  • XL8A: Create Confidence Intervals using Excel 2013:  Results, Slides, Data.     Excel 2010: DemoSlides, Data.
  • XL8B: Compare overlap of Two Confidence Intervals using Excel 2010.  PDF    xlsx
  • XL8C: Display Paired Confidence Intervals using Excel with summary statistics. Template (xls).     Demo: 6up, 1up.
  • XL0J Reference: Compare confidence functions in Excel 2010 vs. Excel 2003.   PDF   xlsx.
  • XL0K Reference: Compare Z and T Statistics using Excel 2003.    PDF

16. APPROXIMATE CUTOFFS FOR STATISTICAL SIGNIFICANCE: Sufficient but not necessary.  


17. CREATE HYPOTHESIS TESTS USING EXCEL:

Isaacson data set (240 rows, 8 columns).

  • XL9A: Hypothesis test for a single Population: Z-Test function.   Excel 2008 demo:   Slides 6up and 1up.
     
  • XL9B: Hypothesis test (two populations):  T-Test function.  Excel 2008  Demo Slides  6up, 1up.
  • XL9C: Hypothesis test (two populations):  T-Test command.  Excel 2013 Slides 6up, 1up.  Excel 2003 6up, 1up.

18. USING MICROSOFT WORD:

  • 20 Minute Quick Start using Word 2013 Styles. Slides (pdf).   Schield, May 2014.

MISCELLANEOUS:
To print the SQL statements in a MS Access query, checkout Print Access Query SQL.

Alan Shepard's Sales Rank Express: www.salesrankexpress.com/index.html

Home | Standardizing | StatLit Papers | StatLit Videos | StatLit TextBook | StatLit Tools | US-ISLP | StatLitSite | David & Phyllis Whitin

This site was last updated 03/11/17