How to Make a Bell Curve in Microsoft Excel 365

Channel	Publish Date	Thumbnail & View Count	Actions
ArturoFM	2021-01-02 03:51:54	1,875 Views	View on YouTube View Channel

Let’s generate a normal distribution (normal curve) graph using the RANDARRAY dynamic function from Microsoft Office 365. In a few minutes you’ll be able to make your own Bell Curve in Microsoft Excel.

Formulas used in this video:
To generate sample data: ‌
‌=RANDARRAY([rows],[columns],[min],[max],[whole_number])
To Generate data for the Bell Curve:‌
‌=NORM.INV (probability, mean, standard_dev)

RECOMMENDED VIDEOS/PLAYLISTS
macOS Big Sur: 3 Must Have Apps: https://youtu.be/2CeT7KR6MMw

️ *** MY PRODUCTS ***
iPhone 12 Pro Max Cover: https://amzn.to/3lpTIaw
Camera I use: https://amzn.to/3obO0Lq
Lens for camera I use: https://amzn.to/3mpmKIO
Memory for camera: https://amzn.to/3of5NBr
Green Screen Backdrop: https://amzn.to/36lQQqY

️Timestamps️
00:00 Intro
00:06 Why is the Bell Curve graph important
00:29 How does a Bell Curve graph looks like
00:55 Generating sample data to work with
02:07 Generating normally distributed data based on sample data from before
03:14 Creating the Bell Graph
03:38 2 Things to consider
04:24 Wrap up

*** BE MY FRIEND ***
Instagram: https://www.instagram.com/arturofm247
Twitter: https://twitter.com/arturofm247
Facebook: https://www.facebook.com/arturofm247

Contact
[email protected]

*** ABOUT THE CHANNEL ***
Learn how to do anything with high quality how to and review videos. I’m currently a software engineer at Wells Fargo and a part time YouTube Creator sharing my passion for teaching technology in a concise and easy way.

TOPICS IN THIS VIDEO
• How to Make a Bell Curve
• Bell Curve in Excel
• How to make a normal distribution graph in Excel
• Normal distribution grapgh

HASHTAGS
#excel #msexcel #excel365 #microsoft #office365

VIDEO OUTLINE
This video will teach you how to generate a normal distribution graph – also called normal curve, using the RANDARRAY which is a dynamic function from Microsoft Office 365.

What you will see is a continuous graph because it’s dynamic, it fluctuates with new data coming in and out. It shows the highest point which has the highest probability of occurring. So with this graphic in mind, we can see that what we are about to learn is useful for statistical data to find out the top performers in some area.