Reference Notes

Key Open Office Functions:

• sum use =sum(a1:a5)
• maxuse =max(a1:a5)
• minuse =min(a1:a5)
• stdev for sample standard deviation
• stdevp for population standard deviation

Making a Frequency Distribution

1. Create your classes
2. Next to your classes, create a new column that will be high end of each class (ie in the 5000-5500 class, the high end would be 5500); call this column MAX VALUE
3. Use frequency:
   1. Create a new column labeled Frequency
   2. Select the first row (FOR EXCEL - SELECT THE ENTIRE CELLS THAT FREQUENCY WILL GO IN)
   3. Select insert-function
   4. Select frequency
   5. Check array in lowerleft
   6. Hit next
   7. For data, select data column
   8. For classes, select bin column
   9. Select finish (FOR EXCEL - HIT CTRL SHIFT ENTER)
4. Calculate percentage
   1. Title a new column frequency percent
   2. In the next row, create a function
      1. =g2/total*100 (where g2 is the frequency and total is the total number of value
   3. Select that cell and drag it down for the whole column

Histogram

1. Select the classes column and the frequency (or frequency percent) [both at once]
2. Select the chart button
3. Choose bar graph
4. Select first column as labels and first row as labels.
5. Hit next,next and put in a title and label the axis.
6. Hit finish
7. Now, remove the spacing
   1. (right click on of the columns
   2. click format data series
   3. change spacing to 0%

Frequency Polygon -> Midpoints and Frequency Line graph

1. Create a new column for midpoints
   1. Midpoints are the average of the class low and high (add up divide by 2)

Ogive - Bin and Cumulative Frequency Line graph

Click here for a document about graphs.

For mean, standard deviation

click here examples about finding mean, standard deviation in excel.

Normal distribution table

Categorical (Grouped) Frequency Table

1. Type in all your different class names
2. Select cell next to each class. From the toolbar, select the function (fx) option. Select Statistical
   from the Function category list. Select COUNTIF from the function name list.
3. In the dialog box, select the column that you want to group as the Range.
4. For criteria, typed in quotes the name you want to group like "Food" or just click a cell that has that name.
5. After all the data have been counted, have it sum up the counts: select the sum (E)function. Then select the cells you want to sum and click [Enter].
6. To find the percentages we would type =cell/total

Percentile and relative position

• to find percent:
  • sort
  • find what number it is out of total
• to automatically calculate all percentiles
  • insert function percentrank
  • click array
  • data and values will be the same column of all entries
• to find value given percent:
  • sort
  • multiple percent by n (total number of values)
    • find this value along. So if you want 25% of 14029 mutiply and round 3507. We want the 3507th entry.
• to find relative position (this is how many standard deviations away from the mean it is):
  • (value-mean)/standard deviation