The most popular visualisation tools for detecting outliers are scatter plots and box plots. Scatter plots — Scatter plots can be used to specifically find outliers in a dataset or a specific attribute.
Go to the Home tab after opening the sheet and selecting the cells you want to format. Click the Conditional Formatting drop-down arrow in the Styles section of the ribbon. Choose "A Date Occurring" from the pop-out menu when you move your cursor to Highlight Cell Rules. You'll see a little window pop up where you may put up your rule.
Microsoft Excel gives you ten options for formatting cells based on the current date. Simply go to the Home tab > Conditional Formatting > Highlight Cell Rules and pick A Date Occurring to apply the formatting.
A value in a set of data that "lies outside" (is substantially smaller or greater than) the majority of the other values. For example, both 3 and 85 are "outliers" among the scores 25,29,3,32,85,33,27,28.
Learner's Ratings
4
Overall Rating
56%
21%
6%
6%
11%
Reviews
N
Nitesh kumar gupta
5
nice course all the video explained very well from scratch to advance
S
Shubham Maurice
5
Overall Lectures are good but also provide the practicing spreadsheets for students.
S
Shivam Gautam
5
very good experience
K
KALAGA NARAYAN
5
i dont think some one can explain deeply ,practically rathere than this tutor
L
Lavkesh Kushwaha
5
West
K
Kamran Ahmed
5
Helpful course
S
sanjeet kumar
4
some excercise should be there. I have not studied standerd deviation of population in second module but question has been asked.
V
Vishisht
5
good
S
Shringa A G
5
This is a really helpful course for beginners as well as experts. You can develop your skills from this course.
Share a personalized message with your friends.