Question: Required: Calculate summary statistics using the Excel Analysis ToolPak. Create a box plot to show the distribution of the online and in - person sale
Required:
Calculate summary statistics using the Excel Analysis ToolPak.
Create a box plot to show the distribution of the online and inperson sale transactions.
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
