Our Services

Get 15% Discount on your First Order

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 al

December 22, 2023

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.
  - Which option (Option A or Option B) would you choose at this point in your analysis, given the monthly expense range of $500–$2,750?
  - 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.

Cream, Data, form, Ice, Identify, patterns, PowerPoint, presentation, Report, set, submit, trends

Share This Post

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

Related Questions

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each year the Internal Revenue Service (IRS) updates the tax code and makes changes to standard documentation. Tax professionals can see sweeping changes over their career.

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a foreign currency such as the Mexican peso or the Indian rupee instead of investing it in the U.S. In April 2024, the latest central bank interest

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income are critical for arriving at

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income is critical for arriving at the adjusted gross income (AGI).

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing portions or all their income through strategies such as altering financial information, falsifying revenue documents, or keeping relevant information from their tax advisor.

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the number for that transaction. After all transactions have been recorded, foot the accounts where necessary and enter the balance in the proper place for each

hello, I need help with an assignment: Overview An important aspect of federal income tax preparation for individuals is understanding the key terms

hello, I need help with an assignment: Overview An important aspect of federal income tax preparation for individuals is understanding the key terms associated with tax rate structures, marginal versus average tax rates, the income tax formula, and the components of a basic Form 1040. This assignment will allow you

Hello, I need help with a discussion: 1-1 Discussion: Introduction and Tax Avoidance Versus Tax Evasion Do you have any experience with tax preparation or

Hello, I need help with a discussion: 1-1 Discussion: Introduction and Tax Avoidance Versus Tax Evasion Do you have any experience with tax preparation or completing your own tax return? NO, I DON’T HAVE EXPERIENCE. (Please keep personal financial details confidential.) What did you learn or find interesting? If not,

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or Huq’s understanding of style relates to how youth express identity and community today.

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page interpretation of the passage for each based on what you have learned/acquired from the previous assignments performed for this course. As part of this presentation, a clear and concise principle

PART 1 – MY BELIEFS: According to the New Oxford American Dictionary, ethics is defined as “moral principles that govern a person’s or group’s behavior.”

PART 1 – MY BELIEFS: According to the New Oxford American Dictionary, ethics is defined as “moral principles that govern a person’s or group’s behavior.” Therefore, in an ideal world, ethics should play the ultimate role when making a decision. If ethics are the principles which guides one’s behavior then, ideally,

An understanding of the factors surrounding women’s and men’s health can be critically important to disease diagnosis and treatment in these areas. This

An understanding of the factors surrounding women’s and men’s health can be critically important to disease diagnosis and treatment in these areas. This importance is magnified by the fact that some diseases and disorders manifest differently based on the sex of the patient. Effective disease analysis often requires an understanding

1. Task: Your task is to analyze (Assessment) Manipulation Application Data, and comment on ways that the data could be manipulated and transformed. Write

1. Task: Your task is to analyze (Assessment) Manipulation Application Data, and comment on ways that the data could be manipulated and transformed. Write a written reflection on the above b) i) What is the purpose of data manipulation? ii) What are the different data manipulations? iii) What are structure

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an emergency

In 2013, the H.J. Heinz Corp. was considering an acquisition offer from Warren Buffett’s Berkshire Hathaway and 3G, a Brazilian private equity firm. Your

In 2013, the H.J. Heinz Corp. was considering an acquisition offer from Warren Buffett’s Berkshire Hathaway and 3G, a Brazilian private equity firm. Your valuation analysis will help Heinz negotiate for a fair price from its prospective acquirors. H. J. Heinz Company was incorporated in Pennsylvania on July 27, 1900.

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an

Issue paper on a recent (within 2 years) international financial topic of your choice. The paper should be analytical rather than descriptive The paper

Issue paper on a recent (within 2 years) international financial topic of your choice. The paper should be analytical rather than descriptive The paper should be no longer than 3 pages, double spaced. The Internet is probably the best source of information (Wikipedia is not an acceptable source). The paper

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and checking accounts to meet unrealistic sales quotas (http://money.cnn.com/2016/09/08/investing/wells-fargo-created-phony-accounts-bank-fees/?iid=EL, September 4, 2017). Since then, Wells Fargo has also been accused of forcing over 500,000 customers into auto insurance policies they did notneed,