* You are viewing the archive for the ‘Pre-Statistics’ Category

How to Make a Bar Chart in Microsoft Excel

A bar chart (also called a bar graph) is a way to graphically display data using bars of different heights or widths. Bar charts are useful for showing comparisons between sets of data, especially when you want to show the relative size of things, such as differences in height, length or weight. Microsoft Excel can create colorful and professional looking bar charts in a few clicks — just enter the data into the worksheet and let Microsoft Excel do the rest. While bar charts can be vertical or horizontal, the most common format is a horizontal format. Microsoft Excel calls vertical graphs column charts and horizontal graphs bar charts.

Microsoft Excel bar chart (left) and column chart (right).

Microsoft Excel bar chart (left) and column chart (right).


 
 
 
 
 

Continue Reading

Order of Operations (PEMDAS)

In order to succeed in statistics, you’re going to have to be familiar with Order of Operations. The “operations”: addition, multiplication, division, subtraction, exponents, and grouping, can be performed in multiple ways, and if you don’t follow the “order”, you’re going to get the problem wrong. For example:
4 + 2 × 3
can equal 18 or 10, depending on whether you do the multiplication first or last:
4 + 2 × 3
6 × 3
18 (Wrong!)
4 + 2 × 3
4 + 6
10 (Right!)
This article shows you how to get it right every time with an acronym: PEMDAS.
Continue Reading