How to calculate outliers in Excel, given the mean and standard deviation for each transaction purchase? Calculate the percentage of transactions with a purchase amount that is more than three standard deviations above or below the mean purchase amount. These transactions are considered outliers. Round the percentage to two decimal places (x.xx%).
Added by Susan A.
Close
Step 1
First, you need to have a list of transaction purchase amounts in Excel. Let's assume this list is in column A, starting from cell A2 (with the header in cell A1). Show more…
Show all steps
Your feedback will help us improve your experience
Nick Johnson and 83 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Using Excel, calculate the mean, standard deviation, standard error, median, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count, largest(1), smallest(1) of your distribution and interpret their meanings. Column Mean Standard error Median Mode Standard Deviation Sample variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1)
Riaan S.
Using PivotTables, find the mean and standard deviation of sales by region in the data provided. Click the icon to view the data. Complete the table below. (Type integers or decimals rounded to two decimal places as needed.) Average of Amount StdDev of Amount East North South West Grand Total
Lucas F.
Please tell me how to solve in excel: Purchase amounts in a store are normally distributed with a mean of $200 and a standard deviation of $70. If we take a sample of 100 purchase, what is the probability that the average purchase is less than 205?
Robin C.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD