Data Analysis
Taking quantitative data and analyzing it is an important part of a science fair project and scientific research in general. Use these guide to help you make sense of your data and organize it in a clear, readable format so that you can reach a conclusion from your experiment.
If you don't have access to Microsoft Excel but would like to do your calculations with computer software, you can download Open Office.
- Introduction to Excel
- Haven't worked with Microsoft Excel before? It's not difficult. Here's a really easy, step-by-step guide to entering data and doing math using Microsoft Excel.
- Graphing in Excel
- Want to make accurate and professional-looking graphs quickly and easily? Follow this short tutorial on how to make graphs in Microsoft Excel!
- Line Fitting
- Learn how to find the best line to fit your data using linear regression in Microsoft Excel or by hand! A great technique for judging the quality of your data.
- Statistics Formulas in Excel
- Some slightly more complicated Excel formulas relating to statistics such as average (mean), median, and mode - very handy for data analysis!
- T-testing
- Learn how to do statistical analysis in Microsoft Excel, using T-tests, a statistical tool for comparing means.