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 in-person sale transactions.
Data: Lab 3.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.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.2 in your text for additional instructions and steps.
 Required: Calculate summary statistics using the Excel Analysis ToolPak. Create 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

Students Have Also Explored These Related Databases Questions!