Excel Histogram with Normal Distribution Curve

Excel Histogram with Normal Distribution Curve In this video, we will explain how you can create a histogram with a normal distribution curve in Excel. 0:00 Excel Histogram with Normal Distribution Curve Intro 0:44 Creating Histogram Table using Analysis Toolpak 2:31 Inserting the Histogram 4:22 Inserting the Normal Distribution Curve Download Excel File: Before we can ask Excel to insert the table, we first need to define the bins. Here we choose to start at 150 and then jump by 5 up to 200. Now we navigate to Data and select Data Analysis. A menu opens where we select Histogram, we press on OK and the Histogram menu opens. Now we are ready to start creating the histogram and normal distribution curve. First, we select the histogram data, navigate to Insert, and select Scatter with Smooth Lines and Markers. The graph appears on the screen. Next, we adju
Back to Top