Our Services

Get 15% Discount on your First Order

Business & Finance

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

August 10, 2024

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).
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.

Business & Finance

Share This Post

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

Related Questions

MBA 620 Guidelines and RubricScenario You are a former pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of

MBA 620 Guidelines and RubricScenario You are a former pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the southeast part of the United States. Your division’s private charter clients include several Fortune 500

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis Complete Module 4 SLP before Module 4 Case We have been

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis **Complete Module 4 SLP before Module 4 Case** We have been working with survey data throughout class. Create a final report that can be used by industry leaders. Data analysis is transformed to business intelligence. This is where you

There’s 11 DQ questions and a response to each question. At least 75 words each.

BUS700 – Capstone Unit 8 Assignment 2: Capstone Project- Final Paper This Final Paper and Presentation is about Stratasys Ltd. printing company, The

BUS700 – Capstone Unit 8 Assignment 2: Capstone Project- Final Paper This Final Paper and Presentation is about Stratasys Ltd. printing company, The paper needs to be very detailed in SMART objectives and Financial & Quantitative Analysis: Financial models/reports/data and measurements Submit your 20+page Capstone paper! Instructions: You will submit

ListenMBA 580 Module Two Report Guidelines and RubricOverview You work as a middle manager for one of the top U.S. producers of luxury and mass-market

ListenMBA 580 Module Two Report Guidelines and RubricOverview You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. Your company has decided to incorporate internet of things (IoT) technology in its vehicles (also called connected cars). Often organizations have to

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As generations change, businesses must adapt to diverse ethical priorities, and foster cross-generational collaboration for sustainable success. Complete SLP 2 before Case 2 Case 2 ResourcesText: 5.2 Business Ethics over Time (2023) Text: 11.1 Business Ethics

Hello! These are discussions post that needs to be at least 175 words or more for each discussion. Each discussion post must be in your own words. Add

Hello! These are discussions post that needs to be at least 175 words or more for each discussion. Each discussion post must be in your own words. Add references at the bottom. 1. Context: Services are designed differently than products. Typically services are designed to shape how the customer thinks

Code of Ethics and Evaluation Paper The task is to create an original code of ethics and evaluation paper for your company or organization. You may also

Code of Ethics and Evaluation Paper The task is to create an original code of ethics and evaluation paper for your company or organization. You may also choose to create a code of ethics for a fictitious company or organization if you prefer not to use your employer. Codes of

Read Case 8, “Google: Don’t Be Evil Unless…,”. Case study below. “8 Google: Don’t Be Evil Unless . . . From its start in a garage in Silicon Valley in 1

Read Case 8, “Google: Don’t Be Evil Unless…,”. Case study below. “8 Google: Don’t Be Evil Unless . . . From its start in a garage in Silicon Valley in 1998, Google has become one of the most powerful technology-driven companies in the world. Started by two graduate students at

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis Complete Module 3 SLP before Module 3 Case This is your final

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis **Complete Module 3 SLP before Module 3 Case** This is your final data analysis project in class. You have become very familiar with the data and have a number of findings that may assist in managerial decision-making. The goal is to

Reply of at least 500 words each by 11:59 p.m. (ET), Each reply must be supported by at least 3scholarly peer-reviewed sources in the current APA format.

Reply of at least 500 words each by 11:59 p.m. (ET), Each reply must be supported by at least 3scholarly peer-reviewed sources in the current APA format. Any sources cited must have beenpublished within the last five years. The main post and replies must contain biblical integration.The Bible must be

Reply of at least 500 words each by 11:59 p.m. (ET), Each reply must be supported by at least 3scholarly peer-reviewed sources in the current APA format.

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots Complete Module 3 SLP before Module 3 Case Let us delve

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots **Complete Module 3 SLP before Module 3 Case** Let us delve into Organizational Commitment. In your earlier research, you discovered how important this is to a company. Now, we will investigate what types of correlations exist between Organizational Commitment and

In this phase of your Capstone Project, you will construct a draft of the financial aspects of your project. Please submit your draft to the Unit 4

In this phase of your Capstone Project, you will construct a draft of the financial aspects of your project. Please submit your draft to the Unit 4 Disussion Board and provide constructive comments to at least two other students. Once you receive your feedback, evaluate their feedback and make needed

Submit a reply of at least 250 words, the reply may be in the first person and does not need to have scholarly support since this is adiscussion.must be

Submit a reply of at least 250 words, the reply may be in the first person and does not need to have scholarly support since this is adiscussion.must be in current APA format in terms of grammar and punctuation, aswell as proper citations if resources are used. If resources are