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

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,

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital information to various stakeholders, including investors, creditors, management, and government agencies, enabling them to make informed decisions. Here’s a breakdown of key aspects within accounting: Financial Statements: These are the

From discussions with your broker, you have determined that the expected inflation premium is 1.35 percent next year, 1.50 percent in year 2, 1.75 percent

From discussions with your broker, you have determined that the expected inflation premium is 1.35 percent next year, 1.50 percent in year 2, 1.75 percent in year 3, and 2.00 percent in year 4 and beyond. Further, you expect that real risk-free rates will be 3.20 percent next year, 3.30

The Special Widget division manufactures a product called SW for Global Corporation. The plant is a completely autonomous subsidiary that sells SWs to

The Special Widget division manufactures a product called SW for Global Corporation. The plant is a completely autonomous subsidiary that sells SWs to other subsidiaries of Global Corporation, as well as outside companies. At the beginning of the year the controller for Special Widget estimates sales and unit costs based

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of business. Create the business case: · Determine why funding is needed for the company. · Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on.

1. Are non-owner stakeholders adversarial to firm profit? 2. Managerial agency level stakeholder research assumes that the ultimate corporate goal is the

1. Are non-owner stakeholders adversarial to firm profit? 2. Managerial agency level stakeholder research assumes that the ultimate corporate goal is the satisfaction of shareholder demands for market returns. Therefore, managerial decisions regarding the legitimacy and welfare of non-investor stakeholders are considered only for instrumental purposes. Explain what this means. What are the ethical implications of this

Comp 3 = Fin Review Walmart’s Financials and Business Model. Describe the business, including the type of business. Create the business case: Determine

Comp 3 = Fin Review Walmart’s Financials and Business Model. Describe the business, including the type of business. Create the business case: Determine why funding is needed for the company. Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on. Evaluate the requirements of each funding source you determined

Comp 2 = Fin Research Walmart’s financial reports for 2019. Complete a 2- to 3-page FAQ/shareholder analysis. Evaluate economic conditions that influence

Comp 2 = Fin Research Walmart’s financial reports for 2019. Complete a 2- to 3-page FAQ/shareholder analysis. Evaluate economic conditions that influence company performance. Consider political, environmental, currency (money), global economics, and government influences on economic conditions. Compare market conditions with the company’s performance for 2019. Conclude how the market conditions that year influenced

Cookie Business Final Project Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to

Cookie Business Final Project Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided

Ref 3 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts.

Ref 3 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Types of Business Forms Choosing the fo

Comp 2 = MA Scenario Information Read the scenario located in “Problems – Series A,” section 8-19A of Ch. 8, “Performance Evaluation,“ of Fundamental

Comp 2 = MA Scenario Information Read the scenario located in “Problems – Series A,” section 8-19A of Ch. 8, “Performance Evaluation,“ of Fundamental Managerial Accounting Concepts. This scenario pu

Comp 1 = MA Investment Opportunities Scenario Review the scenario and complete the activity that follows. This scenario can also be found in the “Problems –

Comp 1 = MA Investment Opportunities Scenario Review the scenario and complete the activity that follows. This scenario can also be found in the “Problems – Series A” section 10-19A of Ch. 10, “Planni

Ref 2 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts.

Ref 2 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Costing Systems The type of product a c

Ref 1 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts.

Ref 1 = MA This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Ratio Analysis Financial statement anal

Ref 2 = Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all

Ref 2 = Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Capital Budgeting Techniques Yo

Ref 3 = Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts.

Ref 3 = Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Systematic and Unsystematic Risk You a

Ref 1 – Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts.

Ref 1 – Fin This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Primary and Secondary Markets You are