Open Microsoft Excel to a blank workbook. Double-click on the tab at the bottom of the worksheet and relabel it "RES6003," "Student Data," or some other relevant title. Step 2. Label Label Column A of the Excel spreadsheet "Student Group" by entering that text in Cell A1. Because these groups are categories, they are considered nominal data. Label Column B "Remedial Hours" in Cell B1. This column will contain interval data, which is the number of hours of remediation the student received between 0 and 20. Label Column C "Project Grade" in Cell C1. This column will contain ratio data representing the student's grade on a major project in the class. The data are ratio because they are expressed in terms of percentage points, which is the number of points scored out of 100. Label Column D "Final Grade" in Cell D1. This column will contain the final grade the student earned in the class. This is also classified as ratio data because it is a percentage score. Step 3. Populate Values Column A can have one of two values: A or B. Next, for purposes of this example, populate the first 25 rows with "A" and the next 25 rows "B." Note that the column headings are on Row 1, so you will start on Row 2. Therefore, the B group will start on Row 27