Introduction to Statistics
Excel Guides
All of these documents are in PDF. You need the free Adobe Acrobat Reader to view these.
- The first Excel Guide. This one covers entering data and creating histograms, stemplots, and timeplots.
- This may be helpful in creating histograms. It is a guide to the first Daily Homework Exercise.
- This may also be helpful. It is a guide to Problem 1.18 from the text. The guide discusses percents and the SUM function in Excel as well as copying and pasting formulae.
- Common Excel functions. Commands for finding mean, standard deviation, median, quartiles, square roots, etc.
- The second Excel Guide. This one covers correlation and regression statistics.