Add another column at the end, that displays, HIGH when the spending is $2500, MED when the spending is $1000 but

(b) Using appropriate Excel functions to: (Have to use Excel functions and NOT compute Manually) i. Calculate the number of Female and Male Respondents. ii. Calculate the number of respondents whose Spending is less than $3000

(c) Construct a Pie chart for the column Gender to visually display the proportions.

(d) Add an excel sheet to the existing document to list the number of respondents for each age value considered. (Have to use Excel functions and NOT compute Manually) Hint: Format and one row is shown below. Age Number of respondents 20 5

High Respondent Gender Age Education Income Spending Ad Frequency Stereotype Reinforcing 1 Female 23 Some undergraduate courses 10 9 $10,000 to $20,000 $500 00 9 Drastic 2 Male 22 High school diploma $20 000 ta