Skip to main content

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

Buy Article:

$55.00 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.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Article Media
No Metrics

Document Type: Research Article

Publication date: 1999-07-01

More about this publication?
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free 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