Understanding TTest_sig with Pivot Table

[shyamcharan]

Hi Expert,

I am trying to create a pivot table that has dimensions as Sector, Zone and station as hierarchy.

I am using the TTest_sig() function to calculate significance value.

However, it does not work for me unless I create 3 different data sets one for Sector, one for Zone and one for Station.

For example:

Original Data Set:

Date	Year month	Sector	Zone	Station	Value
1/01/2017	2017 Jan	Sector1	Zone1	Station1	15
3/01/2017	2017 Jan	Sector1	Zone1	Station3	29
5/01/2017	2017 Jan	Sector1	Zone1	Station5	59
7/01/2017	2017 Jan	Sector1	Zone1	Station7	36
9/01/2017	2017 Jan	Sector1	Zone1	Station9	55
2/01/2017	2017 Jan	Sector1	Zone2	Station2	92
4/01/2017	2017 Jan	Sector1	Zone2	Station4	58
6/01/2017	2017 Jan	Sector1	Zone2	Station6	46
8/01/2017	2017 Jan	Sector1	Zone2	Station8	73
10/01/2017	2017 Jan	Sector1	Zone2	Station10	61
1/02/2017	2018 Jan	Sector1	Zone1	Station1	79
2/02/2017	2018 Jan	Sector1	Zone1	Station3	14
3/02/2017	2018 Jan	Sector1	Zone1	Station5	39
4/02/2017	2018 Jan	Sector1	Zone1	Station7	27
5/02/2017	2018 Jan	Sector1	Zone1	Station9	17
6/02/2017	2018 Jan	Sector1	Zone2	Station2	54
7/02/2017	2018 Jan	Sector1	Zone2	Station4	16
8/02/2017	2018 Jan	Sector1	Zone2	Station6	78
9/02/2017	2018 Jan	Sector1	Zone2	Station8	60
10/02/2017	2018 Jan	Sector1	Zone2	Station10	54

Will the TTest_sig work currectly only when I have three different data sets like below?

    Group by Sector data set

Sector.Date	Year Month	Sector	Value
1/01/2017	2017 Jan	Sector1	522
2/01/2017	2017 Jan	Sector1	434
1/01/2018	2018 Jan	Sector1	521
2/01/2018	2018 Jan	Sector1	447

     Group by Zonedata set

Zone.Date	Zone.Year Month	Zone.Zone	Zone.Value
1/01/2017	2017 Jan	Zone1	263
1/01/2017	2017 Jan	Zone2	259
2/01/2017	2017 Jan	Zone1	240
2/01/2017	2017 Jan	Zone2	194
1/01/2018	2018 Jan	Zone1	267
1/01/2018	2018 Jan	Zone2	254
2/01/2018	2018 Jan	Zone1	234
2/01/2018	2018 Jan	Zone2	213

I get different results when calculating the TTest for the same data set but grouped differently. Please see the attache sample file.

Does this mean I have to create different set of data (as grouped above) to get correct results?

Regards,

Shyam

[shyamcharan]

Hi There,

Can anyone please help me with my request ?

Thanks in advance.

Regards,

Shyam

[shyamcharan]

Hi Sunny,

Can you please help me with the above request?

stalwar1

I tried to use the SUM() in the function but it does not work.

TTest_Sig([OriginalDataSet.Year Month],[OriginalDataSet.Value])