Need help with the following assig.
*please read the case attached (world doc.) and review the excel file (attached).
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.
Develop your own Business Data Analytics excel models to support your answers and analyses.
Answer all Questions and Sections of this Data Analytics for Business Case with detail and step by step being methodical and accurate in your answers. It is extremely important that for each Question and Section, you write the entire question and you label and/or place the appropriate headings and subheadings clearly for each part of the question and/or section.
Please address, analyze, and discuss in great detail and thoroughly support and explain the what’s, how’s, and why’s of each of your answers.
-Case Analysis Written Report:
This document should be a typed professional written report in Word. ( PDF guide is attached for your reference)
and YOUR OWN Business Data Analytics Case Analysis in EXCEL model to support this report.