Write My Paper Button

WhatsApp Widget
Skip to content
Home » xcel 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

xcel 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

  • by

xcel 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.