CS 3724 Lecture Notes for Nov 6
I. Data collection
Scientific method
Design
II. Data analysis
Statistics
Analysis using Excel
- Enter data
- Go to Tools... Data Analysis...
(may need to choose Analysis Toolpak from Addins first)
- Select appropriate analysis
- t-test: two-sample assuming equal variances
- other t-tests
- ANOVA: single factor
- other ANOVAs
The Help facility within Excel is reasonably good.
In addition, there are numerous Web sites that discuss
performing statistical analyses in Excel.
See
http://www.mastep.sjsu.edu/learn/excelstat.htm for one example.
IV. Writing up your results