If you need to visualize a distribution or estimate probability, then a histogram in Excel is probably what you’re looking for. The video above is a short tutorial on how to set up a histogram in Excel.
Excel is among a chemical engineer or chemical engineering student’s most valuable tools. If you’re looking for more tips and tutorials on Excel, check out our popular series Excelling with Excel and as well as the series we ran last year called Excel Tips for Chemical Engineers.
You may also want to look into the AIChE Academy online course Spreadsheet Problem-Solving for Chemical Engineers or upcoming face-to-face classroom versions held at various locations.
You should also have a look at the Excel Learn Cheme series, which is where the Excel histogram tutorial above came from. The series currently contains more than 50 segments and continues to grow.
And be sure to check out the entire Learn Cheme series for information on a wide variety of chemical engineering topics.