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

For this final week, you will write a comprehensive APA analysis paper using all of the information and knowledge you have gained in the Management for Law Enforcement course. It is important that you

For this final week, you will write a comprehensive APA analysis paper using all of the information and knowledge you have gained in the Management for Law Enforcement course. It is important that you meet the 1275 minimum word count requirement and the three or more 7th APA scholarly source

Describe intelligence-led policing, contrasting it with community policing and problem-oriented policing. Please ensure to include a minimum of 250 words in your initial response and provide two or mo

Describe intelligence-led policing, contrasting it with community policing and problem-oriented policing. Please ensure to include a minimum of 250 words in your initial response and provide two or more scholarly sources in APA 7th edition with VALID URL sources and in text citations to support your response.

MBA 699 Module Eight Memo Guidelines and RubricOverview You are a part of the strategic planning team. Your team will communicate the analysis and recommendations in a compelling report for the board

MBA 699 Module Eight Memo Guidelines and RubricOverview You are a part of the strategic planning team. Your team will communicate the analysis and recommendations in a compelling report for the board of directors. The report will also outline a change management strategy. To measure the success of your change

Week 6 to do Discussion Reflecting on what you have learned in the course share an example of how a government or world leader could have used ERM to respond to one of the financial, operational, or g

Week 6 to do Discussion Reflecting on what you have learned in the course share an example of how a government or world leader could have used ERM to respond to one of the financial, operational, or governance aspects of the pandemic. In addition, share an example where ERM was

Discussion Imagine you are facilitating a board meeting for the real or fictional company that you selected for your weekly assignments. The board has gathered to hear specific insights regarding D&am

Discussion Imagine you are facilitating a board meeting for the real or fictional company that you selected for your weekly assignments. The board has gathered to hear specific insights regarding D&O insurance. Describe the ethical guidelines surrounding this process for your industry. How can the company use industry norms for

Discussion By now you have seen how complex and nuanced Enterprise Risk Management (ERM) is in both nature and operational execution. Read the article, Beyond good intentions: Navigating the ethical d

Discussion By now you have seen how complex and nuanced Enterprise Risk Management (ERM) is in both nature and operational execution. Read the article, Beyond good intentions: Navigating the ethical dilemmas facing the technology industry, and discuss the following questions: How can technology companies use ERM to overcome the ethical dilemmas

MBA 699 Project !!! Most information for the project will be provided! ATTENTION – I will add all tasks and milestones completed earlier. Needs to be put in one project!!! !!! Most information f

MBA 699 Project !!! Most information for the project will be provided! ATTENTION – I will add all tasks and milestones completed earlier. Needs to be put in one project!!! !!! Most information for the project will be provided! ATTENTION – I will add all tasks and milestones

Explain the difference between managing and leading. Please ensure to include a minimum of 250 words in your initial response and provide two scholarly sources in APA 7th edition with valid URL source

Explain the difference between managing and leading. Please ensure to include a minimum of 250 words in your initial response and provide two scholarly sources in APA 7th edition with valid URL sources to support your response.

IntroductionAfter completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a written report, using the attac

IntroductionAfter completing the business simulation at a competent level (a score above 0.000 for the cumulative total performance at the end of Q6), you will create a written report, using the attached “Business Analysis Template,” for stockholders and the board of directors to review. Analyze the decisions throughout the simulation

Discussion Risk profiles help individuals in power understand sources of risk in relation to goals or objectives during a period of time. Governmental leaders are currently challenged by cryptocurrenc

Discussion Risk profiles help individuals in power understand sources of risk in relation to goals or objectives during a period of time. Governmental leaders are currently challenged by cryptocurrency, unsure how to approach or navigate it. Discuss the risk profile and appetite of cryptocurrency. How can governmental leaders improve their

Discussion Over the course of the week, you have explored several factors which influence the approaches to managing risk a firm will take. With these insights in mind, read the following article: Big

Discussion Over the course of the week, you have explored several factors which influence the approaches to managing risk a firm will take. With these insights in mind, read the following article: Big business bosses are warning that supply chain issues and inflation are here to stay. After reading the article,

Discussion Read the abstract in this article: “Practical ethical challenges and moral distress among staff in a hospital COVID-19 screening service.” Using insights from this week’s readings, share an

Discussion Read the abstract in this article: “Practical ethical challenges and moral distress among staff in a hospital COVID-19 screening service.” Using insights from this week’s readings, share an ERM strategy you think can help the healthcare industry move forward. Explain why you are recommending this strategy, the framework you

!!! Most information for the project will be provided! ATTENTION – I will add all tasks and milestones completed earlier. Needs to be put in one project!!! MBA 699 Project Guidelines and RubricCompe

!!! Most information for the project will be provided! ATTENTION – I will add all tasks and milestones completed earlier. Needs to be put in one project!!! MBA 699 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Manage stakeholder relationships to sustain

7-1 MBA699 Case Analysis: Postmerger Integration MBA 699 Module Seven Case Analysis Guidelines and RubricOverview An important aspect of a change management strategy is to consider how different alte

7-1 MBA699 Case Analysis: Postmerger Integration MBA 699 Module Seven Case Analysis Guidelines and RubricOverview An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the business case method to explore strategic alternatives as it helps simulate a real

*** 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 4 Rel **

***** 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 4 Rel ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE

* 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 4 Rel

***** 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 4 Relevant Leadership for Climate Change Climate change is a complex global problem that will require a collaborative

MBA 699 Module Six Assignment Guidelines and Rubric Overview As part of the contingency planning for your organization’s exit strategy, you have researched and analyzed a potential alternative buyer.

MBA 699 Module Six Assignment Guidelines and Rubric Overview As part of the contingency planning for your organization’s exit strategy, you have researched and analyzed a potential alternative buyer. As the possibility increases that the original buyer will withdraw from the deal, your VP has asked you to create a

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