What is EDGE?


EDGE is a set of Excel spreadsheets that generate realistic data randomly according to several statistical models, and perform a set of statistical tests. This tool was developed under a Loughborough University Teaching Innovation Award grant. It is free and open source and is made available under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.


How can I use EDGE in my teaching?

  1. Use EDGE to generate realistic datasets for problem sheets on various statistical tests
  2. Use EDGE to reduce plagiarism by generating several individualised by similar datasets for statistical assessments.
  3. Let students experiment with EDGE to gain an understanding of how random variation can give very different datasets from the same population.
  4. Get students to create their own EDGE sheet to improve their understanding of statistical modelling.
  5. Use EDGE as a calculator for basic statistical tests by inputting data from another source.
  6. Use the statistical tables in the EDGE tool to carry out statistical tests by hand.


How can I use EDGE in my research?

  1. When planning research, generate sample data to practice an analysis plan or compare analysis techniques.
  2. Do simulations to estimate statistical power for complicated designs.


How does EDGE work?


Each statistical test corresponds to a page in one of the EDGE tools (basic or advanced). Each page has a text box giving instructions, and there are example videos for four of the pages. For all of the sheets, cells are colour coded to help you as follows:

To generate data:

Enter the requested parameters in the light blue input cells. You will need to generate data in the orange cells and paste them (values only) into the purple cells as directed. The purple cells are the data you have generated. You can save these files as a .csv file to give to students. The light green cells contain the results of statistical tests calculated on this sample data.

To do a statistical test:

Enter your data in the appropriate purple cells. The results of the statistical tests will appear in the light green cells.


What statistical tests does EDGE cover?


Basic EDGE tool:

  1. One and two sample t-test and confidence intervals (generate data, carry out tests, t-table sheet, instructional video)
  2. Simple linear regression and correlation (generate data, fit regression line, calculate R2, instructional video)
  3. Chi-squared test (generate data, carry out tests in both Basic and Advanced tools, chi-squared table sheet)

Advanced EDGE tool: All of the above, plus:

  1. One-way ANOVA (generate data, carry out ANOVA test)
  2. Wilcoxon rank sum test on Likert data (generate Likert data with five levels, carry out Wilcoxon rank sum test for median)
  3. Wilcoxon Mann-Whitney U-test on Likert data (generate two sets of 5-level Likert data, carry out Wilcoxon Mann-Whitney U-test)
  4. Wald 1 and 2 proportion tests (generate data, calculate p-value and Wald+4 confidence interval)
  5. Multiple linear regression with one continuous and one categorical predictor (generate data, fit regression equation, calculate R2)
  6. Simple logistic regression (generate data, fit logit regression line but not max likelihood coefficients)
  7. Multiple logistic regression with two continuous and one categorical variable (generate data, instructional video)
  8. Exponential survival data with random censoring (generate data) 12) Weibull survival data with random censoring (generate data)