I need to perform excel for my subject business analytic in the university. Urgent!
1- Assignment: 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. 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.
2- . For this part of the case, propose and test some meaningful hypotheses that will help Ms. Drout understand and explain the results.
Include two-sample tests, ANOVA, and/or Chi-Square tests for independence as appropriate. Write up your conclusions in a formal report, or add your findings to the report you completed for the case in Chapter 6 as per your instructor’s requirements. If you have accumulated all sections of this case into one report, polish it up so that it is as professional as possible, drawing final conclusions about the perceptions of the role of advertising in the reinforcement of gender stereotypes and the impact of empowerment advertising.
Category: Sales & Marketing
Subcategory: Data Analytics
Project size: Small
Is this a project or a position?: Project
Required availability: As needed