On Monday 6 February 2012, the Further Mathematics Support Programme (FMSP) and the RSSCSE with Plymouth University ran an all day workshop for Teachers of A Level Statistics.
Running from 10:00 to 3:30 the day was split into 4 workshops, the full programme can be downloaded as a pdf flyer here.
As part of the day Session 3 ran by Neil Sheldon and entitled 'Press [F9] Statistical Simulations in Excel' required a number of Excel spreadsheets. These can be downloaded below, a copy of the Powerpoint used by Neil can be downloaded here.
Downloads
Session 3 "Press [F9] Statistical Simulations in Excel" required the participants to use a number of Excel documents during the workshop. These can be downloaded here:
- S1 Binomial Hypothesis Test.xls
- S1 Divisor n Versus n-1.xls
- S1 Dot Plot Mean and sd.xls
- S1 Dot Plots.xls
- S1 Relative Frequency and Probability.xls
- S2 CLT Simulation.xls
- S2 Correlation.xls
- S2 Effect of Sample Size.xls
- S2 Normal Approx to Binomial.xls
- S2 Normal Approx to Poisson.xls
- S2 Poisson Approx to Binomial.xls
- S2 Regression.xls
- S3 Confidence Intervals (Estimate par).xls
- S3 Confidence Intervals (Known par).xls
- S3 Die chi-squared.xls
- S3 t and Normal Critical Ratios.xls
- S3 t and Normal Distributions.xls
- Stats Birthdays.xls
- Stats Dice Graph.xls
- Stats Misleading News Story.xlsx
- Stats Probabilty Calculator.xls
- Stats Random Dots.xls
