I have the below values in Excel for which Fvalue is given by FTest function of excel.
I want to replicate the result in Splunk. Please help
| A | B |
| 0 | 0.693147 |
| 0 | 0.693147 |
| 1.098612 | 0.693147 |
| 0.693147 | 1.609438 |
| 0 | |
| 0 | |
| 0.693147 | |
| 0.693147 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0.693147 | |
| 1.386294 | |
| 0 | |
| 0 | |
| 0 | |
| 1.098612 | |
| 0.693147 | |
| 0 | |
| 1.098612 | |
| 0.693147 | |
| 0 | |
| 0.693147 | |
| 1.386294 | |
| FTest Result | TTestResult |
| 0.979190321 | 0.081250351 |
Two Arrays are there A and B
Function in excel : FTest(Array1, Array2) = 0.979190321
TTest(Array1, Array2, 2, 2)=0.081250351