STAT 3010 Lecture Notes - Lecture 11: Pivot Table, Group Selection
Document Summary
To complete table 6. 1, displayed above, i first had to determine how i wanted to divide the data up. I knew from the instruction of question six that my data had to be broken up into low, medium and high categories. I knew that the data"s minimum income was . 30 and the maximum income was . 40, so i decided to subtract my minimum from my maximum which gave me . 30. I then divided . 30 by three because i needed the data to be broken up into three data categories. This means my low, medium and high categories will all be separated by. My if statement gave me the data to fill in my incomecat column. The equation used for the data set for incomecat reads as: E2 is the income column applied to the if statement that will change as it corresponds with the current row to which the if statement is applying.
