3. A food processing company has developed a new ready-made meal for dinner. The file NewMealTriers.xls (posted in the week 4 of course portal) contains data on the potential customers being tracked by the company. The file contains a number of demographic variables on these customers The data also indicates whether they have tried the company's newly developed meal. The company wants to understand why some potential customers tried the new meal and others are not. Does gender make a difference? Does income make a difference? In general, what distinguishes those who tried the new meal from those who don't? (hint: use pivot tables to explore these questions)
a. Generate pivot table and bar chart to examine the effect of gender. Who do you think is more likely to try the new meal, males or females?
Show the percentages of those who tried and those who don't for males and females separately. Provide a concluding statement.
b. Generate pivot table and bar chart to examine the effect of LiveAlone. Who do you think is more likely to try the new meal, those who live alone or those who don't live alone? Provide a concluding statement.
