Our Services

Get 15% Discount on your First Order

[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

Related Questions

Discussion Thread: External Environment, Power / Weakness, and Decision Models Evaluating the external environment that the company does business in is critical to the process of developing a company’

Discussion Thread: External Environment, Power / Weakness, and Decision Models Evaluating the external environment that the company does business in is critical to the process of developing a company’s strategy. When evaluating the external environment, it is important to understand key sources of power or weakness that exist. Decision models

CHRISTIAN WORLDVIEW IN STRATEGIC HR AND EMPLOYMENT LAW ASSIGNMENT INSTRUCTIONS INSTRUCTIONS Write a 1,500-word paper that applies, reflects, and synthesizes the following questions: 1. What does Kelle

CHRISTIAN WORLDVIEW IN STRATEGIC HR AND EMPLOYMENT LAWASSIGNMENT INSTRUCTIONSINSTRUCTIONSWrite a 1,500-word paper that applies, reflects, and synthesizes the following questions:1. What does Keller mean when he claims that work is intended for both “cultivation” andfor “service?” Why are both purposes critical for us to consider as Christian businesspractitioners and academics?

Hi, these are 4 Discussion posts that need responses with the minimum of 175 words. Each response must be written in your own words with references included. No AI or plagiarism, please! 1. Unemployme

Hi, these are 4 Discussion posts that need responses with the minimum of 175 words. Each response must be written in your own words with references included. No AI or plagiarism, please! 1. Unemployment affects individuals, families, and communities in different ways. Unemployed adults and their families are vulnerable to

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real World A commodity is the focus of this case which uses real data for price fluctuations over 6 months. Y

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You will research reasons for the changes and develop a multifaceted economic analysis. Case 1 Resources Introduction to

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s direction in the business environment. When evaluating

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s direction in the business environment. When evaluating strategic choices, it is important to understand key advantages and disadvantages of the various options under consideration. Decision models continue to impact strategy

Discussion Reply: Strategy Development, Strategy Decisions, and Decision Models You will reply to one of your classmate’s thread. Minimum of 250 words in the body. Minimum of 2 sources from the litera

Discussion Reply: Strategy Development, Strategy Decisions, and Decision ModelsYou will reply to one of your classmate’s thread.Minimum of 250 words in the body.Minimum of 2 sources from the literature in addition to course texts.Use bolded headings below in the reply.Current APA format must be used.Use the following Outline:• Summary –

REPLIES: INSTRUCTIONS The student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of the assigned Module: Week. Your replies must include meaningful and substantive contributi

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must include meaningful and substantive contributions tothe discussion, and ideally provoke and challenge the thinking of your colleagues. Each replymust be 200-300 words.Replies: Specific Reference RequirementsFor Discussion Replies:

The student will post one thread of 700– 900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue mana

The student will post one thread of 700–900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue management opportunities? What revenue management opportunities are available to a manufacturer? How can it take advantage

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply and demand and grow revenue derived from

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply anddemand and grow revenue derived from supply chain assets. Revenue management can reduceimbalances between supply and demand through pricing. There is also

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on wh

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on whether or not to invest in expansion. Collapse AllIntroduction This portfolio work project will help you to not only

REPLIES For all Discussions, each reply must incorporate at least 1 scholarly citation in the current APA format and 1 Biblical principle/verse (Note: for each reply for the Discussion: Disruptive Mar

REPLIESFor all Discussions, each reply must incorporate at least 1 scholarly citation in the current APAformat and 1 Biblical principle/verse (Note: for each reply for the Discussion: DisruptiveMarketing, at least 1 Biblical verse needs to cited, in current APA format, under the BiblicalIntegration subject header). Any sources cited must have

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference Requirements For Discussion Thread: Introducing HR and Christian Worldview and Discu

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference RequirementsFor Discussion Thread: Introducing HR and Christian Worldview and Discussion Thread: Shapingthe Future of HR, include a references section, and be sure to have in-text citations for thefollowing sources:• At least 2 citations from Valentine: Human Resource Management.•

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings.

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings. NSTRUCTIONSThe student will post one thread of at least 750 words not to exceed 1,250 words by 11:59 p.m.(ET) on Thursday of the