Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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:

  1. 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).
  2. 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.
  3. 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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

FSMT405 I001 Spring 2026 Week 4 Essay The Fire Department Incident Safety Officer plays a vital role in protecting firefighters from the ever-increasing dangers they face each day. After completin

FSMT405 I001 Spring 2026 Week 4 Essay The Fire Department Incident Safety Officer plays a vital role in protecting firefighters from the ever-increasing dangers they face each day. After completing this week’s readings and conducting your research into this topic, write a paper that answers the following: 1. Discuss the

I need Single Power Point Slide that looks like a large poster – My topic is The Security Challenges/threat vectors associated with Port Security It is a single PowerPoint slide that depicts a resear

I need Single Power Point Slide that looks like a large poster – My topic is The Security Challenges/threat vectors associated with Port Security  It is a single PowerPoint slide that depicts a research question, hypothesis, Introduction/background, Literature Review Summary, Methodology (i.e., Content Analysis/Historical Perspective/ thematic Analysis, etc.), your analysis,

DISCUSSION Question: You are a business executive responsible for expanding your company into a new international market. What key factors would influence your decision-making process regarding marke

DISCUSSION Question:  You are a business executive responsible for expanding your company into a new international market. What key factors would influence your decision-making process regarding market entry strategy, organizational structure, and policy compliance? How would you balance standardization with local adaptation? In your response to your peers, explore the

️ A MESSAGE TO ACADEMIC WRITERS Many writers today are frustrated by platforms with poor support, delayed payments, limited communication, unfair commission structures, and sudden account restrictions

️ A MESSAGE TO ACADEMIC WRITERS Many writers today are frustrated by platforms with poor support, delayed payments, limited communication, unfair commission structures, and sudden account restrictions that affect their earnings and growth. That’s why we built StudyAce.net — a modern academic marketplace designed to support writers, protect their earnings,

WEEK 5 TO DO DISCUSSSION Question: Imagine your company is expanding into a new country with significantly different cultural norms and business ethics than your home country. What steps would you tak

WEEK 5 TO DO DISCUSSSION Question: Imagine your company is expanding into a new country with significantly different cultural norms and business ethics than your home country. What steps would you take to ensure your business respects the local culture and ethical expectations while maintaining your company’s core values?” To earn

WEEK 3 TO DO Questions: Tesla’s Entry into China When Tesla entered the Chinese market, it faced institutional barriers such as strict government regulations on foreign automakers and resource-based

WEEK 3 TO DO Questions: Tesla’s Entry into China When Tesla entered the Chinese market, it faced institutional barriers such as strict government regulations on foreign automakers and resource-based challenges like supply chain localization. However, Tesla mitigated its liability of foreignness by: ·       Partnering with local suppliers to establish a Gigafactory

WEEK 4 TO DO Question: Global Integration and the Auto Industry Scenario: Japan’s Toyota and Germany’s Volkswagen expand production in the United States, creating thousands of jobs while introducing

WEEK 4 TO DO Question: Global Integration and the Auto Industry Scenario: Japan’s Toyota and Germany’s Volkswagen expand production in the United States, creating thousands of jobs while introducing new technologies and efficient manufacturing practices. The U.S. benefits from increased employment, while Toyota and Volkswagen gain access to a large consumer

WEEK 2 TO DO Question: A global technology company based in Atlantis has been heavily reliant on imports of raw materials and components from foreign suppliers. However, the government has recently im

WEEK 2 TO DO Question: A global technology company based in Atlantis has been heavily reliant on imports of raw materials and components from foreign suppliers. However, the government has recently imposed higher tariffs and stricter import quotas to protect local manufacturers. While this policy aims to boost domestic production,

WEEK 1 TO DO Question: A U.S.-based technology company is expanding its operations into multiple international markets, including China, Brazil, and the European Union. However, the company faces

WEEK 1 TO DO Question:  A U.S.-based technology company is expanding its operations into multiple international markets, including China, Brazil, and the European Union. However, the company faces several challenges: In China, strict data localization laws and government regulations create barriers to digital operations. In Brazil, unpredictable regulatory changes and

Forecasting and Capacity Management Using AI Select a company (real or hypothetical) in an industry where forecasting and capacity planning are critical (e.g., retail, manufacturing, health care, airl

Forecasting and Capacity Management Using AI Select a company (real or hypothetical) in an industry where forecasting and capacity planning are critical (e.g., retail, manufacturing, health care, airlines, or logistics). Define the company’s long-range (2–5 years) planning objectives. Use an AI tool (e.g., ChatGPT, Perplexity, Gemini, CoPilot, etc.) to generate demand forecasts

Week 4 Writing Assignment After reading the Week 4 material, we know that change in the fire service is inevitable. Without change, people and organizations would become stale and unresponsive. Th

Week 4 Writing Assignment After reading the Week 4 material, we know that change in the fire service is inevitable.  Without change, people and organizations would become stale and unresponsive.  The challenge is to learn how to steer through the transition as easily and creatively as possible.  To successfully navigate the

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To earn full credit, post an initial response of 500 words that includes at least one APA citation and the

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, o

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, order management, customer service, inventory management, and facilities location interact to influence a company’s overall logistics performance?  Can you identify a real-world example where optimizing one

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Pa

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Participating in the discussion question forum provides you with an opportunity to compare your ideas

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain or you may use another company as an example). To earn full credit, post an initial response of 500

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of technology on your experience as a consumer.  To earn full credit, post an initial response of 500 words