Creating a Database using Microsoft Excel

Create a new Microsoft Excel database in which you will be able to enter the following variables:

Name each variable in the datafile. All data to be manipulated (everything except the participant ID number) must be entered as numeric values.

Create data for forty hypothetical students who are undergraduates in college, making sure you have five males and five females in each year (freshman, sophomore, junior, and senior):

Enter the complete dataset into the Microsoft Excel worksheet. Save the workbook on your hard drive.