Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information Lab 3 . 2 Tableau: Calculating Descriptive Statistics to Gain Insights About the Distribution of a Sales Dataset Skip to question [ The
Required information
Lab 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
DecisionMaking 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 companys online and inperson 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 Tableau. Will open in a new tab or window. Internet connection required.
:
x
Required:
Visualize the dispersion of values using a box plot.
Add summary statistics.
Data: Lab Data.xlsx
Specify the Question: What are the descriptive statistics for online and inperson sales? What does the distribution of the transaction amount look like? Based on the descriptive statistics and box plot, how do the online and inperson sales compare?
Obtain the Data: This lab uses the data in Lab 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 inperson
Analyze the Data: Refer to lab in your text for additional instructions and steps.
Lab 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 inperson sales transactions seems to be significant. What insights can you draw from comparing the ranges?
On a new sheet, drag InPerson 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 Inperson 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started