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

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that prioritize open communication, mutual respect, a

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that prioritize open communication, mutual respect, and shared decision-making. **Complete SLP 2 before Case 2** Session Long Project 2 Resources Servant Leadership (2023)Understanding The Role Of Team Dynamics To Make A Healthy Work Environment (2023)Leadership and teamwork dynamics:

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person,

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person, require a leader adept at understanding varied departmental perspectives, bridging knowledge gaps, and facilitating effective collaboration across specialties. **Complete SLP 2 before Case 2** Case

Instructions Assignment 7: Week 7: Research two articles in the library or on the web that pertains to Cost Analysis & Negotiation Techniques software that demonstrates how Cost Analysis &

Instructions Assignment 7: Week 7: Research two articles in the library or on the web that pertains to Cost Analysis & Negotiation Techniques software that demonstrates how Cost Analysis & Negotiation Techniques software is used to plan, implement, control and report on Cost Analysis & Negotiations. You will be required

The objective of this assignment is to research and prepare a paper on a current issue involving casinos and gaming. Course Topics and Considerations The scope of the paper should follow an event or e

The objective of this assignment is to research and prepare a paper on a current issue involving casinos and gaming. Course Topics and Considerations The scope of the paper should follow an event or events that are of importance within this field. Some relevant topics that can be chosen are

“In the context of a rapidly changing global market, how can businesses effectively balance the pursuit of innovation with the need for operational stability, while also ensuring ethical practices and

“In the context of a rapidly changing global market, how can businesses effectively balance the pursuit of innovation with the need for operational stability, while also ensuring ethical practices and corporate social responsibility are upheld?”

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivat

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivators (which can boost satisfaction when present). You will provide insights into motivation for a multi-generational workforce. Using the framework of McGregor’s Theory X and Theory

Module 1 – SLPPersonality and MotivationAssignment OverviewMotivation and Feedback Styles Transformational leaders inspire and elevate followers, transactional leaders focus on exchanges and clear exp

Module 1 – SLPPersonality and MotivationAssignment OverviewMotivation and Feedback Styles Transformational leaders inspire and elevate followers, transactional leaders focus on exchanges and clear expectations, while laissez-faire leaders adopt a hands-off approach. In a crisis, motivation often hinges on urgency and adaptability. Leaders must inspire confidence, provide clear direction, and foster

Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzing the organizat

Organization Analysis & Strategic Recommendations SCENARIO: Select an organization you are familiar with or have worked for (currently or in the past). You are tasked with analyzing the organization both internally and externally using some of the tools and frameworks you have learned in this course. You are also tasked with

nstructionsRough Draft of the Final Research Project Submit your rough draft for feedback. The Final Research Project will be 20-25 pages and due in week 8. The project must include a title page,

nstructionsRough Draft of the Final Research Project Submit your rough draft for feedback. The Final Research Project will be 20-25 pages and due in week 8. The project must include a title page, table of contents, abstract, and a reference page. The project will demonstrate the knowledge acquired through course

Refer to this week’s reading and answer all questions in MS Word document and submit it. link for reading : http://www.casino.org/features/gambling-statistics/ Why is gambling considered a science?

Refer to this week’s reading and answer all questions in MS Word document and submit it. link for reading : http://www.casino.org/features/gambling-statistics/ Why is gambling considered a science? Identify and compare each statistical method and its use. Grading Rubric for Week 7 Questions CategoryPointsWeightingDescriptionContent 45 80%All key elements of the assignment are

Describe at least two management positions that will require training for in-country positions in a three page paper, not counting the cover and reference pages. . The description must include the ide

Describe at least two management positions that will require training for in-country positions in a three page paper, not counting the cover and reference pages. . The description must include the identification of cultural, linguistics and specialized skills needed for the positions. Culturally, describe differences, such as management styles between

Video Journal – Public Alert Message Overview: Assume you are the public affairs officer for Eagles County ESF-15. Discuss public alert messaging for a COVID-19/Pandemic testing or vaccination event

Video Journal – Public Alert Message Overview: Assume you are the public affairs officer for Eagles County ESF-15. Discuss public alert messaging for a COVID-19/Pandemic testing or vaccination event or point of distribution in Eagles County. Briefly discuss what information you would provide for individuals, families, businesses to help them

Using the Fusion Center website https://www.dhs.gov/fusion-center-locations-and-contact-information Identify a center that serves your state. > (State of Connecticut) Describe the fusion center.Lis

Using the Fusion Center website https://www.dhs.gov/fusion-center-locations-and-contact-information Identify a center that serves your state. > (State of Connecticut) Describe the fusion center. List the participating agencies and describe their mission and functions. Explain how the center contributes to information sharing in that state.

Unit 8 DB: Grant Budget Briefly discuss your grant proposal budget for the benefit of your classmates. Identify at least two concerns you had with composing your budget.

Course Project: Grant Proposal Presentation Overview: Using the format provided, create a PowerPoint (or similar) presentation on a grant proposal application you are tasked with submitting for an Op

Course Project: Grant Proposal Presentation Overview: Using the format provided, create a PowerPoint (or similar) presentation on a grant proposal application you are tasked with submitting for an Opioid Overdose Response program. Assume you are working for a 100-member public safety agency (police or fire service) within your community and

Online Gaming Analysis Refer to the article and this week’s reading and answer all questions in MS Word document and submit it. This assignment should be at least 2 pages in length and in APA format.

Online Gaming Analysis Refer to the article and this week’s reading and answer all questions in MS Word document and submit it. This assignment should be at least 2 pages in length and in APA format. Read the article, Mohegan Sun Hotel and Casino Uncasville, ConnecticutLinks to an external site.Open this

6-2 Short Paper: How Culture and Ethical Frameworks Affect Perceptions of War, Conflict, and Peace

6-1 Discussion: The Geneva Conventions The Geneva Conventions are an attempt at creating a separate, rules-based global ethical framework. In this discussion, you will explain the purpose of the Gene

6-1 Discussion: The Geneva ConventionsThe Geneva Conventions are an attempt at creating a separate, rules-based global ethical framework. In this discussion, you will explain the purpose of the Geneva Conventions and examine a part of the conventions that resonates with your personal ethics. Discussing the Geneva Conventions with your peers