Our Services

Get 15% Discount on your First Order

MBA 504 Module Two Excel Workbook Guidelines and RubricOverview Data visualization is a quick, easy, and effective way to convey concepts in a universal

October 21, 2024

MBA 504 Module Two Excel Workbook Guidelines and RubricOverview

Data visualization is a quick, easy, and effective way to convey concepts in a universal manner. Visualized data helps you understand large and complex data sets easily so you can make decisions based on the analysis. It also helps you identify new patterns, trends, and correlations in the attributes.

In this scenario, you are continuing to work as a business consultant trainee with the TC Ice Cream client. Now you will take a deeper dive into the analysis, focusing on a division of your choice. The division that you select will be used for future assignments as well. The division “West North Central” cannot be used for your analysis.

After having spent time reviewing your initial discoveries, the TC Ice Cream management team has asked you to create an in-depth visualization of the data. You will be required to create multiple charts of each type: line, pie, column, and combo. Your analysis should now focus on the quantitative variables (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions) and the data for the specific region you selected. Different visualizations can help one discover new aspects of the data. Examining the division data will provide further insight as you begin to identify new patterns, trends, and relationships or correlations in the key variables.

Additionally, you will create a PowerPoint presentation to present your findings for the TC Ice Cream management team. In this short presentation, you will also explain the new insights that you have gathered during your continued analysis.

Prompt

You will create multiple charts of each type: line, pie, column, and combo. Then explain the new insights that you have gathered during your continued analysis.

Specifically, you must address the following rubric criteria:

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.

What to Submit

In this assignment you will submit an updated Excel file and a PowerPoint presentation.

TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Division Analysis” sheet.
PowerPoint Presentation: Submit a PowerPoint Presentation using the Module Two PowerPoint Template. If references are included, they should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.

Business & Finance

Share This Post

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

Related Questions

Module 4 – CaseDuty EthicsAssignment Overview Business Controversies from a Duty Ethics Perspective Duty or deontological ethics highlights the inherent

Module 4 – CaseDuty EthicsAssignment Overview Business Controversies from a Duty Ethics Perspective Duty or deontological ethics highlights the inherent rightness of an action, independent of outcomes. It promotes consistent moral behavior. In a rapidly changing world, duty ethics is often referred to as a steadfast moral compass. **Complete Case

1. Global Strategic Management This 200-word response journal measures your mastery of ULOs 2.2 and 5.3. What are your thoughts about the importance of

1. Global Strategic Management This 200-word response journal measures your mastery of ULOs 2.2 and 5.3. What are your thoughts about the importance of strategy in an era of significant challenge and change? What ethical parameters, including human rights and intellectual property, do you think should be addressed in a

1. Business In your final journal for this course, you will discuss entrepreneurship and organizational behavior. First, describe the characteristics of

1. Business In your final journal for this course, you will discuss entrepreneurship and organizational behavior. First, describe the characteristics of entrepreneurs and the entrepreneurial mindset. Next, define organizational behavior in your own words. Identify how a manager’s entrepreneurial mindset and knowledge of organizational behavior can lead to an organization’s

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information: the name of the company or business and a description of the ethical issue that took place,

Create a final report for the industry you selected in Unit III detailing the impacts of the United States/China trade war. This report should address

Create a final report for the industry you selected in Unit III detailing the impacts of the United States/China trade war. This report should address the following topics:major issues of the trade war;the tactics and measures taken by the United States and China during the trade war;the impacts of the

1. For this Journal, you will share your ideas regarding your personal or professional brand as well as reflect upon how course concepts learned will

1. For this Journal, you will share your ideas regarding your personal or professional brand as well as reflect upon how course concepts learned will help you build a better brand.Answer the following questions:What is your personal or professional brand? How could you use the concepts from this unit or

You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in

You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. The owners are ready to sell the organization and have identified a potential buyer. You have been working with the strategic planning team to

VAL- UP TO 4/24/2025- *** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED* **** THIS ASSIGNMENT HAS 2 PARTS /

VAL- UP TO 4/24/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 2- DISCUSSION- (VAL)- Course Title: Fiscal Accountability for Organizational Leadership

The purpose of this journal is to use the knowledge you have gained about the basic principles of marketing to review a commercial for a product or

The purpose of this journal is to use the knowledge you have gained about the basic principles of marketing to review a commercial for a product or service. Please view the following commercial: Balancing Work and School video. A transcript and closed captioning are available once you access the video. In an

In this section of your white paper, you will analyze the strategic management practices of the two organizations. Specifically, you should address the

In this section of your white paper, you will analyze the strategic management practices of the two organizations. Specifically, you should address the following critical elements: Strategic Management: Compare the elements of strategic planning and the strategic management process used by the two organizations. In other words, how did the organizations

BIBLE AND ORGANIZATIONS ASSIGNMENT INSTRUCTIONSOVERVIEWThe Word of God instructs us “Whatever you do, work at it with all your heart, as working forthe

BIBLE AND ORGANIZATIONS ASSIGNMENT INSTRUCTIONSOVERVIEWThe Word of God instructs us “Whatever you do, work at it with all your heart, as working forthe Lord, not for human masters, since you know that you will receive an inheritance from theLord as a reward. It is the Lord Christ you are serving”

LITERATURE REVIEW ASSIGNMENT INSTRUCTIONSThe purpose of this research project is for you to create a scholarly piece of graduate-levelresearch and

LITERATURE REVIEW ASSIGNMENT INSTRUCTIONSThe purpose of this research project is for you to create a scholarly piece of graduate-levelresearch and writing, which conforms to current APA format. Competency in the current APAformat is required of all Business graduates of Liberty University, as set forth by policy of boththe Graduate Faculty

HAL is my company You should edit the excel and answer the questions

This scholarly activity measures your mastery of ULOs 5.3, 5.4, 5.5, and 6.4. For this assignment, you will compile the financials of a business plan for

This scholarly activity measures your mastery of ULOs 5.3, 5.4, 5.5, and 6.4. For this assignment, you will compile the financials of a business plan for an original and innovative business idea that could be taken to market. Use the same product or service idea from Unit VI’s PowerPoint presentation.

MBA 580 Guidelines and RubricOverview Using the recommendation you provided in Milestone One, you will develop a strategy to implement the IoT

MBA 580 Guidelines and RubricOverview Using the recommendation you provided in Milestone One, you will develop a strategy to implement the IoT innovation and move ahead in the marketplace. Scenario You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks.

Submit your 20+page Capstone paper to your instructor for grading. I put together a Table of Contents you may change to suit the Assignment, but I need a

Submit your 20+page Capstone paper to your instructor for grading. I put together a Table of Contents you may change to suit the Assignment, but I need all those for MBA Concentration: Corporate Innovation Stratasys Ltd Instructions: You will submit your final Capstone Project paper after making changes based on

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical

You will create a 10-minute video presentation of your Final Capstone Project Stratasys Ltd. and post it to the Unit 8 Discussion Capstone Project

You will create a 10-minute video presentation of your Final Capstone Project Stratasys Ltd. and post it to the Unit 8 Discussion Capstone Project Presentation forum. What would you use to make your pitch to your l You will create a 10-minute video presentation of your Final Capstone Project and