AS & A2 Stats Simulations

Here you will find Neil Sheldon's Statistical Simulation resource entitled 'Press [F9] Statistical Simulations in Excel'. You can download all the Excel spreadsheets for this resource below, a copy of the Powerpoint used by Neil for this lesson 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