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!

The All New Performance Insights for Splunk

Splunk gives you amazing tools to analyze system data and make business-critical decisions, react to issues, ...

Good Sourcetype Naming

When it comes to getting data in, one of the earliest decisions made is what to use as a sourcetype. Often, ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...