DATA ANALYTICS FOR BUSINESS
Individual Case Analysis – Drout Advertising Research Project
Due: Sun Jul 7, 2024 6:00pm
Ungraded, 100 Possible Points100 Points Possible
NEXT UP: Submit Assignment
Details
Please click on
the next link(s) below to access the following document(s):
.
.
Case Analysis Drout Advertising Research Project Backgound
and Data
.
Drout
Advertising Survey Data.xlsxDownload Drout
Advertising Survey Data.xlsx
.
APA Style Rubric.pdfDownload APA Style
Rubric.pdf
.
0. Template, Analytics Individual Case Analysis Consulting
Report.docxDownload 0. Template,
Analytics Individual Case Analysis Consulting Report.docx
Structure
of Data Analysis Report.pdfDownload Structure of
Data Analysis Report.pdf
———————————————————————————————
Assignments
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:
o frequency distributions and histograms for numerical variables,
o cross-tabulations, and
o other appropriate applications of PivotTables
to break down the
data and develop useful insights.
·
Summarize the numerical data using
descriptive statistics measures,
o find proportions for
categorical variables,
o examine correlations, and
o use PivotTables as
appropriate to compare average values.
.
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, STEP by STEP – Heading Title by Heading Title, our
class (please click on the next link(s) below to
access the following document(s):
.
0. Template, Analytics Individual Case Analysis Consulting
Report.docxDownload 0. Template,
Analytics Individual Case Analysis Consulting Report.docx
.
——————————————————————————————————————————-
Please develop
YOUR OWN Business Data Analytics EXCEL models to support all your answers and
analyses and post this(these) file(s) in addition to your Case Analysis Drout Advertising Research Project Report.
.
Finally, please
answer ALL Questions and Sections of this Data Analytics for
Business Case with great detail AND STEP BY STEP being
extremely 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.
.
I expect high
caliber Case Analysis Reports with top analyses and interesting insights!! If
you have any questions, please let me know
Checklist of Documents to submit:
* Case Analysis Written Report
This document should be a typed professional written report
in Word and PDF format with a 1.5 max line space, a suitable
font such as Times Roman or Calibri of 12 point maximum, and left, right, top,
bottom margins of .8 inches maximum.
** No Word
and PDF format documents: No grading.
.
* Business Data Analytics Case Analysis EXCEL
model(s) files
. Please submit
YOUR OWN Business Data Analytics Case Analysis EXCEL model(s) files.
.
** No Case
Analysis Written Report IN WORD and YOUR OUR OWN Business Data
Analytics Case Analysis EXCEL model(s) files: No grading.
.
Individual and
Team Case Analysis Help and Support … powerful tools, software, and tutorials
… (please click below) …
Pearson Analytics Student Support and Resources: Tools,
Software, and Tutorials