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

SLP/BUS530 Managerial Economics  Economic Justice and Organizational Strategy Assignment Overview Presentation On an economic topic that has staunch

SLP/BUS530 Managerial Economics  Economic Justice and Organizational Strategy Assignment Overview Presentation On an economic topic that has staunch supporters on multiple perspectives. SLP Assignment Presentation: Economics of Social Responsibility and Profit  Social Responsibility and Profit must be balanced and consider at least two different viewpoints. The main focus must be

Case/BUS530 Managerial Economics  Economic Justice And Organizational Strategy Assignment Overview Economic Justice Economic Justice is a global issue. The

Case/BUS530 Managerial Economics  Economic Justice And Organizational Strategy Assignment Overview Economic Justice Economic Justice is a global issue. The struggle for Economic Justice in modern America is not a new movement. Paradigm-shifting events in 2020 pushed companies and organizations to address inequities and assess their track records while devising a

Business and Entrepreneurship INSTRUCTIONS: During the pandemic, some restaurants automatically included ″Gratuity″ in your bill. There was even a

Business and Entrepreneurship INSTRUCTIONS: During the pandemic, some restaurants automatically included ″Gratuity″ in your bill. There was even a ″COVID-19″ fee included. I′ve seen ″suggested″ tip start at 15%. Patrons called foul on restaurants that automatically included these fees. I remember seeing posts on social media by dissatisfied patrons complain that

6-1 Discussion: Intentional Inclusion Through Cultural AwarenessCultural awareness requires that you understand your cultural worldview and how the

6-1 Discussion: Intentional Inclusion Through Cultural AwarenessCultural awareness requires that you understand your cultural worldview and how the experiences you have lived can impact your perceptions of cultural differences. Regardless of your experiences, it’s important to listen to others with empathy and give them a safe space to communicate and

Using the Sun Coast data set, perform a correlation analysis, simple regression analysis, and multiple regression analysis, and interpret the

Using the Sun Coast data set, perform a correlation analysis, simple regression analysis, and multiple regression analysis, and interpret the results.  Please follow the Unit V Scholarly Activity template to complete your assignment.  You will utilize Microsoft Excel ToolPak for this assignment. Example:  Correlation Analysis  Restate the hypotheses.  Provide data