Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Make an interactive distribution curve (bell curve) in Excel - Easy Trick πŸ’‘
Play lesson

Data Analysis with Excel πŸ“ˆπŸ“‰πŸ“Šβœ… - Make an interactive distribution curve (bell curve) in Excel - Easy Trick πŸ’‘

4.0 (1)
11 learners

What you'll learn

This course includes

  • 14.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Excel Bell curves or frequency distribution curves are handy for analysing and understanding distribution of your data. Recently, someone asked me to make a bell-curve to visualize salary distribution of staff. While you can use formulas or complex techniques to make these, I used a simple trick to make the bell curve and add interactive effect to it. Needless to say, my clients were impressed. Let me show the method in this video and take it to next level. Time stamps for the video: ==================== 0:00 - The bell curve problem 0:36 - Making the bell curve with Excel 3:27 - Adding department as slicer 3:54 - Fixing the axis issues 4:48 - Taking the bell curve to next level (splitting it by gender) 5:42 - Closing remarks Example file: ========== https://chandoo.org/wp/wp-content/uploads/2021/04/bell-curve.xlsx πŸ‘‰Checkout my online course on Advanced Excel & Data analysis =================================================== πŸ’»πŸ“—πŸ’₯ https://chandoo.org/wp/excel-school-program/ #Excel #BellCurve

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere