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 Demonstrate your understanding of philosophy, epistemology, and research paradigms by applying them to a real-world business challenge relevant to your industry or professional context. In

DISCUSSION Demonstrate your understanding of philosophy, epistemology, and research paradigms by applying them to a real-world business challenge relevant to your industry or professional context.Instructions:1. Identify a Complex Business Problem:Choose a current, real-world business issue from your industry or organization (e.g., digital transformation, declining customer engagement, ethical leadership dilemmas, global supply chain disruptions, etc.).2. Apply Epistemological LensesAnalyze how two

Part 1: Company identification For this assignment, you will start by selecting a company you are familiar with to serve as a hypothetical manager. This can be a company you work for currently, one yo

Part 1: Company identification For this assignment, you will start by selecting a company you are familiar with to serve as a hypothetical manager. This can be a company you work for currently, one you wish to work for in the future, or one that is well-known. Then, explain why

Use Japan Review the styles of written, verbal, and nonverbal communications used within your chosen culture or subculture. Your reasoning must be supported by your review and analysis or arguments of

Use Japan Review the styles of written, verbal, and nonverbal communications used within your chosen culture or subculture. Your reasoning must be supported by your review and analysis or arguments of current and viable sources. Each of the methods of communication must be treated separately in your paper. Your submission

In this assessment, you will analyze a case study and write a 1500-2000 words, APA formatted paper analyzing the problem and offering solutions. Remember you MUST apply the theories, methods, topics,

In this assessment, you will analyze a case study and write a 1500-2000 words, APA formatted paper analyzing the problem and offering solutions. Remember you MUST apply the theories, methods, topics, and principles you have learned in your courses. The problem presented in this case study represents a topic covered in

DISCUSSION Title: “Designing the Blueprint: Applying Research Methods to a Real-World Business Problem” Task Instructions: Imagine you are a consultant hired by a mid-sized organization facing a sig

DISCUSSION Title: “Designing the Blueprint: Applying Research Methods to a Real-World Business Problem” Task Instructions: Imagine you are a consultant hired by a mid-sized organization facing a significant business challenge (e.g., high employee turnover, declining customer satisfaction, inefficiencies in supply chain, market expansion failure, etc.). Based on this scenario: 1. Briefly

DISCUSSION Think of a real-world business problem you have encountered in your professional experience or are currently facing in your organization (or one you are familiar with). This could relate to

DISCUSSION Think of a real-world business problem you have encountered in your professional experience or are currently facing in your organization (or one you are familiar with). This could relate to areas such as customer retention, employee engagement, market expansion, process inefficiencies, product performance, or operational cost control. Your task:

DISCUSSION You are a senior consultant brought in to support a mid-sized organization facing a critical business decision (e.g., declining customer retention, rising operational costs, underperforming

DISCUSSION You are a senior consultant brought in to support a mid-sized organization facing a critical business decision (e.g., declining customer retention, rising operational costs, underperforming product lines, or low employee engagement). As part of your consultancy, you are required to propose a quantitative research plan to investigate the issue

DISCUSSION Select three peer-reviewed latest (last 2-3 years) scholarly articles that are directly relevant to any research problem. After carefully reading and annotating each article, craft a mini l

DISCUSSION Select three peer-reviewed latest (last 2-3 years) scholarly articles that are directly relevant to any research problem. After carefully reading and annotating each article, craft a mini literature synthesis (500–600 words) in which you: 1. Briefly summarize the core findings of each article (no more than 2–3 sentences per article). 2. Critically evaluate

DISCUSSION As a doctoral candidate preparing your mini-research proposal, imagine you must now present the essence of your proposed study to a key stakeholder, such as a C-suite executive, investor, b

DISCUSSION As a doctoral candidate preparing your mini-research proposal, imagine you must now present the essence of your proposed study to a key stakeholder, such as a C-suite executive, investor, board member, policymaker, or department head who may be interested in supporting, funding, or approving your research. Write a professional

Part 1: Company identification For this assignment, you will start by selecting a company you are familiar with to serve as a hypothetical manager. This can be a company you work for currently, one

For the Unit IV Journal, will consider Unit I-IV, including the four functions of management (planning, leading, organizing, and control), and core managerial concepts we have covered in each unit.

For the Unit IV Journal, will consider Unit I-IV, including the four functions of management (planning, leading, organizing, and control), and core managerial concepts we have covered in each unit. The Task: State your selected management position and the company name you chose in the Unit III Assignment. Your organization is

This assignment will be completed in two parts: Part I: Choose two candidate organizations. The selection must be an intercultural organization doing business in at least one foreign country. In yo

This assignment will be completed in two parts: Part I: Choose two candidate organizations. The selection must be an intercultural organization doing business in at least one foreign country. In your submission, provide a review and arguments for and against each of the two organizations. At the end of your

SHEILA- UP TO 12/5/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS ASSIGNMENT HAS 4

SHEILA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 4 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** SPECIAL EVENT MANAGEMENT ****

Module 2 – SLPLeadership Skills and The Tribe Conduct research to find a team or organization that shows clear evidence that it uses the skills model of leadership. Use the research you conduct to det

Module 2 – SLPLeadership Skills and The Tribe Conduct research to find a team or organization that shows clear evidence that it uses the skills model of leadership. Use the research you conduct to determine your best judgment regarding the organization or team’s tribal stage. SLP Assignment Expectations Acting as

Leadership Skills and The TribeAssignment Overview For this case assignment, you will fully discuss the three-skill approach to leadership, using credible sources to back your work. Case Assignment Pe

Leadership Skills and The TribeAssignment Overview For this case assignment, you will fully discuss the three-skill approach to leadership, using credible sources to back your work. Case Assignment Perform research and describe a team or organization that utilizes the three-skills approach to leadership. Synthesize the skill mixes exhibited at each

1.Does your project management plan need a section that addresses (communications). Why or why not? If the answer to #1 above is “no” (Communication) then you can skip #2 and #3 for (communication).

1.Does your project management plan need a section that addresses (communications). Why or why not?If the answer to #1 above is “no” (Communication) then you can skip #2 and #3 for (communication). However, you should then offer a very compelling argument to justify your “no” answer. If the answer to

SHEILA- UP TO 11/30/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS ASSIGNMENT HAS

SHEILA- UP TO 11/30/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** SPECIAL EVENT MANAGEMENT ****