You are viewing the article How to Create a Probability Distribution Graph in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 9,129 times.
This wikiHow teaches you how to create a column histogram in Microsoft Excel. A probability distribution chart is a bar graph that displays frequency data that allows you to calculate metrics, such as the number of people scoring a certain percentage of a test period.
Steps
Insert information
- On Mac, this step can open a new Excel sheet with no data. Then skip to the next step.
- For example, if your data range spans 17 to 225, the smallest data point will be 17 and the largest 225.
- Sturge’s formula : K = 1 + 3.322 * log(N) where K is the number of drawers and N is the number of data points; after you find K, round up or down to an approximate integer. Sturge’s formula is best suited for linear or “clean” datasets.
- Rice’s formula : cube root of (number of data points) * 2 (for a dataset with 200 points, you’ll need to find the square root of 200, then multiply the result by 2). This formula is best suited for erratic or inconsistent data.
- For example, if you were to generate data for each box of a probability distribution representing test scores, you would most likely use the increment operator of 1 to represent different scales (e.g. 5, 6) , 7, 8, 9).
- Increasing multiples of 10, 20, or even 100 is a commonly used standard for the number of counts in each drawer.
- If there are outliers that mutate, you can either put them outside the range of cells or increase/decrease the range of counts in each bin enough to include the outlier value.
- For example, if you have 40 data, you can add each corresponding number to cells A1 through A40 .
- Skip this step on a Windows computer.
Create charts on Windows
- For example, if you use 10 increments, enter 10 here.
- Axis Titles – Click the green + on the right side of the chart, check the “Axis Titles” box, click on any Axis Title text box located on the left or bottom of the graph and then Enter the title you want.
- Chart Title – Click the Chart Title text box at the top of the histogram, then enter the title you want to use.
Create charts on Mac
- Make sure you don’t click the blue multi-column “Pareto” icon with an orange line.
Advice
- The bins can be as wide or as narrow as you like, as long as they fit the data and don’t exceed a reasonable number of bins for this dataset.
Warning
- You need to make sure that the histogram makes sense before drawing any conclusions.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 9,129 times.
This wikiHow teaches you how to create a column histogram in Microsoft Excel. A probability distribution chart is a bar graph that displays frequency data that allows you to calculate metrics, such as the number of people scoring a certain percentage of a test period.
Thank you for reading this post How to Create a Probability Distribution Graph in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: