Henry Wants to Analyze Income, but the Sheer Number of Categories

Multiple Choice

Henry wants to analyze income, but the sheer number of categories in the data's current form will make a clear analysis less meaningful. In Excel with Analytic Solver, how will Henry determine the frequency of each category to transform his data?

A) Income variable is selected and Analytic solver produces frequency levels for each income category from most to least frequent.
B) Inspect the frequency of Income category: >table(myData$Income) .
C) Income variable is selected and Analytic Solver produces a new category for non-use variables.
D) Apply a limit to the number of categories from the drop-down to a reasonable number.