Difference between revisions of "Manuals/calci/FTESTANALYSIS"
Jump to navigation
Jump to search
(13 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''FTESTANALYSIS( | + | <div style="font-size:30px">'''FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)'''</div><br/> |
− | *<math> | + | *<math>Array1</math> and <math>Array2 </math> are array of data. |
− | *<math> | + | *<math>Alpha</math> is the significance level. |
− | *<math> | + | *<math>Newtableflag</math> is the logical value. |
+ | **FTESTANALYSIS(), compares the variances between two group of data. | ||
==Description== | ==Description== | ||
Line 14: | Line 15: | ||
*For example, the comparison of SCORES across GROUPS,where there are two groups. | *For example, the comparison of SCORES across GROUPS,where there are two groups. | ||
*The purpose is to determine if the mean SCORE on a test is different for the two groups tested (i.e., control and treatment groups) | *The purpose is to determine if the mean SCORE on a test is different for the two groups tested (i.e., control and treatment groups) | ||
− | *In FTESTANALYSIS( | + | *In FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag) where <math>Array1</math> is the data of first array, <math>Array2</math> is the data of second array. |
− | *<math> | + | *<math> Alpha </math> is the significance level which ranges from 0 to 1. |
− | *<math> | + | *<math> Newtableflag </math> is the logical value like TRUE or FALSE. |
*TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE. | *TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE. | ||
*The F statistic of this function calculated by: | *The F statistic of this function calculated by: | ||
− | <math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with | + | <math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with n−1 and m−1 degrees of freedom. |
*Also <math>Sx^2 </math> is the sample variance of first set of values. | *Also <math>Sx^2 </math> is the sample variance of first set of values. | ||
*And <math>Sy^2 </math> is the sample variance of second set of values. | *And <math>Sy^2 </math> is the sample variance of second set of values. | ||
Line 28: | Line 29: | ||
*In this function the array may be any numbers, names, or references that contains numbers. | *In this function the array may be any numbers, names, or references that contains numbers. | ||
*values are not considered if the array contains any text, logical values or empty cells. | *values are not considered if the array contains any text, logical values or empty cells. | ||
− | When the <math> | + | When the <math>Array1</math> or <math>Array2</math> is less than 2 or the variance of the array value is zero, then this function will return the result as error. |
+ | |||
+ | ==ZOS== | ||
+ | *The syntax is to use this function in ZOS is <math>FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)</math> | ||
+ | **<math>Array1</math> and <math>Array2 </math> are array of data. | ||
+ | **<math>Alpha</math> is the significance level. | ||
+ | **<math>Newtableflag</math> is the logical value. | ||
+ | *For e.g.,FTESTANALYSIS([17,22,26,31,49],[50,47,45,13,24],0.4,true) | ||
+ | *FTESTANALYSIS([24..30],[45..51],0.4,true) | ||
==Examples== | ==Examples== | ||
1. | 1. | ||
− | {| class="wikitable" | + | {| class="wikitable" |
− | + | |+Spreadsheet | |
− | + | |- | |
− | + | ! !! A !! B | |
− | + | |- | |
− | + | ! 1 | |
− | + | |15 || 21 | |
+ | |- | ||
+ | ! 2 | ||
+ | |27 || 12 | ||
+ | |- | ||
+ | ! 3 | ||
+ | |19 || 30 | ||
+ | |- | ||
+ | ! 4 | ||
+ | |32 || 11 | ||
|} | |} | ||
+ | =FTESTANALYSIS(A1:A4,B1:B4,0.5,TRUE) | ||
{| class="wikitable" | {| class="wikitable" | ||
− | + | |+Result | |
− | + | |- | |
− | + | ! !!Variable1 !! Variable2 | |
− | + | |- | |
− | + | ! Mean | |
− | + | | 23.25 || 18.5 | |
+ | |- | ||
+ | ! Variance | ||
+ | | 58.916666666666664 || 79 | ||
+ | |- | ||
+ | ! Observations | ||
+ | | 4 || 4 | ||
+ | |- | ||
+ | ! Degree Of Freedom | ||
+ | | 3 || 3 | ||
+ | |- | ||
+ | ! F-Value | ||
+ | | 0.7457805907172995 || | ||
+ | |- | ||
+ | ! P(F<=f) one-tail | ||
+ | | 0.407624533735915 || | ||
+ | |- | ||
+ | ! F Critical one-tail | ||
+ | | 1 || | ||
|} | |} | ||
− | + | ||
− | |||
2. | 2. | ||
− | {| class="wikitable" | + | {| class="wikitable" |
− | + | |+Spreadsheet | |
− | + | |- | |
− | + | ! !! A !! B | |
− | + | |- | |
− | + | ! 1 | |
− | + | |5 || 10 | |
− | + | |- | |
+ | ! 2 | ||
+ | |8 || 20 | ||
+ | |- | ||
+ | ! 3 | ||
+ | |12 || 30 | ||
+ | |- | ||
+ | ! 4 | ||
+ | |45 || 40 | ||
+ | |- | ||
+ | ! 5 | ||
+ | |23 || 50 | ||
|} | |} | ||
+ | =FTEST(A1:A5,B1:B5,0.30,false) | ||
{| class="wikitable" | {| class="wikitable" | ||
− | + | |+Result | |
− | + | |- | |
− | + | ! !!Variable1 !! Variable2 | |
− | + | |- | |
− | + | ! Mean | |
− | + | | 18.6 || 30 | |
− | + | |- | |
− | | | + | ! Variance |
− | + | | 264.29999999999995 || 250 | |
− | + | |- | |
− | + | ! Observations | |
− | + | | 5 || 5 | |
− | + | |- | |
− | + | ! Degree Of Freedom | |
− | + | | 4 || 4 | |
− | + | |- | |
+ | ! F-Value | ||
+ | | 1.0572 || | ||
+ | |- | ||
+ | ! P(F<=f) one-tail | ||
+ | | 0.4791517866106137 || | ||
+ | |- | ||
+ | ! F Critical one-tail | ||
+ | | 1.7528541706121352 || | ||
|} | |} | ||
− | + | ==Related Videos== | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | {{#ev:youtube|G_RDxAZJ-ug|280|center|F Distribution}} | |
− | { | ||
− | |||
− | |||
− | |||
− | |||
− | {| | ||
− | |||
− | |||
− | |||
− | |||
− | |} | ||
− | |||
==See Also== | ==See Also== | ||
+ | *[[Manuals/calci/FTEST | FTEST ]] | ||
*[[Manuals/calci/FDIST | FDIST ]] | *[[Manuals/calci/FDIST | FDIST ]] | ||
*[[Manuals/calci/FINV | FINV ]] | *[[Manuals/calci/FINV | FINV ]] | ||
Line 112: | Line 149: | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/F-test F Test] | [http://en.wikipedia.org/wiki/F-test F Test] | ||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 17:07, 7 August 2018
FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)
- and are array of data.
- is the significance level.
- is the logical value.
- FTESTANALYSIS(), compares the variances between two group of data.
Description
- This function gives the analysis of variance.
- This statistics used to determine the significant difference of three or more variables or multivariate collected from experimental
research.
- So this analysis is depending on the hypothesis.
- The hypotheses for this test are
(null hypothesis, variances are equal) (alternative hypothesis, variances are not equal)
- For example, the comparison of SCORES across GROUPS,where there are two groups.
- The purpose is to determine if the mean SCORE on a test is different for the two groups tested (i.e., control and treatment groups)
- In FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag) where is the data of first array, is the data of second array.
- is the significance level which ranges from 0 to 1.
- is the logical value like TRUE or FALSE.
- TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.
- The F statistic of this function calculated by:
has an F-distribution with n−1 and m−1 degrees of freedom.
- Also is the sample variance of first set of values.
- And is the sample variance of second set of values.
- If the f-value from the test is higher than the f-critical value then the null hypothesis should be rejected and the variances are unequal.
- So the following cases will occur:
- If the variances are assumed to NOT be equal, proceed with the t-test that assumes non-equal variances.
- If the variances are assumed to be equal, proceed with the t-test that assumes equal variances.
- In this function the array may be any numbers, names, or references that contains numbers.
- values are not considered if the array contains any text, logical values or empty cells.
When the or is less than 2 or the variance of the array value is zero, then this function will return the result as error.
ZOS
- The syntax is to use this function in ZOS is
- and are array of data.
- is the significance level.
- is the logical value.
- For e.g.,FTESTANALYSIS([17,22,26,31,49],[50,47,45,13,24],0.4,true)
- FTESTANALYSIS([24..30],[45..51],0.4,true)
Examples
1.
A | B | |
---|---|---|
1 | 15 | 21 |
2 | 27 | 12 |
3 | 19 | 30 |
4 | 32 | 11 |
=FTESTANALYSIS(A1:A4,B1:B4,0.5,TRUE)
Variable1 | Variable2 | |
---|---|---|
Mean | 23.25 | 18.5 |
Variance | 58.916666666666664 | 79 |
Observations | 4 | 4 |
Degree Of Freedom | 3 | 3 |
F-Value | 0.7457805907172995 | |
P(F<=f) one-tail | 0.407624533735915 | |
F Critical one-tail | 1 |
2.
A | B | |
---|---|---|
1 | 5 | 10 |
2 | 8 | 20 |
3 | 12 | 30 |
4 | 45 | 40 |
5 | 23 | 50 |
=FTEST(A1:A5,B1:B5,0.30,false)
Variable1 | Variable2 | |
---|---|---|
Mean | 18.6 | 30 |
Variance | 264.29999999999995 | 250 |
Observations | 5 | 5 |
Degree Of Freedom | 4 | 4 |
F-Value | 1.0572 | |
P(F<=f) one-tail | 0.4791517866106137 | |
F Critical one-tail | 1.7528541706121352 |
Related Videos
See Also
References