Splunk Search

Calculating FTest and TTest value in Splunk

Veerendra
Loves-to-Learn Lots

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

AB
00.693147
00.693147
1.0986120.693147
0.6931471.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 ResultTTestResult
0.9791903210.081250351

 

Two Arrays are there A and B

Function in excel : FTest(Array1, Array2) = 0.979190321

TTest(Array1, Array2, 2, 2)=0.081250351

Labels (2)
Tags (4)
0 Karma
Get Updates on the Splunk Community!

Infographic provides the TL;DR for the 2023 Splunk Career Impact Report

We’ve been shouting it from the rooftops! The findings from the 2023 Splunk Career Impact Report showing that ...

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...