MBA 504 Module One Excel Workbook Guidelines and RubricOverview Data measurement is an important aspect of data analytics. Identifying trends in key attributes of data is a fundamental measurement for

MBA 504 Module One Excel Workbook Guidelines and RubricOverview

Data measurement is an important aspect of data analytics. Identifying trends in key attributes of data is a fundamental measurement for various aspects of business data and an important skill for business professionals. In this scenario, you are a business consultant trainee assigned to work with your first client, TC Ice Cream.

TC Ice Cream is a private-label ice cream manufacturer. Located in the northern region of Michigan, TC Ice Cream specializes in premium ice cream flavors. TC Ice Cream is categorized in the food/agriculture business sector. The company has gained popularity over the past three years due to recent publicity such as winning awards on network television food shows, hosting and attending promotional events, and actively using social media.

The management team of TC Ice Cream is looking to see if there are specific trends that could be identified to help them improve their operations and sales and grow their business. You will report the research and analysis of the data to the TC Ice Cream management team. Periodically, you will be expected to apply your training and submit a deliverable to the management team.

The TC Ice Cream information technology team has provided you with a data set, TC Ice Cream Excel Workbook, that contains data about orders over a span of three years.

You will use the data variables to create descriptive statistics and visualizations for TC Ice Cream. This will enable you to effectively and efficiently gain helpful insights into the data and its attributes. You will continue to delve further into your analysis of TC Ice Cream throughout the course.

Prompt

For this assignment, you will perform the following steps as you begin your analysis of the data provided.

Within the TC Ice Cream Excel Workbook, review the sheet “Data Dictionary.” This will help you understand the data provided and specific information about each variable. Review the sheet “TC Ice Cream Data.” DO NOT EDIT this data.

Next, you will calculate the central tendency of the TC Ice Cream data set using the average, median, minimum, maximum, and range. You will also create multiple charts to present the descriptive analysis you performed.

Specifically, you must address the following rubric criteria:

Create a table to represent the average, median, minimum, maximum and range values for each variable. Within the TC Ice Cream Excel Worksheet, use the sheet “Descriptive Statistics” to create the following table.
- Use Excel formulas to calculate the average, median, minimum, maximum, and range values for each of the quantitative variables (Quantity Sold, Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
Create charts to represent the key variables of the data. Within the TC Ice Cream Excel Worksheet, use the sheet “Overall Analysis” to create the charts listed below. It is recommended that you use pivot tables/pivot charts to create the visualizations. Feel free to use this sheet to create any additional visualizations that might help you better understand the data.
- Create a pie chart using the qualitative variable Region and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by region.
- 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.
- Create a bar chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by flavor.
Use the Module One PowerPoint Template to create a PowerPoint presentation that explains the data and its key variables. This should include key visualizations and analysis to support your answers. The PowerPoint Template includes specific questions to answer as you explain the data and variables. Use the visualizations and data analysis you created in the “Descriptive Statistics” and “Overall Analysis” sheets to support your analysis.

What to Submit

TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Descriptive Statistics” and “Overall Analysis” sheets.
PowerPoint Presentation: Submit a PowerPoint Presentation using the Module One 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.

Share This Post

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

Related Questions

Discussion “Trade between individuals, tribes, and then nations has occurred for thousands of years. Throughout the centuries, the desire to control trade and trade routes has often been the cause of

Discussion “Trade between individuals, tribes, and then nations has occurred for thousands of years. Throughout the centuries, the desire to control trade and trade routes has often been the cause of conflict between countries.” Do you agree with this statement? Why or why not? To earn full credit, post an initial

MBA 645 Module Five Presentation Guidelines and RubricOverview Marketing in the digital age is very dynamic; it is necessary to monitor multiple digital channels and platforms to engage with your targ

MBA 645 Module Five Presentation Guidelines and RubricOverview Marketing in the digital age is very dynamic; it is necessary to monitor multiple digital channels and platforms to engage with your target audience without missing any opportunity. Digital channels and platforms are measurable and allow for monitoring performance of your marketing

MBA 687 Module Five Presentation Guidelines and RubricOverview You are an HR consultant, hired to resolve issues stemming from communication and coordination challenges between employees of the U.S. b

MBA 687 Module Five Presentation Guidelines and RubricOverview You are an HR consultant, hired to resolve issues stemming from communication and coordination challenges between employees of the U.S. branch and the Singaporean headquarters of a software solutions provider. You decide to recommend organization-wide changes to resolve the issues related to

MBA 687 Module Five Report Guidelines and RubricOverview The leadership of the Singaporean-headquartered software solutions organization is concerned about issues arising from communication and coordi

MBA 687 Module Five Report Guidelines and RubricOverview The leadership of the Singaporean-headquartered software solutions organization is concerned about issues arising from communication and coordination challenges between employees at the U.S. branch and the Singaporean headquarters. The VP of the U.S. branch tasks you, as an HR consultant, with developing

HIM 500 Guidelines and RubricOverview You will submit an analysis of how the company in the case study is noncompliant and the strategies (general, not specifics) to move it toward compliance. Speci

HIM 500 Guidelines and RubricOverview You will submit an analysis of how the company in the case study is noncompliant and the strategies (general, not specifics) to move it toward compliance. Specifically the following critical elements must be addressed: Health Regulations and Laws Ramifications: In this section of your final

Home county USA Japan is chosen country 2 pages Describe at least two management positions that will require training for in-country positions. The description must include the identification of cultu

Home county USA Japan is chosen country 2 pages Describe at least two management positions that will require training for in-country positions. The description must include the identification of cultural, linguistics and specialized skills needed for the positions. Culturally, describe differences, such as management styles between the workforce in the

Reflect on what you have learned in this unit and explain various paths for repatriating employees of a corporation to the United States, and focus on how to best use the talents and experience gained

Reflect on what you have learned in this unit and explain various paths for repatriating employees of a corporation to the United States, and focus on how to best use the talents and experience gained by the employees during their posting overseas. Be sure to address the differences between retirees,

MBA 687 Module Four Presentation Guidelines and RubricOverview In Milestone One, as an HR consultant, you submitted a change readiness report. While you were performing your change readiness assessmen

MBA 687 Module Four Presentation Guidelines and RubricOverview In Milestone One, as an HR consultant, you submitted a change readiness report. While you were performing your change readiness assessment, five employees from the U.S. call center quit as a group, along with the well-liked team lead. Top management is very

ETHICAL LEADERSHIP-C206 TASK ONE Introduction Leadership is often defined as the ability to influence people. An effective ethical leader guides an organization and its employees to accomplish org

ETHICAL LEADERSHIP-C206 TASK ONE Introduction Leadership is often defined as the ability to influence people. An effective ethical leader guides an organization and its employees to accomplish organizational goals. In the same vein, an unethical leader can guide an organization and its employees to act unethically, harming both the organization

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist adopting new tools. This resistance stems from

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist adopting new tools. This resistance stems from fear of obsolescence, disrupted routines, and perceived tool complexity. Addressing these anxieties through effective communication and training is crucial for smooth technological transitions. **Complete

HIM 500 Rubric Overview Imagine you have been contracted to consult on the recent developments at the Featherfall Medical Center. Featherfall has been struggling of late; it has had a series of proble

HIM 500 Rubric Overview Imagine you have been contracted to consult on the recent developments at the Featherfall Medical Center. Featherfall has been struggling of late; it has had a series of problems that have prompted your hiring. It has faced the following issues: Featherfall has recently violated several government

MBA 687 Guidelines and Rubric Scenario You have been contracted as an HR consultant by a U.S. LLC in Wilmington, Delaware, to solve their internal issues. This U.S. LLC is a branch of a Singaporean s

MBA 687 Guidelines and Rubric Scenario You have been contracted as an HR consultant by a U.S. LLC in Wilmington, Delaware, to solve their internal issues. This U.S. LLC is a branch of a Singaporean software solutions provider with 140 employees and $20M revenue per year. The CEO of the

MBA 645 Guidelines and Rubric Overview You are the regional marketing director of a theme park in the southeastern United States that is part of a global brand. The chief marketing officer (CMO) of g

MBA 645 Guidelines and Rubric Overview You are the regional marketing director of a theme park in the southeastern United States that is part of a global brand. The chief marketing officer (CMO) of global operations has called upon you to help coordinate the marketing tasks related to rolling out

Purpose: This assignment is designed to help you create connections between the course material we have learned throughout Modules 2-4. Specifically, using an adaptive leadership approach, you will

Purpose: This assignment is designed to help you create connections between the course material we have learned throughout Modules 2-4. Specifically, using an adaptive leadership approach, you will pick an adaptive challenge that you want to/already are working on. You will then demonstrate your understanding of the course material by

Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking about an ethic

Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking about an ethical dilemma in one of your systems. You will apply Kidder’s nine checkpoints to the ethical dilemma of your choosing

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typicall

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they

Part I: Choose two American international companies. The selection must be an intercultural organizations doing business in at least one foreign country. Not Cuba, North Korea, etc… In your submi

Part I: Choose two American international companies. The selection must be an intercultural organizations doing business in at least one foreign country. Not Cuba, North Korea, etc… In your submission, provide a review and arguments for and against each of the two organizations. In the conclusion of your submission, recommend which

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typicall