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

Introduction During the course of your MBA program, you developed a number of competencies that are meaningful in the workplace. Reflecting on your competencies, how they helped you during your progra

Introduction During the course of your MBA program, you developed a number of competencies that are meaningful in the workplace. Reflecting on your competencies, how they helped you during your program and the business simulation, and how they will support your career as you move forward is an appropriate transitional

TABLEU user only !!! Just need Tableau visuals 3-1 MBA 699 Guidelines and Rubric Scenario You are a business development manager reporting to the vice president (VP) of business development at one o

TABLEU user only !!! Just need Tableau visuals 3-1 MBA 699 Guidelines and Rubric Scenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. You are working with the strategic planning team to assess

DISCUSSION Your goal for this activity is to provide a summary involving: The biggest or most important point from the course you found interesting and enjoyed.One lesson you wish others to learn from

DISCUSSION Your goal for this activity is to provide a summary involving: The biggest or most important point from the course you found interesting and enjoyed. One lesson you wish others to learn from the point. To earn full credit, post an initial response of a minimum of 500 words

6-2MBA 699 Report: Risk Analysis MBA 699 Module Six Report Guidelines and RubricOverview In your role as a business development manager involved in preparing an exit strategy for the life science org

6-2MBA 699 Report: Risk Analysis MBA 699 Module Six Report Guidelines and RubricOverview In your role as a business development manager involved in preparing an exit strategy for the life science organization, you learned that employee attrition is one of the key risks to the proposed acquisition. In Milestone Two,

China and home country is US 3 pages Describe at least two management positions that will require training for in-country positions. The description must include the identification of cultural, ling

China and home country is US 3 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 home

Before you begin your assignment for this unit, review the previous activities you completed in this course: In Unit I you selected and discussed a firm with global operations. You provided a corpo

Before you begin your assignment for this unit, review the previous activities you completed in this course: In Unit I you selected and discussed a firm with global operations. You provided a corporate profile and perceptions of the firm and examined its global strategy. In Unit III you conducted an

This assignment will help you develop strategic decision-making skills crucial for global business management and the successful expansion of multinational enterprises into new markets. It will also a

This assignment will help you develop strategic decision-making skills crucial for global business management and the successful expansion of multinational enterprises into new markets. It will also assess your ability to analyze and recommend strategic decisions for a multinational enterprise (MNE) considering expansion into a new global market outside of

* 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 Power

***** 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 Power Base(s) Discuss the following: Leadership and power are interrelated. From this week’s readings, define the different

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the week’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 week’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 Question: E-commerce is creating a new economy that connects producers, sellers, and customers via technology in ways that have never been possible before. In this fast-paced world of e-com

Discussion Question: E-commerce is creating a new economy that connects producers, sellers, and customers via technology in ways that have never been possible before. In this fast-paced world of e-commerce, size no longer matters as much as speed and flexibility. The Internet is creating a new industrial order, and companies that

5-3 HRM 630 Short Paper: In your short paper, explore the long-lasting impact of EMTALA on cost, quality, and access. How does culture and ethnicity impact emergency care under this law? Briefly explo

5-3 HRM 630 Short Paper: In your short paper, explore the long-lasting impact of EMTALA on cost, quality, and access. How does culture and ethnicity impact emergency care under this law? Briefly explore the pros and cons of this legislation. Case Study Guidelines and RubricWhat to Submit Submit the assignment

5-2 HRM 630 Journal Guidelines and Rubric Review the Your Insurance Company & Costs of Coverage website(https://companyprofiles.healthcare.gov/). Enter your home state, NJ, and the surrounding sta

5-2 HRM 630 Journal Guidelines and Rubric Review the Your Insurance Company & Costs of Coverage website( Enter your home state, NJ, and the surrounding states, NY,PA, and DE, and determine if any insurance companies are increasing their rates above the recommended threshold. Report your findings. Approach these Journal activities as an opportunity to reflect

5-2 IHP 600 Case Study: Kleiner and Genentech (2012): When Venture Capital Met Science Using the link Harvard Business Publishing found in your course Table of Contents, read the case study Kleiner-P

5-2 IHP 600 Case Study: Kleiner and Genentech (2012): When Venture Capital Met Science Using the link Harvard Business Publishing found in your course Table of Contents, read the case study Kleiner-Perkins and Genentech (2012) When Venture Capital Met Science, and write a paper analyzing the case. IHP 600 Case

5-1 MBA 699 Guidelines and RubricScenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the M

5-1 MBA 699 Guidelines and RubricScenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. The owners are ready to sell the organization and have identified a potential buyer. You have been working

4-2 HRM-630 Short Paper: Health Care Workforce and the Aging Population Do you think that the health care workforce of today is effectively meeting the needs of the aging population? What about 5 year

4-2 HRM-630 Short Paper: Health Care Workforce and the Aging Population Do you think that the health care workforce of today is effectively meeting the needs of the aging population? What about 5 years from now, or 10 years from now? What changes will need to occur to ensure that

4-1 MBA 699 Guidelines and RubricScenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the

4-1 MBA 699 Guidelines and RubricScenario You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest. You are working with the strategic planning team to assess the current data to make recommendations to its

MBA 699 Module. 3-1 Report: Potential Alternative Buyers/Competitor Research ListenMBA 699 Module Three Report Guidelines and Rubric Overview You are a business development manager for a life scien

MBA 699 Module. 3-1 Report: Potential Alternative Buyers/Competitor Research ListenMBA 699 Module Three Report Guidelines and Rubric Overview You are a business development manager for a life sciences organization in the Midwest that has recently found great success through its new cancer treatment drugs. You are part of the

WEEK 3 TO DO DISCUSSION Describe the three types of franchising: trade name, product distribution, and pure. Which type of franchising do you think is best and why? Remember to cite your sources! To e

WEEK 3 TO DO DISCUSSION Describe the three types of franchising: trade name, product distribution, and pure. Which type of franchising do you think is best and why? Remember to cite your sources! To earn full credit, post an initial response of a minimum of 500 words that includes at