StatLit Tools
10/25/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:  Output     Slides (12)   Data Input
  • XL1B: Use count data to create pie & bar charts:    Count & %: Output   Input      Count (2C):   Output   Slides (10)  Input
  • XL1B2: Use ordinal pivot-table data to create pie & bar count & percent charts:  Output     Slides   Input
  • XL1C: Create time-based line graphs. Linear and Log-Ratio display.    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 Output   Slides   Data.    Excel 2003 Demo slides: 1up  6up
  • XL1E: Create Ranks and Percentiles.   Output    Input
  • XL1F:  Create Histogram using Excel HISTOGRAM command:  Excel 2013  Output   Slides   Data    Data (pdf) X
  • XL1G: Create Histogram using COUNTIF and FREQUENCY functions:  Excel 2013:  Output   Slides   Data  Data (pdf)
  • XL1H: Creating Funnel Charts using Excel 2013: In-cell, stacked bar and stacked area.   Demo   Data
  • XL1J: Create centered stacked 100% bar-charts for ordinal data using Excel 2013.    Even and Odd #: Output
           Even #:  Output  Slides  Data                 Odd #:  Output   Slides  Data
  • XL1K:Using CORREL function  Output,  Slides  Data

8.  MODEL DATA USING EXCEL LINEAR REGRESSION     Pulse dataset

  • XL2A: Chart Trendline: Linear  1Y1X (3 graphs)   Demo  Slides (23) 
  • XL2B: Chart Trendline: Non-Linear   1Y1X    (6 graphs) Demo   Slides (12)  
  • XL2C: Chart Trendline: Linear  Two different Y scales on same graph.  2Y1X (4 graphs)  Demo   Slides (36)
  • XL2D: Chart Trendline: Linear  Three-factor 1Y/2Groups/1X.  New (pivot table, 2 graphs):   Demo   Slides (12)   [[Do XL2C first]
  • XL2G: Association vs. Causation.  Explains vs. Causes using Excel.  Output
     
  • XL3A: Toolpak: Regression using Data Analysis 1Y2BC  Output  slides  Input
  • XL3B: Toolpak: Regression MV2 Pulse data:  Output   Input
  • XL3C: Toolpak: Regression MV03 Assess data.  Explain multivariate regression as standardizing.  Demo    Data
  • XL3D: Toolpak: Regression MV4   Example of Simpson's Paradox.  Output   Slides   Data
     
  • XL3S: Segmented OLS Linear Regression:    Slides        Math vs. Statistics NNN (2016 draft)
  • XL3X: Toolpak Regression: Key Bivariate OLS Relationships    Output    S1: SE of regression; 1-R^2.  S2: CI and PI.

9.  MODEL DATA USING EXCEL LOGISTIC REGRESSION:

  • 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  OLS1E Outcome | Predictor + Confounder.  Results in a Simpson's Reversal  Output   Data
     
  • Logistic Regression:  MLE using Excel Solver
    XL4K: 1Y1X-Ht  2 steps:  Demo Slides Input.    3 steps: Demo Slides Input.    XL4L: (1Y2X).   3 steps:  Demo   Slides   Input
     Analysis using SPSS  Howell   More 2      Minitab Binary Logistic Regression  Forecast Carrying Capacity
  • XL4M Logistic Regression using MLE: Simpson's Paradox
  • XL4N Discriminant Analysis using MLE Logistic Regression:  Demo    Pulse 1Y2X.  Using OLS1D: Slides
     
  • XL4S  Logistic Regression using OLS2: Grouped data.  Chart Trendline 1Y1X    Data Analysis 1Y2X     Log-odds-Grouped Data OLS
  • XL4T Logistic Regression using OLS3 shortcut.   Output    Slides   Input    [Interesting but can't handle multiple X]
  • XL4U Logistic Regression: Compare MLE with OLS1.  Slides  Demo    Data (xlsx)  [Handles multiple X] 
  • XL4V 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)

10.  DISCRETE DISTRIBUTIONS USING EXCEL:

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

11.  CONTINUOUS DISTRIBUTIONS USING EXCEL:  

  • Lognormal Distribution of HH by Income given Mean and Median of distribution:  
    XL5A using Excel 2013:   Demo Output     Slides    Demo Input (xlsx).
     
  • Distribution of Total Income assuming HH by income are log-normal (Excel 2013)  Irfan (2014)   Schield-Income-Inequality
    Explore Income #1:  Spreadsheet#1      NNN slides    Updated slides
    Explore Income #2:  Spreadsheet#2      Results         Spreadsheet#3
    XL5B  LogNormal Income2  Demo4Output   Demo6  Slides    Input.
    XL5B2 LogNormal Income2B:  Demo2   Demo4  Demo5    Input.   Schield (2014)
  • XL5C  Log-Normal characteristics as a function of Mean-Median ratio: Spreadsheet   PDF
     
  • XL5D  Log-Normal Distribution of Subjects by Value: Percentages only. Spreadsheet
  • XL5D1  Log-Normal Distribution of Households by Assets (Excel 2013)   Spreadsheet.  Slides
  • XL5D2  Log-Normal Distribution of  (Excel 2013)   Spreadsheet.  Slides
  • XL5D9  Log-Normal Distribution of VIX (Excel 2013)   Spreadsheet.  Slides
     
  • XL5E Generating Mean or Median of Log-Normal distribution given Standard Deviation.  PDF
  • XL5F  Generate Distribution of Losses given Lognormal Distributions of Frequency and Severity  Demo  Slides  Data   Demo-SS
  • XL5G  Sum of K identical Log-Normals (Excel 2013):  Output   Input
  • XL5H Distribution of Product of Two Random Variables: Normal and Log-Normal (Excel Simulation).  Output
     
  • XL5S   Normal Distribution and CDF (Excel 2013)   Spreadsheet.  Slides
  • XL5T   Folded-Normal Distribution and CDF
  • XL5U   Exponential Distribution and CDF
  • XL5V  Chi-squared Distribution and CDF
     

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.
  • XL8J Reference: Compare confidence functions in Excel 2010 vs. Excel 2003.   PDF   xlsx.
  • XL8K Reference: Compare Z and T Statistics using Excel 2003.    PDF

16. 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.

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



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 10/25/17