Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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 Analys

  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

Good evening , i need assistance with an assingment . please review below. Business administrators must evaluate how organizations operate within their historical development, industry context, and gl

Good evening , i need assistance with an assingment . please review below. Business administrators must evaluate how organizations operate within their historical development, industry context, and global environment. Effective administration requires analyzing organizational needs across areas such as leadership, operations, and change management. In today’s business landscape, effective administration

Good evening , need assistance with a competency assignment- Must free free of Ai detection and work Business administrators must evaluate how organizations operate within their historical developmen

Good evening , need assistance with a competency assignment- Must free free of Ai detection and work  Business administrators must evaluate how organizations operate within their historical development, industry context, and global environment. Effective administration requires analyzing organizational needs across areas such as leadership, operations, and change management. In today’s

Use the Assignment on this website: https://bookshelf.vitalsource.com/home/dashboard?context=login The instructions for this assignment are also found in Chapter 16 of your required textbook. AssiUs

Use the Assignment on this website: https://bookshelf.vitalsource.com/home/dashboard?context=login The instructions for this assignment are also found in Chapter 16 of your required textbook. AssiUsegnment 2 Financial Analysis Project Phase II Completion requirements Assignment 2 Overview Now that you’ve set your workbook up and have completed the SurgiFlex calculations in Phase I,

***PROJECT 1 IS IN THE ATTACHMENT*** Competency In this second part of the four-part project series, you will demonstrate your mastery of the following competency: Analyze quantitative and qualitati

                ***PROJECT 1 IS IN THE ATTACHMENT*** Competency In this second part of the four-part project series, you will demonstrate your mastery of the following competency: Analyze quantitative and qualitative data to solve problems and make decisions that impact organizations and their stakeholders

Good evening, I need assistance completing this assignment (MUST BE FREE OF AI DETECTION ). Competency 1 Assessment Instructions You’re a business consultant, and your new task is to teach a group o

Good evening, I need assistance completing this assignment (MUST BE FREE OF AI DETECTION  ). Competency 1 Assessment Instructions You’re a business consultant, and your new task is to teach a group of interns how economic events impact economic activity and economic concentration. You’ve decided to present the information in

Good evening, I need assistance with completing this assignment. (must be free of AI detection) Competency 1 Assessment Instructions Southwest Airlines is facing tough competition and needs to update

Good evening, I need assistance with completing this assignment. (must be free of AI detection) Competency 1 Assessment Instructions Southwest Airlines is facing tough competition and needs to update how it handles HR—things like hiring, training, and keeping workers happy—to stay on top. They’ve decided to hire you as an

Touchstone 4: Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzin

Touchstone 4: Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzing the organization both internally and externally using some of the tools and frameworks you have learned in this course. You are also

Week 8 – Assignment: Improve (Use the I in the A-S-I Framework) Instructions Assignment Directions: Focusing on the Improve pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the

Week 8 – Assignment: Improve (Use the I in the A-S-I Framework) Instructions Assignment Directions: Focusing on the Improve pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the operational efficiencies to be gained by your improvements. These may include customer satisfaction, transport / delivery time, energy usage, and carbon

Looking for someone to do my assignment below free of AI and plagiarism. Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, descri

Looking for someone to do my assignment below free of AI and plagiarism. Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the need to improve the efficiency of the transport system as a whole. This is a big picture

Provide background information on your company (A. O. Smith Corporation; NYSE: AOS). Create a value proposition for the company and discuss the key value proposition components as they relate to your

Provide background information on your company (A. O. Smith Corporation; NYSE: AOS). Create a value proposition for the company and discuss the key value proposition components as they relate to your company. Explain how the company creates value and for whom. Explain the company’s value capture strategy.  Discuss Porter’s Five

Looking for someone to do my assignment below that is AI and plagiarism free: Assignment Directions: Part #1 of 4: Using course readings and resources including the United States Pocket Guide to Trans

Looking for someone to do my assignment below that is AI and plagiarism free: Assignment Directions: Part #1 of 4: Using course readings and resources including the United States Pocket Guide to Transportation [webpage],  Transportation Statistics Annual Report [webpage] (TSAR), and Transportation Geography of the United Sates [webpage], identify a major transportation need and

InstructionsAssignment Directions: Focusing on the Shift/Maintain pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict approaches to improve transportation efficiency. This is a lo

InstructionsAssignment Directions: Focusing on the Shift/Maintain pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict approaches to improve transportation efficiency. This is a logical view. Use data and depictions as appropriate. Submit a paper in Microsoft Word format with your recommendations for the transportation system. Include a title page, 3-5

Week 4 – Assignment: Avoid/Reduce (Use the A in the A-S-I Framework) Instructions Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework,

Week 4 – Assignment: Avoid/Reduce (Use the A in the A-S-I Framework) Instructions Assignment Directions: Part #2 of 4: Focusing on the Avoid/Reduce pillar of the Avoid-Shift-Improve (A-S-I) Framework, describe and depict the need to improve the efficiency of the transport system as a whole. This is a big picture