Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock