best way to turn blood pressure excel into a chart

It just rotates this information by 90 degrees, putting the categories on the vertical axis and the numeric values on the horizontal axis. The Bar chart provides precisely the same information as does the Column chart. This is reflected in the way that Excel might chart that data (see Figure 1.4).įigure 1.5 In contrast to Column charts, Excel’s Bar charts always show categories on the vertical axis and numeric values on the horizontal axis. There is no order that’s necessarily implied by the names themselves: They’re just categories. If you throw out the psychological and cultural connotations that we pile onto labels, there’s nothing about Male and Female that would lead you to put one on the left and the other on the right in Figure 1.3’s pivot chart, the way you’d put June to the left of July.Īnother example: Suppose that you want to chart the annual sales of Ford, General Motors, and Toyota cars. Different values in a category variable merely represent different groups, and there’s nothing intrinsic to the categories that does anything but identify them.

In Figures 1.2 and 1.3, the variable Sex is measured using a category scale, often called a nominal scale. The difference concerns scales of measurement. There’s a difference in how weight and sex are measured and reported in Figure 1.2 that is fundamental to all statistical analysis-and to how you bring Excel’s tools to bear on the numbers. Statistical Analysis: Microsoft Excel 2013

Best way to turn blood pressure excel into a chart