How to find Outliers in Your Data Easily with Z-Scores in Excel

Chandoo β€’ December 5, 2023
Video Thumbnail

About

πŸ‘‹ Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. βœ… Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep βœ… New Video Every Week ~ Subscribe πŸ’»πŸ“— My courses Advanced Excel πŸ‘‰ https://chandoo.org/wp/excel-school-program/ Advanced Power BI πŸ‘‰ https://chandoo.org/wp/power-bi-course/ Everything πŸ‘‰ https://chandoo.org/mdac ~ KNOW πŸ˜€ About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW πŸšΆβ€β™€οΈπŸšΆβ€β™‚οΈ 🌐 Website - https://chandoo.org/wp/ πŸ“ƒ FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ πŸ“š Courses - https://chandoo.org/wp/training-programs/ πŸ“· Instagram - https://www.instagram.com/chandoo.xlsx/ πŸ’₯ఀెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/

You May Also Like

iPhone 14 Upgrade Essentials

AI-recommended products based on this video

Loading...
BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

(7,876)
$11.99
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

(114)
$57.36$49.99
Prime$5.48 delivery Mon, Jun 16
Loading...
UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

(4,725)
$31.99
500+ bought in past month
Loading...
VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

(54,882)
$32.25
FREE delivery Mon, Aug 25 on your first order
1K+ bought in past month
Loading...
2Pack 10ft iPhone Charger 90 Degree Lightning Cable Right Angle Long USB Charging Cord Compatible with Apple iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad iPod

2Pack 10ft iPhone Charger 90 Degree Lightning Cable Right Angle Long USB Charging Cord Compatible with Apple iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad iPod

(2,193)
$14.24
FREE delivery Sat, Jun 14 on your first order
400+ bought in past month
Loading...
Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

(656)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

(750)
$59.99
PrimeFREE delivery Sat, Jun 14
Loading...
iPhone Charger [Apple MFi Certified] 3FT, 3Pack USB A to Lightning Cable Braided Fast Charging Apple Cord Compatible with iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad/iPod/AirPods

iPhone Charger [Apple MFi Certified] 3FT, 3Pack USB A to Lightning Cable Braided Fast Charging Apple Cord Compatible with iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad/iPod/AirPods

(5,626)
$17.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
DUEDUE for Samsung Galaxy S25 Plus Case Magnetic Samsung S24 Plus Case Clear Compatible with Magsafe Slim Cover with Stand Ring Shockproof Protective Case for Samsung S25 Plus/S24 Plus 6.7 Inch Clear

DUEDUE for Samsung Galaxy S25 Plus Case Magnetic Samsung S24 Plus Case Clear Compatible with Magsafe Slim Cover with Stand Ring Shockproof Protective Case for Samsung S25 Plus/S24 Plus 6.7 Inch Clear

(38)
$17.99
FREE delivery Sat, Jun 14 on your first order
Loading...
RALEAVO for iPhone 16 Case Compatible with MagSafe Strong Magnetic Phone Case Clear Floral Case for Women Girls Slim Hard Back Protective Case for iPhone 16 6.1"(Clear/Lavender)

RALEAVO for iPhone 16 Case Compatible with MagSafe Strong Magnetic Phone Case Clear Floral Case for Women Girls Slim Hard Back Protective Case for iPhone 16 6.1"(Clear/Lavender)

(872)
$15.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Vihibii for Samsung Galaxy S25 Clear Magnetic Case with Stand, Compatible with MagSafe, [Anti Yellowing] Shockproof & Scratch Proof, Transparent Silm Phone Case for Samsung Galaxy S25 6.2" 2025, Clear

Vihibii for Samsung Galaxy S25 Clear Magnetic Case with Stand, Compatible with MagSafe, [Anti Yellowing] Shockproof & Scratch Proof, Transparent Silm Phone Case for Samsung Galaxy S25 6.2" 2025, Clear

(164)
$21.99$19.17
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
ESR for iPhone 16 Pro Max Case, Compatible with MagSafe, Shockproof Military-Grade Protection, Magnetic Phone Case for iPhone 16 Pro Max, Classic Hybrid Case (HaloLock), Clear

ESR for iPhone 16 Pro Max Case, Compatible with MagSafe, Shockproof Military-Grade Protection, Magnetic Phone Case for iPhone 16 Pro Max, Classic Hybrid Case (HaloLock), Clear

(71,292)
$14.44
FREE delivery Sat, Jun 14 on your first order
400+ bought in past month
Loading...
2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

(31)
$24.69
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

(656)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

(38)
$27.99
Prime
Loading...
40W USB C Charger Block, 2-Pack Wall Plug Fast Charging Block, 4-Port PD+QC Power Adapter Multiport Cube Brick Type C Box for iPhone 16/15/14/13/12/11/Pro Max/XS/XR/8/7, Tablets, Cellphones

40W USB C Charger Block, 2-Pack Wall Plug Fast Charging Block, 4-Port PD+QC Power Adapter Multiport Cube Brick Type C Box for iPhone 16/15/14/13/12/11/Pro Max/XS/XR/8/7, Tablets, Cellphones

(565)
$24.99
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
iPhone 15 16 Charger Fast Charging 10 ft USB C to USB C Cable Long,Apple 60W Type C Cord and USBC Wall Block Power Adapter Cube Brick for iPhone 16 Pro/16 Pro Max/16 Plus/15 Pro/15 Pro Max/15 Plus

iPhone 15 16 Charger Fast Charging 10 ft USB C to USB C Cable Long,Apple 60W Type C Cord and USBC Wall Block Power Adapter Cube Brick for iPhone 16 Pro/16 Pro Max/16 Plus/15 Pro/15 Pro Max/15 Plus

(101)
$16.14
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
USBC Charger Block for iPhone 16 Charging Plug,MFI Certified Fast USB C Wall Cube 2Pack Power Adapter for iPhone 15/16 Pro/Plus/Pro Max/14/13/12/11,for iPad Air/Mini USB-C Charge Brick Box

USBC Charger Block for iPhone 16 Charging Plug,MFI Certified Fast USB C Wall Cube 2Pack Power Adapter for iPhone 15/16 Pro/Plus/Pro Max/14/13/12/11,for iPad Air/Mini USB-C Charge Brick Box

(6,878)
$13.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
iPhone Charger Fast Charging [Apple MFi Certified] USB C to Lightning Cable 6FT USBC to Lightning Cable Nylon Braided Type C Cord for iPhone 14 13 12 11 Pro Max XR XS X 8 7 6 Plus SE, iPad

iPhone Charger Fast Charging [Apple MFi Certified] USB C to Lightning Cable 6FT USBC to Lightning Cable Nylon Braided Type C Cord for iPhone 14 13 12 11 Pro Max XR XS X 8 7 6 Plus SE, iPad

(4,036)
$8.99
FREE delivery Sun, Jun 29 on your first order
2K+ bought in past month
Loading...
Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

(8)
$39.99
FREE delivery Tue, Nov 4
Loading...
Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

(40)
$39.99
FREE delivery Thu, Nov 13
Loading...
ESR for iPhone 14 Pro Screen Protector, Tempered Glass with Easy Installation Frame, Military-Grade Protection, Ultra Tough, Scratch Resistant, 3 Pack

ESR for iPhone 14 Pro Screen Protector, Tempered Glass with Easy Installation Frame, Military-Grade Protection, Ultra Tough, Scratch Resistant, 3 Pack

(42,149)
$10.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
3-Pack, XunyLyee Screen Protector for iPhone 13/13 Pro/iPhone 14/ iPhone 16e 2025 6.1 Inch Tempered Glass Film Bubble Free

3-Pack, XunyLyee Screen Protector for iPhone 13/13 Pro/iPhone 14/ iPhone 16e 2025 6.1 Inch Tempered Glass Film Bubble Free

(275)
$7.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
JETech Full Coverage Screen Protector for iPhone 16e 2025, iPhone 14 6.1-Inch, 9H Tempered Glass Film Case-Friendly, HD Clear, 3-Pack

JETech Full Coverage Screen Protector for iPhone 16e 2025, iPhone 14 6.1-Inch, 9H Tempered Glass Film Case-Friendly, HD Clear, 3-Pack

(7,597)
$8.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
[3+3 Pack] iVoler Tempered Glass for iPhone 14 6.1 inch [3 Pack] with [3 Pack] Camera Lens Screen Protector with [Alignment Frame], Anti-Scratch Case Friendly Transparent HD Clear Film

[3+3 Pack] iVoler Tempered Glass for iPhone 14 6.1 inch [3 Pack] with [3 Pack] Camera Lens Screen Protector with [Alignment Frame], Anti-Scratch Case Friendly Transparent HD Clear Film

(36,815)
$11.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified

soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified

(105)
$39.99
FREE delivery Thu, Nov 27
Loading...
UGREEN USB to USB C Adapter & USB C to USB Adapter Combo 4-Pack, 10Gbps Type-C Converter, Car Charger Compatible with MacBook Pro, iPad Mac mini, iPhone 17/16, Galaxy, PC/Laptop, Hard Drive Enclosure

UGREEN USB to USB C Adapter & USB C to USB Adapter Combo 4-Pack, 10Gbps Type-C Converter, Car Charger Compatible with MacBook Pro, iPad Mac mini, iPhone 17/16, Galaxy, PC/Laptop, Hard Drive Enclosure

(86)
$9.74
Prime
Loading...
USB C Car Charger, 3-Port 67W Super Fast Charging Dual USB-C & USB-A Car Charger Accessories Cigarette Lighter Adapter for iPhone 17 16e 16 15 14 13 12 11 Pro Max, iPad, Galaxy, Pixel, Android Phone

USB C Car Charger, 3-Port 67W Super Fast Charging Dual USB-C & USB-A Car Charger Accessories Cigarette Lighter Adapter for iPhone 17 16e 16 15 14 13 12 11 Pro Max, iPad, Galaxy, Pixel, Android Phone

(217)
$12.59
FREE delivery Sat, Sep 20 on your first order
2K+ bought in past month
Loading...
USB C Car Charger 121W, IDOLCO 2-Port Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging 12V Car Phone Charger Cigarette Lighter Adapter Plug for iPhone 16/15/14 Series, Galaxy S24/MacBook

USB C Car Charger 121W, IDOLCO 2-Port Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging 12V Car Phone Charger Cigarette Lighter Adapter Plug for iPhone 16/15/14 Series, Galaxy S24/MacBook

(45)
$19.99
FREE delivery Tue, Jun 17 on your first order
Loading...
URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

(114)
$57.36$49.99
Prime$5.48 delivery Mon, Jun 16
Loading...
for Magsafe Car Mount【20 Strong Magnets 】Magnetic Phone Holder for Car Phone Holder Mount Dash【360°】Cell Phone Mount for Car Accessories,Car Mount for iPhone 16 Pro Max 15 14 13 12 Plus MagSafe Cases

for Magsafe Car Mount【20 Strong Magnets 】Magnetic Phone Holder for Car Phone Holder Mount Dash【360°】Cell Phone Mount for Car Accessories,Car Mount for iPhone 16 Pro Max 15 14 13 12 Plus MagSafe Cases

(11,563)
$16.98
FREE delivery Tue, Jun 17 on your first order
3K+ bought in past month