Transcription of Biology statistics made simple using Excel
{{id}} {{{paragraph}}}
School Science Review, December 2001, 83(303)23 MillarBiology statistics made simple using ExcelBiology statistics madesimple using ExcelNeil MillarSpreadsheet programs such as Microsoft Excel can transform the use ofstatistics in A-level scienceABSTRACTM odern spreadsheet software, such as MicrosoftExcel, can transform the use of statistics inbiology. Instead of being difficult to do and tointerpret, statistical tests become simple to doand much easier to interpret. This article des-cribes when and how to carry out many of themost common tests (including mean, standarddeviation, confidence limits, correlation, regress-ion, t-test, 2-test and ANOVA) using is an area that most A-level Biology students(and their teachers!) find difficult. The formulae areoften complicated, the calculations tedious, degreesof freedom mysterious, and probability tablesconfusing.
Biology statistics made simple using Excel Millar 24 School Science Review, December 2001, 83(303) Figure 1 Flow chart used to choose an appropriate statistical test.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}