Excel Instructions: Checking Conditions
If you feel that you need to look at the two samples using histograms, you can launch Excel with the data in the worksheet by clicking here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.
Reminder: To construct histograms of the data:
- Select the Data tab and click the Data Analysis button. Then choose Histogram in the resulting pop-up window and click OK.
- In the next window, enter the range of data that you want to graph next to Input Range. If there is anything next to Bin Range, delete it (we will let Excel choose the bins for us). Make sure that Chart Output is selected and click OK.
- Excel will create a new worksheet with a histogram as well as a table with the underlying bins and frequency distribution. The histogram is usually pretty small; you can click on it and then drag one of the handles on the outside to enlarge it.
- Histograms shouldn't have spaces between the bars, so right-click on one of the bars and choose Format Data Series. Then set the Gap width to 0% (no gap).
- Before closing the Format Data Series window, click on Fill & Line tab (paint bucket icon) on the left, choose Solid line, and set the color to black.