For this part of the case:
- Summarize the numerical data using descriptive statistics measures, find proportions for categorical variables, examine correlations, and use PivotTables as appropriate to compare average values.
- Compute confidence intervals for means and proportions, and
- Analyze the sampling errors, possibly suggesting larger sample sizes to obtain more precise estimates.
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:
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.