Create a new sheet in the Marketing.xlsx file and name it $$Case Answers $3.$

In the $$Case Answers $3$ sheet, using pivot tables, complete following questions by entering your answers in tabs below $($make sure all your tables and charts are available in the $$Case Answers $3$ sheet$)$ how to solve this with excel. step by step. Create a frequency distribution table for different groups in purchase amount variable $($use a bin size of $450$ for each group$).$ Then, filter the frequency table based on different product categories. Fill the table for the Clothing category.