Please read the following Data Analytics for Business case in the excel file and please analyze the data on the data page requested in this Case Analysis.

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 .

 

The overall structure of a data analysis report is simple:

1. Introduction

2. Body

3. Conclusion(s)/Discussion

4. Appendix/Appendices 

Supporting Documents for this Learning Assignment

· Structure of a Data Analysis Report PDF Document

· Consulting Is More Than Giving Advice

https://hbr.org/1982/09/consulting-is-more-than-giving-advice

· Data Analysis Steps

https://www.r-bloggers.com/data-analysis-steps/

· The Difference Between Reporting and Analysis and Why it Matters

https://datahero.com/blog/2017/08/14/data-reporting-and-analysis/

· How to Write a Data Report

https://smallbusiness.chron.com/write-data-report-61330.html

· The Seven Key Steps of Data Analysis

https://rizkashifs.wordpress.com/2015/09/03/the-seven-key-steps-of-data-analysis/