Skip to main content

Simulations on spreadsheets for complex concepts: teaching statistical power as an example

Buy Article:

$60.90 plus tax (Refund Policy)


Simulations have been used as a teaching tool, most commonly through bespoke programs or using specialist software. The use of spreadsheets as an alternative means of teaching complex mathematical concepts through a simulation is described, using the topic of statistical power of tests as an example. Power is frequently not reported in research articles and it is maintained that this is because few researchers understand the concept and its relationship to research design decisions. Through the simulation it is possible for the learner to explore the design factors that influence power, plus it provides a simple way of calculating power as a planning tool. Also the spreadsheet-based model allows learners to manipulate sample size, effect size, standard deviation, alpha and number of tails, with the results shown numerically that can be used as a decision support tool. This can be used as a basis for group discussions to enhance higher cognitive skills, integrating the medium more fully into the learning process.

Document Type: Research Article


Publication date: 1999-07-01

More about this publication?
  • Access Key
  • Free ContentFree content
  • Partial Free ContentPartial Free content
  • New ContentNew content
  • Open Access ContentOpen access content
  • Partial Open Access ContentPartial Open access content
  • Subscribed ContentSubscribed content
  • Partial Subscribed ContentPartial Subscribed content
  • Free Trial ContentFree trial content
Cookie Policy
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more