Required information

Lab $3\mathrm{.}2$ Tableau: Calculating Descriptive Statistics to Gain Insights About the Distribution of a Sales Dataset

Skip to question

$[$The following information applies to the questions displayed below.$]$

Keywords: Mean, Median, Standard Deviation, Range, Outlier, Box Plot

Decision$-$Making Context: Retail companies need to monitor their sales to ensure they are meeting their goals across different sales channels. In this lab, we use Tableau to calculate summary statistics for a company$$s online and in$-$person sales to see how they compare. We then create a box plot to help visualize the distributions of the different types of sales.

The Fruity Fruits Company sells exotic fruit from around the world to customers throughout the United States at retail outlets and online. It keeps a sales journal that records each sale and its related sales price and cost details.

Access the text alternative for Lab $3-2$ Tableau. Will open in a new tab or window. Internet connection required.

$-3$:$18$

$1$x

Required:

Visualize the dispersion of values using a box plot.

Add summary statistics.

Data: Lab $3\mathrm{.}2$ Data.xlsx

Specify the Question: What are the descriptive statistics for online and in$-$person sales? What does the distribution of the transaction amount look like? Based on the descriptive statistics and box plot, how do the online and in$-$person sales compare?

Obtain the Data: This lab uses the data in Lab $3\mathrm{.}2$ Data.xlsx$.$ This dataset is a condensed version of Fruity Fruits$$ sales data that show the sales earned for each transaction and the transaction type $($online or in$-$person$).$

Analyze the Data: Refer to lab $3\mathrm{.}2$ in your text for additional instructions and steps.

Lab $3\mathrm{.}2$ Tableau: Analysis Questions

Note: Submit your answers for the following Analysis Questions in the text entry field below.

The difference between the range of values for online sales transactions and in$-$person sales transactions seems to be significant. What insights can you draw from comparing the ranges?

On a new sheet, drag In$-$Person to the canvas and use the dropdown in the pill to change the measure to count. The canvas now shows the number of observations for In$-$person sales. Repeat the process for online sales. How many observations were included in the dataset for each type of sales transaction? How might the different size samples impact the other statistical values?