When a student is selected, i.e. "interviewed", (s)he will truthfully answer questions about household income (Income), SAT score (SAT), current grade point average (GPA), number of brothers and sisters (Siblings), the number of hours (s)he studies per week (Study), and whether or not (s)he has been binge drinking during the past two weeks (Binge). (Note: A recent Harvard School of Public Health College Alcohol Study defines binge drinking as five drinks in a row for males, four for females.) While the attributes associated with each student are fictional, several distributions, averages, and correlations are based factual data. For additional information concerning the development of the dataset, contact Dr. Michael T. Marsh.
Follow these steps to analyze the data set using Microsoft Excel.
1. Once the sample information appears, go to File-Save As on the main
menu.
2. A Save As dialog box will appear and "StatU_sample.cgi" will be
the File Name.
3. In the Save in box find a folder you into which you would like to
put the file and click on "Save"
4. Open Excel, go to File-Open on the main menu, and select the folder where
you saved the sample.
5. You probably won't see your file listed unless you change the Files of
type: box to "All Files".
6. Open the file.
7. If you want to see the worksheet gridlines, go the Tools-Options-View and
check the "gridlines" box.
8. When finished, save your worksheet as an Excel file.