Manuals/calci/FTESTANALYSIS
Jump to navigation
Jump to search
FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 } are array of data.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha} is the significance level.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Newtableflag}
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
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle H_0: \sigma_1 = \sigma_2 }
(null hypothesis, variances are equal)
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle H_0: \sigma_1 \ne \sigma_2 }
(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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} is the data of first array, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} is the data of second array.
- is the significance level which ranges from 0 to 1.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Newtableflag } 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:
is the significance level which ranges from 0 to 1.Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \frac {Sx^2}{Sy^2}} has an F-distribution with n−1 and m−1 degrees of freedom.
- Also Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Sx^2 } is the sample variance of first set of values.
- And Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Sy^2 } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)}
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 } are array of data.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha} is the significance level.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Newtableflag} 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