Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice

  1. Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice Cream Excel Workbook, use the “Division Analysis” sheet to create the following charts. It is recommended that you use pivot table filtering functionality to filter the data to the specific division you have selected.
    • Create a pie chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by flavor for the division.
    • Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month for the division.
    • Create a bar chart using the qualitative variable Flavor and the quantitative variable Flavor Rating to provide a visualization displaying average flavor rating by flavor.
    • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenses (line – secondary axis).
    • Create a combo chart using the qualitative variable Flavor (x-axis) and the quantitative variables Quantity Sold (clustered column) and Average Flavor Rating (line – secondary axis).
  2. Use the Module Two PowerPoint Template to create a PowerPoint presentation that explains the identified patterns, trends, and correlations. This should include key visualizations and analysis to support your answers. The template includes specific questions to answer. Use the visualizations and data analysis you created in the “Division Analysis” sheet to support your analysis.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Public managers need to be able to position their organizations to achieve desired program outcomes by using fundamental strategic management techniques.

Public managers need to be able to position their organizations to achieve desired program outcomes by using fundamental strategic management techniques. Managers may be charged with diagnosing complex situations and resolving them in ways that enhance organizational performance. Throughout this course, you have learned strategic perspectives on the management and

PROMPT 1 How can businesses strategically leverage social media platforms to enhance brand visibility, foster audience engagement, and drive growth?

PROMPT 1 How can businesses strategically leverage social media platforms to enhance brand visibility, foster audience engagement, and drive growth? Discuss key tactics including platform selection, content optimization, audience interaction, paid advertising, and performance analytics. Support your response with at least four credible references. MUST BE AT LEAST 500 WORDS

Competencies In this project, you will demonstrate your mastery of the following competencies: Manage stakeholder relationships to sustain a competitive

Competencies In this project, you will demonstrate your mastery of the following competencies: Manage stakeholder relationships to sustain a competitive advantage Align and integrate a short-term goal with a strategic plan Create a change management strategy Scenario You are a business development manager reporting to the vice president (VP) of

Reply must incorporate at least 1 scholarly citation in the current APAformat. DisruptiveMarketing, at least 1 Biblical verse needs to cited, in current

Reply must incorporate at least 1 scholarly citation in the current APAformat. DisruptiveMarketing, at least 1 Biblical verse needs to cited, in current APA format, under the BiblicalIntegration subject header). Any sources cited must have been published within the last fiveyears, except for the Bible Value Differentiation Versus Customer Needs

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course,

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we are exploring how the humanities teach us Module Two Project Proposal Guidelines and Rubricinstructions attached  HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we