Use the fill down feature to extend the formula from C2 down to construct the relative frequency distribution. How to Get Relative & Cumulative Distribution in Excel. Choose a scale for the vertical axis that will accommodate the class with the highest frequency.
The data should be in the form of a list of values. How to Create a Pivot Table from Multiple Worksheets. How Do I Graph on a Secondary Axis in Excel Office. How to Convert Excel Time Difference to Decimal Nu. Hold down Shift and click the first cells of the columns that have your data. That is, the absolute number of data points per bin.
