Jamie received 105 responses, which are given in the Excel file Drout Advertising Survey.


Review the questionnaire and classify the data collected from each question as categorical, ordinal, interval, or ratio.


Next, explain how the data and subsequent analysis using business analytics might lead to a better understanding of stereotype versus empowerment advertising. Specifically, state some of the key insights that you would hope to answer by analyzing the data.


Use appropriate charts to visualize the data. Summarize the data using:


frequency distributions and histograms for numerical variables,

cross-tabulations, and

other appropriate applications of PivotTables

     to break down the data and develop useful insights.


An important aspect of business analytics is good communication. Write up your answers to this case formally in a well-written report as if you were a consultant


to Ms. Drout USING our class:


0. Template, Analytics Individual Case Analysis Consulting Report.docx