View
 

Graphs and Spreadsheets

Page history last edited by Admin 9 months ago

Martin Poulter, DeSTRESS project

These graphs redraw themselves dynamically in response to clicks and button presses. They are web pages with embedded programs, requiring no plug-ins or special software. They may be quite slow in some versions of Internet Explorer.

Licences: Creative Commons Attribution-Sharealike (text content); MIT Licence (Javascript code)

  1. Effect on trendlines of censoring data
    regression line; effect of choosing starting point
  2. Evaluating the Rule of 70
    exponential growth; percentage error
  3. Mean versus median: film ratings
    robustness of median relative to the mean
  4. Pearson versus Spearman correlations
    types of correlation; similarities and differences
  5. Skew, mean and median
    mode, mean, median of continuous (triangular) distribution
  6. Skewness in a discrete distribution (counterpoint to above)
    mode, mean, median of discrete (Poisson) distribution
  7. Measures of income spread
    absolute and percentage change; range, s.d. and variance
  8. The power of compound interest
    logarithmic axis
  9. Logarithmic axes and income
    measures of spread; absolute change versus percentage change
  10. Arithmetic versus geometric mean
    probability; expected return; geometric mean as long-term expected return
  11. The shape of the sampling distribution
    sampling from a skewed distribution; distinguishing the population, sample and sampling distribution
  12. Distribution of sample standard deviations and why we use n-1 to calculate sample sd (incomplete)
    sampling; Bessel's correction
  13. Correlation of a sample (incomplete)

 

University of Sussex

Interactive Excel spreadsheets

 

External links

Richard Field, John Horton, Sue Cobb, Sandra Hill, University of Nottingham

Statistics - An Intuitive Introduction

An interactive tutorial combining graphs, text and interactive features. Twenty-five units cover topics from rounding and central tendency up to regression lines and Chi squared tests

Licence: Attribution-Noncommercial-Share Alike 2.0 UK: England & Wales

Comments (0)

You don't have permission to comment on this page.