Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Overview 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 skil

Overview

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. 

Scenario

You have been hired as a consultant by TC Ice Cream. As part of its expansion plan, TC Ice Cream wants to limit the number of flavors that they sell and only focus on those that are the most profitable. You will do an analysis of two flavors for a specific division and determine which flavor should be kept and which should be removed.

  • Option A: Keep Flavor One
  • Option B: Keep Flavor Two

The TC Ice Cream management team has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the monthly advertising expense of $5,000. Use the division that you selected in Module Two and select two flavors to make your recommendation. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions.

  • You will use the same division and the same two flavors throughout the remainder of the course.
  • Keep in mind that the “WEST NORTH CENTRAL” division cannot be used for your analysis.

Your work here in Phase One is to do a current trend analysis, which will help you test your initial hypothesis as to which ice cream flavor has the most sales. You will use the work here as a foundation for Phase Two (in Milestone Two). 

Once you have completed the visualizations for the two flavors you selected, you will create a PowerPoint presentation analyzing the data.

Prompt

For this assignment, you will analyze the data from the TC Ice Cream data set and identify trends and patterns. You will submit an analysis report in the form of a PowerPoint presentation. You will also create multiple charts to present the descriptive analysis you performed.

Within the TC Ice Cream Excel Workbook, you will use the sheets “Flavor One Analysis” and “Flavor Two Analysis” to create your visualizations. Select two flavors within the division you selected in Module Two.

Complete the following visualizations for each flavor. The visualizations for Flavor One should be completed in the “Flavor One Analysis” sheet and the visualizations for Flavor Two should be completed in the “Flavor Two Analysis” sheet. It is recommended that you use pivot table filtering to filter the data to the specific division and flavor you have selected.

Specifically, you must address the following rubric criteria:

  • Excel Workbook
    • Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
    • Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations.
      • 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 line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
      • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and Advertising expenditures (line – secondary axis).
      • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and total – Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
      • Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the quantity sold data.
      • Create a histogram for the quantitative variable Flavor Rating. It is recommended to use the data analysis “add-in” and the analysis tool “Histogram” to create the data for the visualization.
  • PowerPoint Presentation Using the Milestone One PowerPoint Template, complete the following:
    • Outliers: Identify any outliers that you see and explain how they have an impact on the overall trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
    • Analysis: Form and explain your initial hypothesis based on your analysis of the charts and trends in Excel.
      • Analyze the histogram of the flavor ratings for each flavor you selected.
      • Which option (Option A or Option B) would you choose at this point in your analysis, given the monthly expense of $5,000?
      • Why did you choose your selected attributes?
      • Describe any relationships or trends you observed while conducting your analysis.
      • Your presentation should include key visualizations and analysis to support your report.

What to Submit

  • TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Flavor One Analysis” and “Flavor Two Analysis” sheets. Do not remove any sheets from the workbook.
  • PowerPoint Presentation: Submit a PowerPoint presentation using the Milestone One PowerPoint Template.  Any sources should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Develop an Organizational Development Report for Management During this unit, you will submit your final project. You will use the organization chosen in Unit I (The United States Army) to finalize an

Develop an Organizational Development Report for Management During this unit, you will submit your final project. You will use the organization chosen in Unit I (The United States Army) to finalize and complete the organizational development (OD) for your management team. During Unit VI, you prepared an outline of your

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured. It should reflect the results of your independent research of

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured within the army. It should reflect the results of your independent research of The United States Army. Within the essay, be sure to include the following elements: ·       

PowerPoint Presentation Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For thi

PowerPoint Presentation Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentation, you will choose one of these companies to research. For your research, you will discover what data collection methods

Module 2 – SLPVirtue Ethics and Critical ThinkingAssignment OverviewDiversity, Inclusion, and Virtue Ethics Diversity and Inclusion (D&I) refers to organizational strategies that promote represent

Module 2 – SLPVirtue Ethics and Critical ThinkingAssignment OverviewDiversity, Inclusion, and Virtue Ethics Diversity and Inclusion (D&I) refers to organizational strategies that promote representation and participation of various groups, backgrounds, and perspectives. D&I emphasizes recognizing and valuing differences, ensuring environments where all individuals feel valued, respected, and have equal opportunities.

During this unit, we focused on the costs and benefits of human resource development (HRD) programs. These programs are often designed to help the entire organization reach its goals, but HR leaders a

During this unit, we focused on the costs and benefits of human resource development (HRD) programs. These programs are often designed to help the entire organization reach its goals, but HR leaders also create these programs to help their department to reach its goals and metrics. For this unit’s assignment,

The topic of this paper will address the issue of human resource (HR) alignment with The United States Army’s strategic plan. It should reflect the results of your independent research (US Army). In y

The topic of this paper will address the issue of human resource (HR) alignment with The United States Army’s strategic plan. It should reflect the results of your independent research (US Army). In your paper, be sure to include the elements listed below. –        Explain the payoff from enhanced selection

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured within the army. It should reflect the results of your independ

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured within the army. It should reflect the results of your independent research of The United States Army. Within the essay, be sure to include the following elements: ·       

Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentatio

Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentation, you will choose one of these companies to research. For your research, you will discover what data collection methods were used

Organizational Analysis and Feedback This assignment will be used as a precursor to the final project. You will continue to use the organization chosen in Unit I- US Army. To begin this assignment, yo

Organizational Analysis and Feedback This assignment will be used as a precursor to the final project. You will continue to use the organization chosen in Unit I- US Army. To begin this assignment, you will collect the necessary data in order to find out more information about the organization’s problem,

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As generations change, businesses must adapt to d

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As generations change, businesses must adapt to diverse ethical priorities, and foster cross-generational collaboration for sustainable success. Complete SLP 2 before Case 2 Case 2 ResourcesText: 5.2 Business Ethics over Time (2023)  Text: 11.1 Business Ethics

BA 504 Module Four Excel Workbook Guidelines and RubricOverview Bivariate regression analysis is an excellent tool to help you answer questions about a business. When you use bivariate analysis, you c

BA 504 Module Four Excel Workbook Guidelines and RubricOverview Bivariate regression analysis is an excellent tool to help you answer questions about a business. When you use bivariate analysis, you can discover whether there is a strong correlation between a dependent and an independent variable. In this scenario, you will

Assignment Planning for Effective Communication and Feedback Analysis You will continue to use the organization chosen in Unit I- US Army. This unit’s assignment focuses on the plan for the assessment

Assignment Planning for Effective Communication and Feedback Analysis You will continue to use the organization chosen in Unit I- US Army. This unit’s assignment focuses on the plan for the assessment and the reasons for engaging the employees during the assessment. To begin this assignment, you will describe an issue

Reflection Paper #3 : What is more important to you – a high paying career or a motivating career? Single-spaced, Between 550-600 words (no longer than 600 words and no shorter than 550 words). Essa

Reflection Paper #3 : What is more important to you – a high paying career or a motivating career? Single-spaced, Between 550-600 words (no longer than 600 words and no shorter than 550 words). Essay format- ie., not point form. However, you don’t need a thesis statement nor introduction nor conclusion. i,e. your

Prepare a full sentence outline for research paper about customer service. The outline should include a cover page and list of references. The outline should be a minimum of two double-spaced pages (n

Prepare a full sentence outline for research paper about customer service. The outline should include a cover page and list of references. The outline should be a minimum of two double-spaced pages (not counting cover and references).  The purpose of the outline is to help you establish the organization of your final

Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, cust

Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they receive relevant information and develop a positive attitude to

For the marketing plan assignment you are going to develop Part C of the strategic marketing plan. Be sure you include detailed research, information, and analysis to present the assignment’s require

For the marketing plan assignment you are going to develop Part C of the strategic marketing plan.  Be sure you include detailed research, information, and analysis to present the assignment’s requirements. The strategic marketing plan should clearly state the chosen market and target audiences. Note: Information within tables can be single-spaced. The rest

Managing and optimizing brand equity is one of the long-term goals of any organization and thus it is a joint responsibility of all the functional departments. Brand equity is the set of assets linked

Managing and optimizing brand equity is one of the long-term goals of any organization and thus it is a joint responsibility of all the functional departments. Brand equity is the set of assets linked to the brand. These assets include brand awareness, brand loyalty, and brand associations. Appropriate alignment of