Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 4

Campaign organizers for both the Republican and Democrat parties are interested in identifying individual undecided voters who would consider voting for their party in an upcoming election. The file BlueOrRed contains data on a sample of voters with tracked variables including: whether or not they are undecided regarding their candidate preference, age, whether they own a home, gender, marital status, household size, income, years of education, and whether they attend church.
Partition the data into training (50 percent), validation (30 percent), and test (20 percent) sets. Classify the data using k -nearest neighbors with up to k 5 20. Use Age, Home- Owner, Female, Married, HouseholdSize, Income, and Education as input variables and Undecided as the output variable. In Step 2 of XLMiner's k -nearest neighbors Classification procedure, be sure to Normalize input data and to Score on best k between 1 and specified value. Generate lift charts for both the validation data and test data.