lab3_exercises_new

Lab #3 Exercises (Part I) Students in a previous PM511a class filled out 2 questionnaires. Results are stored in four separate ASCII files located in the Lab Datasets folder in Canvas. The name of the files and their corresponding contents are summarized in Table 1. The data files are summarized in Tables 2 and 3. Your resulting data should resemble Table 4. Please provide all relevant code and output to receive full credit for the lab. Your Table 1: Name of the file and contents. Name of the file Contents lab1q1.dat Questionnaire #1 from Early Lab lab2q1.dat Questionnaire #1 from Late Lab lab1q2.dat Questionnaire #2 from Early Lab lab2q2.dat Questionnaire #2 from Late Lab Table 2: Data Description for lab1q1.dat and lab2q1.dat Variable Beginning column Description/Value ID 1 Four-digit ID Sex 6 M or F HtFeet 8 Height in feet (i.e. for 5’7” “5” is the value) HtInches 9 Height in inches (i.e. for 5’7” “7” is the value) Race 12 Race/Ethnicity 1 = Asian; 2 = Hispanic; 3 = White; 4 = Other BirthM 14 Birth Month BirthD 16 Birth Day LabNum 1 = Early Lab (11:00-1:00); 2 = Late Lab (3:00-5:00) Table 3: Data Description for lab1q2.dat and lab2q2.dat Variable Beginning column Description/Value ID 1 Four-digit ID Transportation 6 How to you come to school? 1 = Car; 2 = Walk; 3 = Public Transportation 4 = Bike GasPrice 8 How much per gallon of gas did you pay when you last filled up your car? SUV 13 Type of your car. 1 = SUV; 0 = Non-SUV CarMake 15 What make is your car? TankVol 26 How many gallons of gas can your gas tank hold? TankLast 29 How many miles can you drive on a whole tank of gas? City 33 Which city do you live? OneWay 50 How many miles from school to home (1 way?) SchTimes 56 How many times do you drive to school each week? LabNum 1 = Early Lab (11:00-1:00); 2 = Late Lab (3:00-5:00)

Table 4: Full data set