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

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles. Choose. Choose one WSJ article from the Business, Tech, or Markets section to summa

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles. Choose. Choose one WSJ article from the Business, Tech, or Markets section to summarize. Insert the link to the article, before writing your analysis. Write. Write one paragraph on 1) What is the article about, 2)

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles. Choose. Choose one WSJ article from the Business, Tech, or Markets section to summa

Harnessing the Power of Operations and FinanceAssignment Overview Strategic Management As your final written case of class, it is time to complete all of the connections regarding how strategy is imp

Harnessing the Power of Operations and FinanceAssignment Overview Strategic Management As your final written case of class, it is time to complete all of the connections regarding how strategy is implemented in an organization and the roles of the stakeholders across functional areas. Case 3 Resources Corporate-Level Strategy Defined (2022)Implementing Corporate

Harnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting and finance f

Harnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting and finance functions support a company’s goals and help it move forward according to plan? SLP 3 Resources Contribute to an Ethical Culture (2022) DEI trends that can

Unit 6 Assignment: Hazardous Material SDSOutcomes addressed in this activity: Unit Outcomes: Complete an SDS/MSDS for hazardous materials in the workplace.Define the types of hazardous materials in th

Unit 6 Assignment: Hazardous Material SDSOutcomes addressed in this activity: Unit Outcomes: Complete an SDS/MSDS for hazardous materials in the workplace. Define the types of hazardous materials in the workplace. Discuss the importance of recognizing hazardous materials in the workplace. Explain why SDS/MSDS forms should be available for all hazardous

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Background: Airbnb began as a disruptor in

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Background: Airbnb began as a disruptor in the hospitality industry, offering unique, community-based experiences through its peer-to-peer accommodation platform. The company’s vision centered on “creating a world where anyone can

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Case Study Title: “TalentTech at TranzGlob

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Case Study Title: “TalentTech at TranzGlobal Inc.: Reshaping HR Strategy through AI” Background: TranzGlobal Inc., a multinational logistics and supply chain firm headquartered in Singapore, operates across 27

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. What are the tradeoffs between an internal

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. What are the tradeoffs between an internal and an external growth strategy? Which approach is best as an international entry strategy? Critically explore the challenges of localization vs. standardization

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Imagine you are the VP of Strategy for a g

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Imagine you are the VP of Strategy for a global corporation. You have been asked to orally present a new functional strategy to the executive team. What would

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Here’s this week’s discussion question: Ca

Discussion Question Participating in the discussion question forum provides you with an opportunity to share your experiences and learn from your colleagues. Here’s this week’s discussion question: Case Background: EcoGlow Inc., a European-based multinational consumer electronics company, has built a global reputation for sleek, energy-efficient tech products. The company’s tagline, “Powering

DISCUSSION In an era defined by digital disruption, globalization, and rapid market shifts, to what extent do classical strategic planning models like Porter’s Five Forces and the BCG Matrix remain re

DISCUSSION In an era defined by digital disruption, globalization, and rapid market shifts, to what extent do classical strategic planning models like Porter’s Five Forces and the BCG Matrix remain relevant for multinational corporations? You are expected to critically evaluate whether their structured, analytical nature is a strength or a

In this paper, you will conduct an external analysis of CVS Health, based on the case reading you have been assigned. This paper will focus briefly on an introduction that discusses the political, eco

In this paper, you will conduct an external analysis of CVS Health, based on the case reading you have been assigned. This paper will focus briefly on an introduction that discusses the political, economic, social, technological, and legal forces that are impacting the company. Then you will conduct a five-forces

A Straightforward Note to Fellow Academic Writers Hi everyone, I want to be upfront about my experience on Studydaddy.com. Payment delays of up to 60 days, unclear deductions, and a lack of transparen

A Straightforward Note to Fellow Academic Writers Hi everyone, I want to be upfront about my experience on Studydaddy.com. Payment delays of up to 60 days, unclear deductions, and a lack of transparency made it frustrating to work there. As writers, our time and expertise deserve clear terms and fair

ACADEMIC WRITERS — PLEASE READ THIS If you’re still working on Studydaddy.com, I urge you to pause and seriously reconsider. Speaking from personal experience, I invested time, skill, and dedication i

ACADEMIC WRITERS — PLEASE READ THIS If you’re still working on Studydaddy.com, I urge you to pause and seriously reconsider. Speaking from personal experience, I invested time, skill, and dedication into completing orders — only to face reduced earnings, long payout delays, and constant uncertainty. Delivering quality work should never

A Professional Notice to Academic Writers This message is intended for writers currently working on Studydaddy.com. Based on my personal experience, I encountered several challenges related to payment

A Professional Notice to Academic Writers This message is intended for writers currently working on Studydaddy.com. Based on my personal experience, I encountered several challenges related to payment transparency, deductions, and processing timelines. After completing and delivering assignments, only a portion of my earnings became withdrawable, with payment timelines extending

Module 2 – CaseStrategic Advantage: Analytics and EconomicsAssignment Overview Economic Implications of Organizational Strategies Most college students take at least one undergraduate economics class

Module 2 – CaseStrategic Advantage: Analytics and EconomicsAssignment Overview Economic Implications of Organizational Strategies Most college students take at least one undergraduate economics class, which they often quickly forget. When the pandemic created a global economic event, the lessons of that class became more critical as businesses navigated uncertain circumstances.

Module 2 – SLPStrategic Advantage: Analytics and EconomicsAssignment Overview Data Analytics and Strategic Decision-Making Your study of Business Analytics and Decision Making may seem long ago, but y

Module 2 – SLPStrategic Advantage: Analytics and EconomicsAssignment Overview Data Analytics and Strategic Decision-Making Your study of Business Analytics and Decision Making may seem long ago, but you’ve been building onwhat you learned throughout the program. That will not stop even after you’ve hung the diploma on your wall. Session

Unit 4 Assignment: OSHA 300 Log and 301 ReportOutcomes addressed in this activity: Unit Outcomes: Associate safety rules and regulations related to reporting injuries or illnesses in the workplace.Com

Unit 4 Assignment: OSHA 300 Log and 301 ReportOutcomes addressed in this activity: Unit Outcomes: Associate safety rules and regulations related to reporting injuries or illnesses in the workplace. Complete the OSHA 300 Log and 301 Injury Report for a workplace injury. Discuss the OSHA 300 Log and 301 Injury