Using Open Calc to Calculate Statistics
Using Open Calc to Calculate Statistics
Step 1: Enter the following list of number (vertically) into Open Calc.
3, 5, 86,19, 64, 93, 34, 92, 81, 15, 28, 39, 43, 2, 95, 39, 54, 32, 98, 99, 67,87, 88, 92, 12, 98, 76, 77, 71, 65, 73, 81
Step 2: Calculate the mean, mode, median, quartiles, and standard deviation for the data. (See the instructions below)
Step 3: Find what percentile the number 67 falls into.
Step 4: Find the number that is in the 70% percentile.
----------------------------------------------------------------------------------------------------------------
To Find the Mean
AVERAGE
Returns the mean of the data
Syntax
AVERAGE(Number1; Number2; ...Number30)
Number1; Number2;...Number 0 are numerical values or ranges.
Example
=AVERAGE(A1:A50)
To Find the Mode
MODE
Returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.
Syntax
MODE(Number1; Number2; ...Number30)
Number1; Number2;...Number30 are numerical values or ranges.
To Find the Median
MEDIAN
Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.
Syntax
MEDIAN(Number1; Number2; ...Number30)
Number1; Number2;...Number30 are values or ranges, which represent a sample. Each number can also be replaced by a reference.
Example
for an odd number: =MEDIAN(1;5;9;20;21) returns 9 as the median value.
for an even number: =MEDIAN(1;5;9;20) returns the average of the two middle values 5 and 9, thus 7.
To Find the Quartiles
QUARTILE
Returns the quartiles of a data set.
Syntax
QUARTILE(Data; Type)
Data represents the array of data in the sample.
Type represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)
Example
=QUARTILE(A1:A50;1) returns Q1
=QUARTILE(A1:A50;2) returns Q2
=QUARTILE(A1:A50;3) returns Q3
To Find the Standard Deviation
STDEV
Estimates the standard deviation based on a sample.
Syntax
STDEV(Number1; Number2; ...Number30)
Number1, Number2, ... Number30 are numerical values or ranges representing a sample based on an entire population.
Example
=STDEV(A1:A50) returns the estimated standard deviation based on the data referenced.
To Find the Percentile
PERCENTRANK
Returns the percentile of a value in a sample.
Syntax
PERCENTRANK(Data; Value)
Data represents the array of data in the sample.
Value represents the value whose percentile rank must be determined.
Example
=PERCENTRANK(A1:A50;50) returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.
To Find the NUMBER that Goes with a Given Percentile
PERCENTILE
Returns the number in the data set that goes with a given percentile. Eg. =Percentile(A1:A50; 0.30) gives the number in the list from A1 to A50 that fall in the 30th percentile.
Syntax
PERCENTILE(Data; Alpha)
Data represents the array of data.
Alpha represents the percentage of the scale between 0 and 1.
Example
=PERCENTILE(A1:A50;0.1) represents the value in the data set, which equals 10% of the total data scale in A1:A50.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
Related searches
- using baking soda to pass meth test
- using baking soda to clean
- how to calculate yield to maturity formula
- using credit card to pay bills
- using credit card to pay student loan
- how to calculate interest rate using excel
- statistics how to calculate r
- how to calculate distance using acceleration
- how to calculate inflation using cpi
- how to calculate energy using wavelength
- how to calculate percentages using 2 numbers
- using open ended questions