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

Utilizing ima topic within the realm of Homeland Security, Emergency Management, or Criminal Justice. Please explain your capstone project to include how you intend to pursue your project. Include you

Utilizing ima topic within the realm of Homeland Security, Emergency Management, or Criminal Justice. Please explain your capstone project to include how you intend to pursue your project. Include your research question. A refined research question will provide a solid foundation from which to conduct your research. Please provide constructive

Referencing the State of Kansas contract, you will find this is an IDIQ contract. Which other contract type could have been used for this contract? What are the pro and cons of the contract type you i

Referencing the State of Kansas contract, you will find this is an IDIQ contract. Which other contract type could have been used for this contract? What are the pro and cons of the contract type you identified? Your paper should be no less than 3 pages. Be specific in your

Case Study #3: Jose Padilla case involving radiological bomb plot, March 2002 Jose Padilla, also known as Ibrahim, or Abdullah al-Muhajir is an interesting case of an individual who seeks notoriety an

Case Study #3: Jose Padilla case involving radiological bomb plot, March 2002 Jose Padilla, also known as Ibrahim, or Abdullah al-Muhajir is an interesting case of an individual who seeks notoriety and fame while being manipulated at the hands of others. This case is probably more remembered as an example

Unit 5: Research Paper Assignment 5Start Assignment Due Saturday by 11:59pmPoints 100Submitting a file uploadSubmit by Saturday 11:59 p.m. Prompt: Analyze the effectiveness of problem-based learning

Unit 5: Research Paper Assignment 5Start Assignment Due Saturday by 11:59pm Points 100 Submitting a file upload Submit by Saturday 11:59 p.m. Prompt: Analyze the effectiveness of problem-based learning and case studies in developing healthcare quality management competencies. Examine how this educational approach aligns with biblical principles of wisdom, stewardship, and community learning. Requirements:

In no less than 3 pages, identify the two (2) most important guiding principle competencies (Standards of Conduct, Regulatory Compliance, Contract Principles, Communication and Documentation, Skills a

In no less than 3 pages, identify the two (2) most important guiding principle competencies (Standards of Conduct, Regulatory Compliance, Contract Principles, Communication and Documentation, Skills and Roles, Situational Assessment, or Team Dynamics) from chapter 5 that are applicable to the article OTA ACCOUNTABILITY: The Cleansing Power of F.I.R.E. (beginning on page 50

MBA 620 Milestone One Guidelines and RubricScenario You are a former pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at seve

MBA 620 Milestone One Guidelines and RubricScenario You are a former pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the southeast part of the United States. Your division’s private charter clients include several

Biological Welfare Agent Overview: In this unit, you will finish working on your course project (Biological Welfare Agent). All your research and focus for this course project will be taking on the r

Biological Welfare Agent Overview: In this unit, you will finish working on your course project (Biological Welfare Agent). All your

MBA 620 Module Four Business Environment Analysis Report Guidelines and RubricOverview In your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible

MBA 620 Module Four Business Environment Analysis Report Guidelines and RubricOverview In your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible acquisition of the two identified small airlines in the Caribbean specializing in chartered flights for luxury vacations using light aircraft (60

MBA 580 Module Four Flowchart Presentation Guidelines and RubricOverview In Milestone One, you recommended an innovation approach (incremental or discontinuous) to your organization for implementing I

MBA 580 Module Four Flowchart Presentation Guidelines and RubricOverview In Milestone One, you recommended an innovation approach (incremental or discontinuous) to your organization for implementing IoT into its product line. Now that senior management of your company has approved your recommendation, your task as a middle manager for one of

C204 MANAGEMENT COMMUNICATION ScenarioYou are a manager for Merrilton Robotics and will soon be onboarding new employees in your department. You need to evaluate communication strategies and methods

C204 MANAGEMENT COMMUNICATION ScenarioYou are a manager for Merrilton Robotics and will soon be onboarding new employees in your department. You need to evaluate communication strategies and methods, provide a presentation for new employees based on your findings, and create an executive summary of your presentation. RequirementsMicrosoft Files Note: Write your

c204 Management communication Introduction As a business manager, you may encounter situations that require a wide variety of communication responses. For this assessment, you will be creating a portf

c204 Management communication Introduction As a business manager, you may encounter situations that require a wide variety of communication responses. For this assessment, you will be creating a portfolio of communication documents. Please appropriately format each communication for the message type. Scenario Scenario 1 You are a manager of a

Read the case 2 file (found in the files tab of canvas). 2.Follow the outline and guidelines for the case write-up shown in the syllabus (Pg. 9) and write a case analysis. Please develop your paper

Read the case 2 file (found in the files tab of canvas). 2.Follow the outline and guidelines for the case write-up shown in the syllabus (Pg. 9) and write a case analysis. Please develop your paper 1.Read the case 2 file (found in the files tab of canvas). 2.Follow the

Task: 1.Read the case 2 file (found in the files tab of canvas). 2.Follow the outline and guidelines for the case write-up shown in the syllabus (Pg. 9) and write a case analysis. Please develop your

Task: 1.Read the case 2 file (found in the files tab of canvas). 2.Follow the outline and guidelines for the case write-up shown in the syllabus (Pg. 9) and write a case analysis. Please develop your paper based on those guidelines. Please use different section headings based on the guidelines

read the case study and answer the questions at the bottom of it. After reading the case study, answer these 2 points. Your recommended actions and potential consequencesA summary section in which you

read the case study and answer the questions at the bottom of it.After reading the case study, answer these 2 points. Your recommended actions and potential consequences A summary section in which you conclude with your own personal observations and thoughts.

In no less than 2 pages, explain which business management competency is the most important and why? Be sure to defend your answer and provide examples.There are several certifications for both contra

In no less than 2 pages, explain which business management competency is the most important and why? Be sure to defend your answer and provide examples. There are several certifications for both contract managers and project managers. Are these certifications important to the success of an individual or team? In

C200 managing organizations and leading people THE ORGANIZTION CAN EITHER BE BURGER KING OR THE UNITED STATES MARINE CORPS For this task, you will write a paper on an existing organization w

C200 managing organizations and leading people *****THE ORGANIZTION CAN EITHER BE BURGER KING OR THE UNITED STATES MARINE CORPS***** For this task, you will write a paper on an existing organization with which you have had personal experience. The organization can be a business or a nonprofit, and you may

Unit 4: Research Paper Assignment Prompt: Analyze how organizational culture impacts the implementation of healthcare quality management initiatives, considering the role of leadership, interprofessi

Unit 4: Research Paper Assignment Prompt: Analyze how organizational culture impacts the implementation of healthcare quality management initiatives, considering the role of leadership, interprofessional teams, and change management models in overcoming cultural barriers. Research Questions (select one) How does the implementation of a just culture framework influence patient safety outcomes in

Unit 3: Research Paper Assignment Prompt: The Integration of Lean Six Sigma in Healthcare Quality Management: A Biblical Perspective on Excellence and StewardshipAnalyze the integration of Lean and S

Unit 3: Research Paper Assignment Prompt: The Integration of Lean Six Sigma in Healthcare Quality Management: A Biblical Perspective on Excellence and Stewardship Analyze the integration of Lean and Six Sigma methodologies in modern healthcare settings, examining their effectiveness in reducing waste, improving quality, and enhancing patient care. Compare these