How many tanks?
- Author:
- timteachesmath
What you want to do:
1) Put samples in brackets in column A. e.g., {37, 102, 138, 251, 17, 188, 196}
2) In column B, have the spreadsheet calculate your test statistic. Unlike Excel, you don't need an equals sign to start formulas. Some commands you might want to use are max[], min[], mean[], median[], mode[], q1[], q3[]. Inside the brackets, you want to put the cell you're referring to (e.g., 3*mean[A3]-max[A3}+5).
3) You can adjust the width of categories for the histogram by changing the value in cell B1.
4) When you're finished, inside the applet window go to File ... Export ... Graphics View as Picture. Change the resolution to 72 dpi, save it with the filename starting with 'war-', and upload your file to Wikispaces by clicking on 'Files and folders' first.