Access over 35 million academic & study documents

Parameters in Statistics

Content type
User Generated
Subject
Statistics
Type
Note
Rating
Showing Page:
1/6
Statistics in Method Validation
Parameters in Statistics
Statistical analyses is required for the interpretation of obtained Data. Following are the
parameters required for doing the same.
1) Average
2) Standard Deviation
3) Relative Standard Deviation
4) Linear Regression analyses ( Slope, y-intercept, correlation coefficient ( r) and r
2
1) Average
The average result, , is calculated by summing the individual results and
dividing this sum by the number (n) of individual values
In MS-Excel
Returns the average of the arguments
AVERAGE (number1, number2…)
Number1, Number2 … are 1 to 30 numeric arguments for which want the
average
The arguments must either be numbers or be names, arrays, or references
that contain numbers.
If an array or reference argument contains text, logical values, or empty cells
those values are ignored; however, cells with the value zero are included
Example

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/6
Statistics in Method Validation
2) Standard Deviation
The standard deviation is a measure of how precise the average is, that is, how
well the individual numbers agree with each other. It is a measure of a type of
error called random error - the kind of error people can’t control very well. It is
calculated as follows:
In-MS-Excel
Estimates standard deviation based on a sample. The standard deviation
is a measure of how widely values are dispersed from the average value.
STDEV (number1, number2,...)
Number1, Number2.. are 1 to 30 number arguments corresponding to a
sample of a population. You can also use a single array or a reference to
an array instead of arguments separated by commas.
STDEV assumes that its arguments are a sample of the population.
STDEV uses the following formula:
where x is the sample mean AVERAGE(number1,number2,…) and n is
the sample size.
Example

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/6

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 6 pages?
Access Now
Unformatted Attachment Preview
 Parameters in Statistics Statistical analyses is required for the interpretation of obtained Data. Following are the parameters required for doing the same. 1) Average 2) Standard Deviation 3) Relative Standard Deviation 4) Linear Regression analyses ( Slope, y-intercept, correlation coefficient ( r) and r2 1) Average The average result,, is calculated by summing the individual results and dividing this sum by the number (n) of individual values In MS-Excel Returns the average of the arguments AVERAGE (number1, number2…) Number1, Number2 … are 1 to 30 numeric arguments for which want the average The arguments must either be numbers or be names, arrays, or references that contain numbers. If an array or reference argument contains text, logical values, or empty cells those values are ignored; however, cells with the value zero are included Example 2) Standard Deviation The standard deviation is a measure of how precise the average is, that is, how well the individual numbers agree with each other. It is a measure of a type of error called random error - the kind of error people can’t control very well. It is calculated as follows: In-MS-Excel Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value. STDEV (number1, number2,...) Number1, Number2.. are 1 to 30 number arguments corresponding to a sample of a population. You can also use a single array or a ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4