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 adjust the x-axis such that the curve is bigger and more centered on the screen. We double-click on the x-axis such that the Format Axis panel opens. Here, you go to the three bars icon, click on Axis Options and change the minimum and maximum to whatever suits you. In the next step, we click on Add Chart Element, Error Bars, and More Error Bars Options. The Format Error Bars panel opens and you click on the three bars icon. Here, you select Minus, No Cap, Percentage, and set Percentage to 100. We only need to remove the curve from the chart before we start with creating the normal distribution curve. To remove the...