Dummy Coding
BA/EC 311 – QUANTITATIVE ANALYSIS
BIRMINGHAM-SOUTHERN COLLEGE
DUMMY CODING
The Excel file “Dummy Coding” below contains three different datasets (see the tabs at the bottom of the file to access the different sheets). Provide the proper dummy coding for the categorical variables shown in each sheet.
Sheet #1: A survey recorded respondents’ religious
preference.
Sheet #2: A survey recorded respondents’ gender and division
within a company.
Sheet #3: A survey recorded respondents’ immigration status,
race and nationality.
You may choose to complete the coding within the Excel. If you do this, you may find it easier to sort the sheet by the variable that you are dummy coding. This will group all of the same categories together. Save the spreadsheet and post it to Moodle.
Alternatively, some students don’t like working in Excel. So if you prefer, you may print each page in the spreadsheet and perform the dummy coding by hand. If you do this, scan your work, or make a picture of it, and post it to Moodle saved as a word doc.