Bell Curve In Excel - PART2 - Excel Tips and Tricks

Learn how to create Bell Curve in Excel. Essentially we will teach you how to make a bell curve in Excel.
I will also show you the equation to calculate normal distribution.

These are the steps outlined in the video.

Sort Data
1) Ctrl + Shift + L
2) Sort Smallest to Largest
3) Ctrl + Shift + L

Mean Calculation
1) Select cell D2
2) =AVERAGE(B2:B76)
3) Whole number, Home ~ Number ~ Decrease Decimal

Standard Deviation
1) Select cell E2
2) =STDEV.P(B2:B76)
3) Whole number, Home ~ Number ~ Decrease Decimal

Normal Distribution
1) Select cell C2
2) =NORM.DIST(B2,$D$2,$E$2,FALSE)
3) Apply formula to rest of the rows.

Bell Curve
1) Select Test Results and Normal Distribution columns
2) Insert ~ Charts ~ Scatter
3) Scatter with smooth line

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Bell Curve In Excel - Excel Tips and Tricks - DETAIL EXPLANATION
   • Bell Curve In Excel - Excel Tips and ...  

Bell Curve In Excel - PART1 - Excel Tips and Tricks
   • Bell Curve In Excel - PART1 - Excel T...  

Bell Curve In Excel - PART2 - Excel Tips and Tricks
   • Bell Curve In Excel - PART2 - Excel T...  

Area Chart Under Bell Curve In Excel - Excel Tips and Tricks - - DETAIL EXPLANATION
   • Area Chart Under Bell Curve In Excel ...  

Area Chart Under Bell Curve In Excel - PART1 - Excel Tips and Tricks
   • Area Chart Under Bell Curve In Excel ...  

Area Chart Under Bell Curve In Excel - PART2 - Excel Tips and Tricks
   • Area Chart Under Bell Curve In Excel ...  

Area Chart Under Bell Curve In Excel - PART3 - Excel Tips and Tricks
   • Area Chart Under Bell Curve In Excel ...  

#tip #excel #microsoft #shorts #shortvideo #shortsvideo #howto #how #google