A result that is significantly higher or lower than the majority of the values in your data is referred to as an outlier. Outliers can skew the results when using Excel to examine data. The mean average of a data set, for example, may accurately reflect your values.

Q1 – (1.5* IQR) is the lower range limit. This is calculated by subtracting 1.5 times the inner quartile range from your 1st quartile. Q3 + (1.5*IQR) = higher range limit This is 1.5 times quartile 3 of the IQR+. Any data that goes below or beyond these boundaries will now be classified as an anomaly.

Excel offers several underutilised functions that can significantly improve your data analysis. Its statistical capabilities are one of the best characteristics. So, using simple statistics formulas in Excel, you can simply discover outliers.

An outlier is a single observation that appears to diverge significantly from the rest of the sample. The following are some of the reasons why identifying prospective outliers is critical. An outlier could be a sign of skewed data. For instance, data could have been wrongly coded or an experiment could have been done erroneously.

Course Content

Introduction to Data Analysis With Excel

How to use LearnVern

What is data analysis and where to use it

How to use Percentage Variance and Round functions in Excel

How to use count and different types of count functions?

How to perform calculations on string data using excel spread sheet functions?

How to calculate age and words count using excel spread sheet functions?

How to perform calculations using Date and Time functions

How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas

How To Find The Last Day And Nth Weekday Of The Month Using Date Functions

How To Perform Conditions Using Date And Time Functions

How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions

How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions

Excel With Formulas Quiz

What Is Conditional Statements And How To Perform Calculations Using Logical Operators

How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator

How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet

How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions

How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator

How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions

Assignment On Conditional Statements and Logical Operators Assignment

Conditional Statement & Logical Operators Quiz

What Is Statistics And Statistical Function

What Is Intermediate Statistical Functions

What Is Difference Between Absolute And Relative Cell Reference

What And How To Use Index Function

What And How To Use Match Function

How To Use MMM Formula In Excel Spread Sheet

How To Use Percentiles In Excel Spread Sheet With Example

How To Use Quartile Using Match Function

What Is Outliers And Statistical Outliers

How To Use Leveraged Interquartile Range IQR

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

Common Excel Spread Sheet Statistical Functions Quiz

What Is Lookup And Types Of Lookup Function

Different Types Of Examples Using Lookup Function

How To Perform Case Sensitive Lookup Using Index And Exact Function

How To Perform Aggregations On Data Using Lookup Function

What Is Reference And Types Of Reference Functions

What Is Reference Offset Function

How To Use Rows And Columns Reference Function

What And Where To Use Text Function

How To Use Vlookup, Len, Concatenate & Averageifs Function Using Excel Spread Sheet

How To Use Find IfError, Countifs & Sum Product Function Using Excel Spread Sheet

How To Use Date And Time Functions In Excel Spread Sheet

How To Use Day Days360 Edate And Date Value Function In Excel Spread Sheet

How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet

How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet

Assignment On Date and Time

Assignment On LookUp

Assignment On Reference

Lookup Reference ,Text Date & Time Functions Quiz

What And How To Use Conditional Formatting

Examples Using Conditional Formatting

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

Assignment On Formula Based Conditional Formatting

Formula based Conditional Formatting Quiz

What Is Data Visualization And How To Use

What Is The Importance Of Data Visualization

What Are The Common Data Types While Analysing Data

How To Use Different Charts For Data Analysis Presentation And Reporting

When To Use Histogram And Bullet Chart

When To Use Actual vs Target And Funnel Chart

How To Calculate Gross Profit Margin And Gross Profit Margin Percent

How To Calculate COGS EBIT And EBITDA

How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet

How To Calculate Employee Turnover And Interest Rates

How To Calculate Effective Rate With FV

How To Create Loan Payment Calculator In Excel Spread Sheet

How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers

How To Calculate Depreciation Accelerated Depreciation And Present Value

How To Calculate Present Value Of Future Payments And Net Present Value

How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows

When To Use Each Chart Or Graph Type In Excel Spread Sheet

How To Use Data Visualizations Examples On Extraction Of Data

Assignment On Data Visualization

Data Visualization And Financial Formulas Quiz

How To Format And Customize Chart In Excel Spread Sheet

How To Customize Axes In Excel Spread Sheet Charts