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

My topic is Value Creation & Impact Only need to be a quick 300-500 words Purpose This Unit 5 Team Assignment aims to develop a DEI plan for a large organization (several hundred employees o

My topic is Value Creation & Impact Only need to be a quick 300-500 words Purpose This Unit 5 Team Assignment aims to develop a DEI plan for a large organization (several hundred employees or more). The organization could be one of the team member’s organizations, an organization one of

My topic is Value Creation & Impact Only need to be a quick 300-500 words Can use the attachment to see section six where it will be added Purpose This Unit 5 Team Assignment aims to develop

My topic is Value Creation & Impact Only need to be a quick 300-500 words Can use the attachment to see section six where it will be added Purpose This Unit 5 Team Assignment aims to develop a DEI plan for a large organization (several hundred employees or more). The

VAL- MG PERF & CHANGE IN WORKKPLACE- ORG-225UP TO 11/14/2025- * IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH T

****VAL- MG PERF & CHANGE IN WORKKPLACE- ORG-225****UP TO 11/14/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

Week 6 to do Case Study: Implementing a New Customer Management System (CMS) at XYZ Bank XYZ Bank, a mid-sized financial institution, aims to implement a new Customer Management System (CMS) to improv

Week 6 to do Case Study: Implementing a New Customer Management System (CMS) at XYZ Bank XYZ Bank, a mid-sized financial institution, aims to implement a new Customer Management System (CMS) to improve customer service and streamline operations. The project team must choose the best project management model—Traditional, Hybrid, or

Discussion Question: In an Extreme Project Management environment, where flexibility and rapid changes are common, how can you as a project manager ensure accountability among team members? Can you p

Discussion Question: In an Extreme Project Management environment, where flexibility and rapid changes are common, how can you as a project manager ensure accountability among team members? Can you provide an example of a project where maintaining accountability was challenging but successfully managed? Can Extreme Project Management and Agile be

The Construction of Greenfield Community Center: Background: The local government has approved the construction of the Greenfield Community Center, a multi-purpose facility aimed at providing educatio

The Construction of Greenfield Community Center: Background:The local government has approved the construction of the Greenfield Community Center, a multi-purpose facility aimed at providing educational, recreational, and social services to the residents. The project follows a traditional project management approach and is expected to be completed in 12 months with

Regarding ‘iterative bounding’, discuss the 3 types (spatial, temporal, and relational). Application of Bounding to an Element of a Digital Case Study Design THEN show how you would apply at least 1

Regarding ‘iterative bounding’, discuss the 3 types (spatial, temporal, and relational). Application of Bounding to an Element of a Digital Case Study Design THEN show how you would apply at least 1 of these 3 types of bounding to 1 of 8 elements in a digital case study design. Remember brevity, be concise

**DOLL * IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!*** THERE ARE 2 PARTS PART 1: DISCUS

****DOLL**** ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** THERE ARE 2 PARTS PART 1: DISCUSSION MODULE 3 Governance In an organization, governance is the system of rules, practices, and processes that guide how

VAL- MG PERF & CHANGE IN WORKKPLACE- ORG-225 UP TO 11/10/2025- * IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUG

****VAL- MG PERF & CHANGE IN WORKKPLACE- ORG-225**** UP TO 11/10/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 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES

Discussion Question: Scenario: Imagine a healthcare organization planning to implement a new patient management system to improve operational efficiency. Without proper project management processes,

Discussion Question: Scenario: Imagine a healthcare organization planning to implement a new patient management system to improve operational efficiency. Without proper project management processes, the team may face issues such as unclear goals, budget overruns, and delays. However, with a strategic approach, the project manager ensures the system aligns with

Discussion Question: A growing IT company, TechSolutions, decided to relocate to a larger office space to accommodate its expanding team. The project involved finding a new location, designing the wor

Discussion Question: A growing IT company, TechSolutions, decided to relocate to a larger office space to accommodate its expanding team. The project involved finding a new location, designing the workspace, and ensuring a smooth transition with minimal disruption to operations. Questions: What challenges might arise during an office relocation project,

Discussion ABC Construction Ltd. launched a traditional project to build a shopping mall in a growing urban area, planned for 18 months with a $75 million budget. The project followed a structured wat

Discussion ABC Construction Ltd. launched a traditional project to build a shopping mall in a growing urban area, planned for 18 months with a $75 million budget. The project followed a structured waterfall approach, starting with scoping, where architects, engineers, and investors outlined design, capacity, and regulatory requirements. In the

Purpose In this assignment, you’ll dive into a case study of successful team collaborations to understand what made them work well and the challenges they faced. Your task is to pick a specific projec

Purpose In this assignment, you’ll dive into a case study of successful team collaborations to understand what made them work well and the challenges they faced. Your task is to pick a specific project scenario, analyze its team dynamics, and come up with strategies to boost teamwork. You also need

**DOLL * IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!*** THERE ARE 2 PARTS PART 1: DISCUS

****DOLL**** ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** THERE ARE 2 PARTS PART 1: DISCUSSION MODULE 1 Codes of Behavior Locate a current event within the past 12 months that is related to

Purpose The goal of this Unit 2 Individual Assignment is to build on your Unit 1 Individual Assignment by assessing how your emotional intelligence supports or augments your leadership style. This ass

Purpose The goal of this Unit 2 Individual Assignment is to build on your Unit 1 Individual Assignment by assessing how your emotional intelligence supports or augments your leadership style. This assignment will also facilitate your Unit 2 Team Assignment where you will compare each other’s leadership styles and abilities

links are provided The goal of this individual assignment is to give you a sense of your own leadership style and reflect on how you might enhance your leadership skills and performance. Understa

links are provided The goal of this individual assignment is to give you a sense of your own leadership style and reflect on how you might enhance your leadership skills and performance. Understanding and reflecting on your leadership style is integral to your personal and professional development. It continues to

This assignment will enable you to use EXCEL functions to perform calculations associated with selecting projects based on various factors and criteria, some or all of which could be financial measure

This assignment will enable you to use EXCEL functions to perform calculations associated with selecting projects based on various factors and criteria, some or all of which could be financial measures like net present value, internal rate of return, payback period, etc. You will need to understand the examples on

For this journal, review the following statement, “Salespeople are born and not made.” Do you believe this statement to be true? Why, or why not?How has personal selling evolved? Your journal sho

For this journal, review the following statement, “Salespeople are born and not made.” Do you believe this statement to be true? Why, or why not? How has personal selling evolved? Your journal should consist of a minimum of three well-constructed paragraphs. Sources used, if any, should be listed and formatted