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

Reflection: This week we covered the topics of the evolution of management and different theories. Explain how you have experienced one or more of the management theories presented; whether it is in

Reflection: This week we covered the topics of the evolution of management and different theories. Explain how you have experienced one or more of the management theories presented; whether it is in the workplace or in your personal life. Describe how you are going to integrate one or more of

please see the attached documents to do this assignment since its asking for specific examples of leadership, you can talk about an internship I had at New Balance, Boston and just come up with any ex

please see the attached documents to do this assignment since its asking for specific examples of leadership, you can talk about an internship I had at New Balance, Boston and just come up with any example based on that.please let me know if you have any question.

BMGT 305 6380 Knowledge Management (2252) Week 1 Brainstorming Discussions For the next eight weeks, we will be visiting with Jane Clive the current IT department head at the Chicago North America Bra

BMGT 305 6380 Knowledge Management (2252) Week 1 Brainstorming Discussions For the next eight weeks, we will be visiting with Jane Clive the current IT department head at the Chicago North America Branch of an airline freight delivery service. Global Delivery Direct (GDD) has grown rapidly but is currently suffering stagnant growth

Unit 7 DB: Plan Implementation How will you inform and train stakeholders? How will you exercise your plan to ensure there are no gaps in capabilities? Identify the type of drill or exercise you wou

Unit 7 DB: Plan Implementation How will you inform and train stakeholders? How will you exercise your plan to ensure there are no gaps in capabilities? Identify the type of drill or exercise you would use and discuss at least one way your drill or exercise will be HSEEP compliant.

Portfolio Paper • Assignment: (330 points) See Appendix B for grading rubric o The portfolio paper covers the array of topics discussed and presented in the course and is due Saturday of Unit 7. The p

Portfolio Paper • Assignment: (330 points) See Appendix B for grading rubric o The portfolio paper covers the array of topics discussed and presented in the course and is due Saturday of Unit 7. The paper will be evaluated using the Unit Assignments and Portfolio Paper rubric (Appendix A). o

Unit 8 Final Exam: Formal Plan Presentation Overview: Create a formal presentation of your plan for a board of examiners acting as your organization’s executive level management team. Instructions:

Unit 8 Final Exam: Formal Plan Presentation Overview: Create a formal presentation of your plan for a board of examiners acting as your organization’s executive level management team. Instructions: You are required to submit a slide show of your presentation. Follow the below steps: For the PowerPoint: Create a 15-20

As a human resources manager in a health care organization, you will be asked to develop varying types of strategies and management techniques that improve the performance of your workforce. It is imp

As a human resources manager in a health care organization, you will be asked to develop varying types of strategies and management techniques that improve the performance of your workforce. It is important for you to know how to keep abreast of such strategies through research, as well as analyze

Address the checklist items below in a minimum of nine PowerPoint slides with title and reference slides. Place any notes just below the slide. Assignment Checklist: State the scenario, including the

Address the checklist items below in a minimum of nine PowerPoint slides with title and reference slides. Place any notes just below the slide. Assignment Checklist: State the scenario, including the company name, business purpose, and issue presented. Identify three ways diversity relates to competitiveness for Vibe Trend, providing supporting details

Reflection: Topic: Controlling and Leading As you reflect on what you learned this week, in your own words, explain how you view controlling as an important part of the business management process. D

Reflection: Topic: Controlling and Leading As you reflect on what you learned this week, in your own words, explain how you view controlling as an important part of the business management process. Describe how you can incorporate this concept into your current work situation and/or personal life. 400 words

Review Exhibit 15.9 from your textbook.Based on the information provided in this scenario, draft a persuasive essay that identifies what you believe will be the four most effective ways from Exhibit 1

Review Exhibit 15.9 from your textbook. Based on the information provided in this scenario, draft a persuasive essay that identifies what you believe will be the four most effective ways from Exhibit 15.9 one might manage resistance to change in implementing the new training program. Prepare an implementation plan using the four change management

I need help with this discussion for DEFM 310. Please see the instructions. I will need it by tomorrow night even it will be due until Sunday. Thank you for your help..

1. In your journal entry: What government (local, state, tribal, territorial or federal), military, public, and private partnerships would be key to preparing your plan and why? • What challenges do

1. In your journal entry: What government (local, state, tribal, territorial or federal), military, public, and private partnerships would be key to preparing your plan and why? • What challenges do you see in developing these partnerships and how would you overcome them? Requirements: • 1-2 paragraphs in length. 2.

Planning Project Part II assignment. Please see my comments within the documents and make changes. Two documents attached. one is the document that has the comments from the professor and the other i

Planning Project Part II assignment. Please see my comments within the documents and make changes. Two documents attached. one is the document that has the comments from the professor and the other is the Planning Project I submitted make the necessary correction. Pay attention to the checklist.

Volkswagen and Its Project to Cheat Emissions Tests ”Volkswagen obfuscated, they denied, and they ultimately lied.” These were the words of U.S. Attorney General Loretta Lynch, as she set out how the

Volkswagen and Its Project to Cheat Emissions Tests ”Volkswagen obfuscated, they denied, and they ultimately lied.” These were the words of U.S. Attorney General Loretta Lynch, as she set out how the German carmaker would be punished for attempting to willfully mislead U.S. authorities over the emissions produced by its

Volkswagen and Its Project to Cheat Emissions Tests ”Volkswagen obfuscated, they denied, and they ultimately lied.” These were the words of U.S. Attorney General Loretta Lynch, as she set out how the