Manuals/calci/CALCITOCHECKFIXED

ROWS function

• The function displays #NULL error with arguments as array values.

e.g. ROWS({1,2;3,4;5,6})

Expected result: 3

Observed result: #NULL

ROWS EXPLANATION

This will work only in CALCI as the {} notation for array is useful only in spreadsheet platforms and similar languages. In ZOS arrays are to be indicated by [] and Objects will use {} notation.

Rows Function Test Comments

Reading the explanation, this issue can be ignored. --- (4/29/2014)Swapna

RANDOMNUMBERGENERATION, RANDOMNUMBERGENERATIONUNIFORM, RANDOMUNIFORM, PATTERENED

• Random number output is not displayed. Same command is displayed on space cube.

e.g. =RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)

=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4) 

RANDOMNUMBERGENERATION(30, 4, "Uniform", TRUE, 3, 4)

3.195449711289257	3.2248697481118143	3.0816136938519776	3.2126745639834553	3.990793523611501	3.649687875760719	3.759418284520507	3.965467617381364	3.9545328468084335	3.3741041221655905	3.1905515757389367	3.777756262337789	3.9837128871586174	3.432979935547337	3.9010994143318385	3.7845077733509243	3.421978456666693	3.813554910942912	3.168992273742333	3.2010161119978875	3.9937344735953957	3.459437067853287	3.384454872459173	3.0950622770469636	3.1798048589844257	3.407964985817671	3.6846570973284543	3.6611867914907634	3.9072526150848716	3.2141497172415257
3.2669153639581054	3.2465451690368354	3.0314107462763786	3.88823653687723	3.6240376371424645	3.0279260887764394	3.4216481952462345	3.747306031640619	3.515739459078759	3.175762218190357	3.6369324799161404	3.7142539599444717	3.6433018636889756	3.133950341725722	3.6951540084555745	3.4156028230208904	3.240273320581764	3.4762711247894913	3.7170767160132527	3.180914681404829	3.9355433725286275	3.0196601944044232	3.3859861323144287	3.854840762214735	3.37747969920747	3.7828165935352445	3.326533603016287	3.7698845479171723	3.1485248988028616	3.0072317481972277
3.9251055871136487	3.2557102914433926	3.788066220469773	3.207987993489951	3.588850313099101	3.870454262243584	3.9496661769226193	3.4028041230048984	3.6568462373688817	3.6426883353851736	3.9649933751206845	3.2784565046895295	3.246733759297058	3.380512889707461	3.0992100907023996	3.739959954516962	3.3115603323094547	3.2317469376139343	3.5847271364182234	3.594636262860149	3.9285641501192003	3.712517147185281	3.9386905138380826	3.8844250414986163	3.1710384245961905	3.583163051167503	3.137686180183664	3.990223975619301	3.3122955770231783	3.6850603164639324
3.162752259755507	3.126228274544701	3.4762895670719445	3.242924148682505	3.0085414829663932	3.9302729363553226	3.777372183976695	3.940537365153432	3.640196947613731	3.316979159368202	3.1863948297686875	3.9217444960959256	3.964422813616693	3.0397708313539624	3.883876184700057	3.882750508841127	3.485125683248043	3.8928709470201284	3.5129915438592434	3.0280541735701263	3.621288023889065	3.5997950434684753	3.1812141358386725	3.4793242022860795	3.4653837154619396	3.982316398760304	3.9729056453797966	3.0827220352366567	3.775389570510015	3.457127903588116

Is this correct?

Has been corrected so that true false flag will show inside a cube or on ZOS.

Please check this in the next release

(In ZOS it will show result in the window. In CALCI it will create a new window depending on request flag).

RANDOMNUMBERGENERATION Test Comments

Issue resolved. Working ---- (4/29/2014)Swapna

MATCH(lkup_val, lkup_arr, m_type)

Issue: Function does not work in ZOS if lkup_arr represented with {} brackets, whereas works with [ ].

• ZCalci works with both type of array representation {}, [] and displays correct results -

e.g.

• MATCH(44,{40,42,44},1) does not work in ZOS.
• MATCH(44,[40,42,44],1) returns relative position of '44' as 3 in ZOS.

MATCH EXPLANATION

See after new release if issue persists.

Match Function Test Comments

{} notation works in spreadsheet platforms. Hence {},[] both work in Calci and [] works in ZOS. This issue can be ignored --- (4/29/2014)Swapna

MID(txt, snum, noc)

Issue: Returns #NULL error, if 'txt' starts with a number.

e.g.

• MID("123456",2,4) returns NULL.
• MID("A123456",2,4) returns A123

MID Function Test Comments

Issue resolved. Working ----- (4/29/2014)Swapna

SUBSTITUTE(txt, otxt, ntxt, instnum)

Use: Function is used to replace nth instance of 'otxt' with 'ntxt'. Original string is in 'txt'.

Issue: If the original string starts with number, Calci displays NULL error.

e.g.

SUBSTITUTE("123456","123","888",1)

• Expected result: "888456"
• Observed result: #NULL (In Calci)
• Works well in ZOS.

SUBSTITUTE Function Test Comments

Issue resolved. Working ----- (4/29/2014)Swapna

FVSCHEDULE(Principal, Schedule)

Issue: Calci O/p does not match with that in Excel.

e.g. 1)FVSCHEDULE(2,{0.01,0.56,0.02})

• O/p in Excel: 3.214224
• O/p in Calci:

Principal	Schedule	FVSCHEDULE
2	0.01	2
2	0.56	2
2	0.02	2

• Test Comments (FVSCHEDULE):

-- Issue still persists as mentioned. --- Swapna

Fixed: FVSCHEDULE(2,[0.01,0.56,0.02]) 3.214224 04/28/2014 jp

FVSCHEDULE Function Test Comments

-- Issue resolved. Working -- (4/30/2014) Swapna

TBILLYIELD(SettlementDate, MaturityDate, Price)

Issue: Displays #NULL error for all examples.

e.g. TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9)

• Output in Excel : 0.096241
• Output in ZOS : #NULL (and for any other example)

• Test Comments (TBILLYIELD):

-- Issue still persists as mentioned. --- Swapna

Fixed 04/28/2014 TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) 0.09624107600678411

TBILLYIELD Function Test Comments

-- Issue resolved. Working -- (4/30/2014) Swapna

HISTOGRAM(SomeArray,BinRange,SomePareToFlag, SomeCumulativeFlag, SomeChartFlag, NewTableFlag)

Propery of NewTableFlag:

• $NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
• If $NewTableFlag$ is TRUE, the result is displayed on new zspace sheet.

Output Observed:

For TRUE, result table in Calci shows (both on new zspace)

• Bin, Frequency columns and
• two more columns showing Bin and Frequency in descending order

For FALSE, Calci displays only Bin and Frequency columns (on new zspace).

Please check this in the next release

• Test Comments (HISTOGRAM):

-- Issue still persists as mentioned. O/p displayed in new zspace for both TRUE and FALSE flags. --- Swapna

• Test Comments: (4/30/2014)Swapna

Syntax: HISTOGRAM(Array, BinRange, NewTableFlag)

e.g. A1:A7 --> 1,7,12,17,20,37,50 B1:B5 --> 10,20,30,40,50

=HISTOGRAM(A1:A7,B1:B5,"TRUE") or =HISTOGRAM(A1:A7,B1:B5,TRUE)
=HISTOGRAM(A1:A7,B1:B5,"FALSE") or =HISTOGRAM(A1:A7,B1:B5,FALSE)

--O/P values displayed correctly with no extra columns when NewTableFlag written in double quotes as "TRUE". Extra columns displayed when written without quotes e.g. TRUE.

--O/p displayed on new cube for both TRUE and FALSE values of 'NewTableFlag'.

-- Issue still persists as mentioned. --- Swapna (5/5/14)

Syntax is: HISTOGRAM(SomeArray,BinRange,SomePareToFlag, SomeCumulativeFlag, SomeChartFlag, NewTableFlag)

Can you retry after next release?

HISTOGRAM Function Test Comments

Results showing correctly. O/P values match with excel. NewTableFlag functions properly

...Issue resolved. Working --- Swapna (5/18/14)

MOVINGAVERAGE(SomeArray,PeriodInterval,ShowChart, ShowStandardErrorOptions,NewTableFlag)

• $NewTableFlag$ if TRUE, should display output on new zspace cube.
• $NewTableFlag$ if FALSE, should display output on same calci sheet of the data and command.

Observed Output:

• Output displayed on new zspace cube for both TRUE and FALSE.

Please check this in the next release

• Test Comments:

--Issue still persists as mentioned. O/p displayed in new zspace for both TRUE and FALSE flags --- Swapna

• Test Comments : (4/30/2014) Swapna

e.g. Consider the below example-

Period	Array Input
0	0
1	45.5
2	60
3	200
4	160
5	300
6	340
7	310
8	500
9	566
10	610

=MOVINGAVERAGE(B3:B13,6,TRUE)
=MOVINGAVERAGE(B3:B13,6,FALSE)

--Issue: In Calci, O/p displayed on new cube for both TRUE and FALSE values of 'NewTableFlag'.

-- Issue still persists as mentioned. --- Swapna (5/5/14)

==05/16/2014 Syntax is: MOVINGAVERAGE(SomeArray,PeriodInterval,ShowChart, ShowStandardErrorOptions,NewTableFlag)

Here ShowChart will be implemented later.

MOVINGAVERAGE Function Test Comments

Results showing correctly. O/P values match with excel. 'NewTableFlag' functions correctly...Issue resolved. Working --- Swapna (5/18/14)

EXPONENTIALSMOOTHING(SomeArray,DampingFactor,ShowChart,ShowStandardErrorOptions,NewTableFlag)

• $NewTableFlag$ if TRUE, should display output on new zspace cube.
• $NewTableFlag$ if FALSE, should display output on same calci sheet of the data and command.

Observed Output:

• Output displayed on new zspace cube for both TRUE and FALSE.

Please check this in the next release

• Test Comments (EXPONENTIALSMOOTHING):

-- Issue still persists as mentioned. O/p displayed in new zspace for both TRUE and FALSE flags. --- Swapna

== please give an example for this.

• Test Comments : (4/30/2014) Swapna

e.g. Consider the following example -

Period	Array Input
0	0
1	45.5
2	60
3	200
4	160
5	300
6	340
7	310
8	500
9	566
10	610

=EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE)
=EXPONENTIALSMOOTHING(B3:B13,0.2,FALSE)

--Issue: In Calci, O/p displayed on new cube for both TRUE and FALSE values of 'NewTableFlag'.

-- Issue still persists as mentioned. --- Swapna (5/5/14)

==05/16/2014 Syntax is XPONENTIALSMOOTHING (Array,DampingFactor,ShowChart, ShowStandardErrorOptions,NewTableFlag)

EXPONENTIALSMOOTHING Function Test Comments

Results showing correctly. O/P values match with excel. 'NewTableFlag' functions correctly...Issue resolved. Working --- Swapna (5/18/14)

DB(C, Salvage, L, P, M)

• For non-integer values of P and M, CALCI rounds up. Excels calculates with exact values.
• Result differs with that in Excel -

Function	CALCI	EXCEL
DB(20000,2000,5,5,6.6)	1477.8488..	$1512.06
DB(20000,2000,5,4.4,6)	477.054249	$2396.29

• Test Comments (DB):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (5/01/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

05/15/2014 fixed internally. check in release. DB(20000,2000,5,5,6.6) 1512.0578420784902 Execution Time: (Step 1)4154 msec. Execution Time:4227 msec. $>DB(20000,2000,5,4.4,6) 2396.28818079

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

--5/21/2014 jp DB(20000,2000,5,5,6.6) 1512.0578420784902 Execution Time: (Step 1)16 msec. Execution Time:109 msec. $>DB(20000,2000,5,4.4,6) 2396.28818079

Next release.

DB Function Test Comments

Results showing correctly. O/P values match with excel. ....Issue resolved. Working --- Swapna (7/30/14)

Function	CALCI	EXCEL
DB(20000,2000,5,5,6.6)	1512.0578420784902	$1512.06
DB(20000,2000,5,4.4,6)	2396.28818079	$2396.29

DDB(C, Salvage, L, P, F)

• For non-integer values of P, CALCI rounds up. Excels calculates with exact values.
• Result differs with that in Excel -

Function	CALCI	EXCEL
DDB(10000,200,5,4.5,2)	1096	$669.25
DDB(10000,200,5,3.7,2)	1096	$1007.09

• Test Comments (DDB):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (5/01/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

-- Issue still persists as mentioned. --- Swapna (5/18/14)

--5/21/2014 jp fixed. test next release. DDB(10000,200,5,4.5,2) 669.2515222246417 Execution Time: (Step 1)24 msec. Execution Time:81 msec. $>DDB(10000,200,5,3.7,2) 1007.0901941967786 Execution Time: (Step 1)15 msec. Execution Time:82 msec. $>DDB(300,500,5,3.7,2) 0

DDB Function Test Comments

Results showing correctly. O/P values match with excel. ....Issue resolved. Working --- Swapna (7/30/14)

Function	CALCI	EXCEL
DDB(10000,200,5,4.5,2)	669.2515222246417	$669.25
DDB(10000,200,5,3.7,2)	1007.0901941967786	$1007.09

FIBONNACI(SomeNumber)

Suggestion: The correct spelling for function should be FIBONACCI, else user may not find the function.

• Test Comments (FIBONNACI):

-- Issue still persists as mentioned. --- Swapna

Both spellings supported. 04/28/2014 jp

• Test Comments:

--Returns a #NULL error when used the spelling as FIBONACCI(5) -- (4/30/2014) Swapna

-- Issue still persists as mentioned. --- Swapna (5/5/14)

5/15/2014 Fixed as: FIBONACCI(5) [0, 1, 1, 2, 3, 5] FIBONNACI(5) [0, 1, 1, 2, 3, 5]

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

FIBONNACI/FIBONACCI Function Test Comments

Results showing correctly. Both spellings FIBONNACI, FIBONACCI supported. e.g FIBONNACI(6)gives [0 1 1 2 3 5 8] , FIBONACCI(6) gives [0 1 1 2 3 5 8] ....Issue resolved. Working --- Swapna (7/30/14)

NETWORKDAYS(start_date, end_date, [holidays])

Issue: Incorrect result for following example: A1= 1/1/2014 , A2= 2/28/2014

NETWORKDAYS(A1,A2) displays 41.

Correct result is 43

• Test Comments (NETWORKDAYS):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (4/30/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

== 5/16/2014 Fixed. Please check for a variety of dates and this in next release. Nice catch.

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

NETWORKDAYS Function Test Comments

Results showing correctly. Results match with Excel

e.g. 1)A1= 1/1/2014 , A2= 2/28/2014

NETWORKDAYS(A1,A2) displays 43.

2)B1= 7/22/2014 , B2= 8/17/2014

NETWORKDAYS(B1,B2) displays 19.

3)C1= 12/1/2013 , C2= 3/1/2014

NETWORKDAYS(C1,C2) displays 65.

....Issue resolved. Working --- Swapna (7/30/14)

RANDOMNUMBERGENERATION BERNOULLI

Syntax: RANDOMNUMBERGENERATION(NumVariable,RandomNumber,"Bernoulli",NewTableFlag,ProbabilityValue)

=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)

Issue: Output not displayed. Displays result table values as 'undefined'.

• Test Comments (RANDOMNUMBERGENERATION BERNOULLI):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (5/01/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

==Fixed 5/16/2014

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

RANDOMNUMBERGERNERATION BERNOULLI Function Test Comments

Results showing correctly. e.g.

=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5) displays [0,1,1   1,1,1   0,0,1   0,0,0] 

....Issue resolved. Working --- Swapna (7/31/14)

HYPERLINK

• Link to specified location gets created in Calci. But document/website does not open up.

e.g.

=HYPERLINK("http://www.google.com","Click here")

• Test Comments (HYPERLINK)

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. -- Swapna(5/2/14)

-- Issue still persists as mentioned. -- Swapna(5/5/14)

-- Issue still persists as mentioned. -- Swapna(5/18/14)

HYPERLINK Function Test Comments

Results showing correctly. ....Issue resolved. Working --- Swapna (7/31/14)

SEARCH(ftext, otext, snum), SEARCHB, FIND, FINDB

Use: Function searches string 'ftext' in 'otext'. Search to begin from position mentioned in 'snum'.

Issue: If 'snum' is non-integer, the result also is non-integer.

suggestion: If 'snum' is non-integer, it should be truncated and then search should be carried out.

e.g.1)

=SEARCH("C","WELCOME",2.2) 

• Expected result: 4
• Observed result: 4.2

e.g.2)

=FIND("a","Banana",3.1) 

• Expected result: 4
• Observed result: 4.1

Similar issue with SEARCHB, FINDB

• Test Comments (SEARCH):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (4/30/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

Fixed 5/15/2014 jp =MID(A5,SEARCH("""",A5)+1,SEARCH("""",A5,SEARCH("""",A5)+1)-SEARCH("""",A5)-1) may need to be given as: =MID(A5,SEARCH("\"",A5)+1,SEARCH("\"",A5,SEARCH("\"",A5)+1)-SEARCH("\"",A5)-1) (Since "" is excel escaping, CALCI is \" as in javascript.

-- Output result not reflecting as fixed. Issue still persists as mentioned. ---- Swapna (5/18/14)

SEARCH, SEARCHB, FIND, FINDB Function Test Comments

Results showing correctly. e.g.1)

=SEARCH("C","WELCOME",2.2) 

• Expected result: 4
• Observed result: 4

e.g.2)

=FIND("a","Banana",3.1) 

• Expected result: 4
• Observed result: 4

....Issue resolved. Working --- Swapna (7/31/14)

ANOVASINGLEFACTOR

• Function displays correct results for analysis by "COLUMNS" option. But is incorrect for "ROWS"

e.g. Consider the example on page http://wiki.zcubes.com/Manuals/calci/ANOVASINGLEFACTOR

=ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays same result as with COLUMNS (which is incorrect). Only COLUMNS 1,2 are replaced with ROW 1, 2.

ANOVASINGLEFACTOR([1 3;7 8; 12 5;17 18],0.05,"COLUMNS",TRUE) gave result in ZOS: ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"COLUMNS",TRUE)

Anova: Single Factor SUMMARY

Groups	Count	Sum	Average	Variance
Column1	2	4	2	2
Column2	2	15	7.5	0.5
Column3	2	17	8.5	24.5
Column4	2	35	17.5	0.5

ANOVA

Source of Variation	Sum of Squares	Degree of Freedom	Mean of Squares	F	Probability	F Critical
Between Groups:	247.375	3	82.45833333333333	11.993939393939394	0.018128968083516894	6.591451475716938
Within Groups:	27.5	4	6.875
Total:	274.875	7

Please check this in the next release

• Test Comments:

-- Analysis by "ROWS" returns the same result values as that of "COLUMNS". e.g. ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"COLUMNS",TRUE) returns same result as ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"ROWS",TRUE) --Only the text is changed from Column1,Column2,Column3,Column4 to Row1,Row2,Row3,Row4 --- Swapna

-- Issue still persists as mentioned. -- Swapna(5/2/14)

• Test Comments-- Swapna (5/5/14)

1)Displays correct result for - =ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"Columns",TRUE) -Works for COLUMNS, columns

2)Displays correct result for - =ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"Rows",TRUE)

Anova: Single Factor SUMMARY

Groups	Count	Sum	Average	Variance
Row1	4	37	9.25	46.916666666666664
Row2	4	34	8.5	44.333333333333336

ANOVA

Source of Variation	Sum of Squares	Degree of Freedom	Mean of Squares	F	Probability	F Critical
Between Groups:	1.125	1	1.125	0.024657534246575342	0.8886077621608085	5.987702296337573
Within Groups:	273.75	6	45.625
Total:	274.875	7

-Incorrect result for ROWS, rows (Shows same result as that with 'Columns' only replacing Column1, Column2....with Row1,Row2....etc.

• Test Comments: Issue still persists as mentioned. -- Swapna(5/18/14)

ANOVASINGLEFACTOR Function Test Comments

Results showing correctly for -

=ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"Rows",TRUE)
=ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"ROWS",TRUE)
=ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"rows",TRUE)

....Issue resolved. Working --- Swapna (8/1/14)

COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)

Issue: Calci does analysis by Columns when "ROWS" (all capital letters)or "rows" (all small letters) is used. Functions properly for Rows(first letter capital). Actually Columns is default method of analysis.

e.g Array A = 4,5,6,7 , Array B = 8,9,10,11

• COVARIANCEDATAANALYSIS(A1:B4,"ROWS",TRUE) or COVARIANCEDATAANALYSIS(A1:B4,"rows",TRUE) - does analysis by Columns

• Correct result for - COVARIANCEDATAANALYSIS(A1:B4,"Rows",TRUE)

• Test Comments (COVARIANCE):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (4/30/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

==05/16/2014 GroupBy issue fixed. Please check next release.

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

COVARIANCEDATAANALYSIS Function Test Comments

Results showing correctly for GroupBy 'ROWS', 'rows', 'Rows'- ....Issue resolved. Working --- Swapna (8/1/14)

DESCRIPTIVESTATISTICS function

Syntax: DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)

• Issue1: Even if NewTableFlag = FALSE, o/p displayed in different Zspace. Not on same sheet where command is written.
• Issue2: Calci does analysis by Columns when "ROWS" (all capital letters)or "rows" (all small letters) is used. Functions properly for Rows(first letter capital).

Actually Columns is default method of analysis.

• Test Comments (DESCRIPTIVESTATISTICS):

-- 1)Issue still persists as mentioned. O/p displayed in new zspace for both TRUE and FALSE flags. -- 2)Analysis results by "rows" or "ROWS" are correct. Only the heading displayed as Column 1, Column2, Column 3 etc instead of Row 1, Row 2, Row 3 etc. --- Swapna

• Test Comments : (4/30/2014) Swapna

e.g. Consider the following example-

	Column1	Column2	Column3	Column4
Row1	8	8
Row2	7	8
Row3	11	11
Row4	7	18
Row5	33	37
Row6

=DESCRIPTIVESTATISTICS(A2:B5,"Columns",95,1,1,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,TRUE)

--Issue1: O/p displayed on new Zspace irrespective of NewTableFlag 'TRUE' or 'FALSE'.

--Issue2: O/p displayed correctly with 'GroupBy' argument as Rows. When used as 'ROWS' or 'rows', the headings in o/p tables are displayed as Column1, Column2, Column3 ....etc instead of Row1, Row2, Row3 ...etc.

-- Issue still persists as mentioned. --- Swapna (5/5/14)

==05/16/2014 GroupBy issue fixed. Please check next release.

• Test Comments:

Output result not reflecting as fixed. Issue still persists as mentioned. --- Swapna (5/18/14)

DESCRIPTIVESTATISTICS Function Test Comments

Issue2 resolved. Results matching for GroupBy 'ROWS', 'rows', 'Rows'- ....Issue2 resolved. Working --- Swapna (8/1/14)

SPHERE(Radius)

Issue: Output not getting displayed.

• Test Comments (SPHERE):

-- Issue still persists as mentioned. --- Swapna

-- Issue still persists as mentioned. --- Swapna (5/01/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

-- Issue still persists as mentioned. --- Swapna (5/18/14)

SPHERE Function Test Comments

• Output displayed correctly ...Issue Resolved...Working... e.g. SPHERE(100), (1..100..20@SPHERE), ZC(1..100@SPHERE) .. Swapna (8/1/14)

HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)

• Test Comments --- Swapna (5/18/14)

e.g A1:A7 --> 1,7,12,17,20,37,50

B1:B5 --> 10,20,30,40,50

HISTOGRAM(A1:A7,B1:B5,TRUE,TRUE,TRUE,TRUE)

HISTOGRAM(A1:A7,B1:B5,TRUE,TRUE,TRUE,FALSE)

Issue: Chart not getting displayed.'SomeChartFlag' functionality needs to be implemented.

• Test Comments ----Swapna(8/1/14)

--Chart display goes off after few seconds.

HISTOGRAM Function Test Comments

• Chart displayed correctly ...Issue Resolved...Working...----Swapna(02/18/15)

CIRCLE(Radius)

Issue: CIRCLE.AREA(), CIRCLE.CIRCUMFERENCE() not working. To be checked after next release.

• Test Comments (CIRCLE):

-- Issue still persists as mentioned. -- Swapna

-- Issue still persists as mentioned. --- Swapna (5/01/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

-- Issue still persists as mentioned. --- Swapna (5/5/14)

-- Issue still persists as mentioned. --- Swapna (5/18/14)

--Test Comments -- Swapna(8/1/14)

• CIRCLE(Radius) gives correct output. e.g. CIRCLE(200), (1..50@CIRCLE) , (1..200..20@CIRCLE)
• ZC(1..50@CIRCLE) does not give correct output.
• Not sure how to implement functions like CIRCLE.AREA(), CIRCLE.CIRCUMFERENCE()

CIRCLE Function Test Comments

• ...Issue Resolved...Working...----Swapna(02/20/15)

EXPONENTIALSMOOTHING(SomeArray,DampingFactor,ShowChart,ShowStandardErrorOptions,NewTableFlag)

• Test Comments ----- Swapna (5/18/14)

e.g. Consider the following example -

Period	Array Input
0	0
1	45.5
2	60
3	200
4	160
5	300
6	340
7	310
8	500
9	566
10	610

=EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE,TRUE,TRUE)
=EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE,TRUE,FALSE)

Issue: Chart not getting displayed. 'ShowChart' functionality needs to be implemented.

• Test Comments- Swapna (8/1/2014)

--Chart displayed correctly when 'NewTableFlag' is FALSE. (e.g EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE,TRUE,FALSE)

--Chart does not display curves when 'NewTableFlag' is TRUE. (e.g EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE,TRUE,TRUE)

EXPONENTIALSMOOTHING Function Test Comments

• ...Issue Resolved...Working...----Swapna(02/20/15)

MOVINGAVERAGE(SomeArray,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)

• Test Comments --- Swapna (5/18/14)

Consider the below example-

Period	Array Input
0	0
1	45.5
2	60
3	200
4	160
5	300
6	340
7	310
8	500
9	566
10	610

e.g MOVINGAVERAGE(B1:B11,6,TRUE,TRUE,TRUE)

MOVINGAVERAGE(B1:B11,6,TRUE,TRUE,FALSE)

Issue: Chart not getting displayed.'SomeChart' functionality needs to be implemented.

• Test Comments- Swapna (8/1/2014)

--Chart displayed when 'NewTableFlag' is FALSE. (e.g MOVINGAVERAGE(B1:B11,6,TRUE,TRUE,FALSE))

--Chart does not display curves when 'NewTableFlag' is TRUE. (e.g MOVINGAVERAGE(B1:B11,6,TRUE,TRUE,TRUE))

MOVINGAVERAGE Function Test Comments

• ...Issue Resolved...Working...----Swapna(02/20/15)

DESCRIPTIVESTATISTICS function

Syntax: DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, NewTableFlag)

• Issue1: Even if NewTableFlag = FALSE, o/p displayed in different Zspace. Not on same sheet where command is written.

• Test Comments (DESCRIPTIVESTATISTICS):

e.g. Consider the following example-

	Column1	Column2	Column3	Column4
Row1	8	8
Row2	7	8
Row3	11	11
Row4	7	18
Row5	33	37
Row6

=DESCRIPTIVESTATISTICS(A2:B5,"Columns",95,1,1,TRUE)
=DESCRIPTIVESTATISTICS(A2:B6,"Rows",95,2,1,FALSE)

--Issue1: O/p displayed on new Zspace irrespective of NewTableFlag 'TRUE' or 'FALSE'. ....Swapna (8/1/14)

DESCRIPTIVESTATISTICS Function Test Comments

• ...Issue Resolved...Working...----Swapna(02/20/15)

NOTE: Syntax corrected to DESCRIPTIVESTATISTICS(Array, GroupBy, ConfidenceLevel, KthLargest, KthSmallest, IsFirstRowLabels, NewTableFlag) IsFirstRowLabels was not included in the wiki help page.

GOLDENRATIO

a)Suggestion: Argument name can be changed to 'logic_value' instead of 'smallphi'

Reason: Argument can be TRUE or FALSE or 1 or 0 for this function. 'smallphi' and 'capitalphi' are the output values obtained.

b)Calci does not give error for -

*Invalid arguments like GOLDENRATIO(7), GOLDENRATIO("ABCDEF"), GOLDENRATIO(-8)
*Multiple arguments like GOLDENRATIO(100,77)

c)Calci help displays incorrect values for smallphi and capitalphi.

• Observed result:

GOLDENRATIO(TRUE) returns 1.618033988749895

GOLDENRATIO(FALSE) returns 0.6180339887498948

• Expected result:

--see exp -- GOLDENRATIO(TRUE) returns 0.6180339887498948, value of capitalphi Φ --see exp -- GOLDENRATIO(FALSE) returns 1.618033988749895, value of smallphi φ

d)If argument is ignored, i.e. GOLDENRATIO()

• Observed result: 0.6180339887498948, value of capitalphi Φ
• Expected result: 1.618033988749895, value of smallphi φ

Reason: smallphi is default value for Goldenratio. Capitalphi is the conjugate value.

GOLDENRATIO EXPLANATION

GOLDENRATIO(TRUE) returns 1.618033988749895 GOLDENRATIO(FALSE) returns 0.6180339887498948 This is correct. parameter is smallPhi is true, If so answer should be 1.61 etc. if false should be 0.6181 etc. If argument is not defined or is not false, it is considered to be true. So junk value giving smallPhi equivalent is safe. - jp

• Test Comments (GOLDENRATIO):

-- GOLDENRATIO(TRUE), GOLDENRATIO(FALSE) seem to be ok. -- GOLDENRATIO() returns 0.618033..... (value of capital phi). Should it be 1.6180....(value of Small phi)? ----Swapna

-- Issue still persists as mentioned. -- Swapna(5/2/14)

-- Issue still persists as mentioned. -- Swapna(5/5/14)

-- Issue still persists as mentioned. -- Swapna(5/18/14)

-- Issue still persists as mentioned. -- Swapna(8/1/14)

GOLDENRATIO Function Test Comments

Observed Results: GOLDENRATIO(TRUE)=0.6180339887498948 GOLDENRATIO(FALSE)=1.618033988749895 GOLDENRATIO()=0.6180339887498948

• ...Issue Resolved...Working...----Swapna(02/22/15)

SUM

Function	O/p in EXCEL	O/p in ZOS	O/p in Calci	Comments
SUM(2,,4)	6	Error	A1=2, A2= ,A3=4 then =SUM(A1,A2,A3) returns '6'	A2 is empty cell
SUM(2,TEXT,4)	6	6	A1=2, A2=TEXT ,A3=4 then =SUM(A1,A2,A3) returns '6'
SUM(3,TRUE,4)	7	8	A1=3, A2=TRUE ,A3=4 then =SUM(A1,A2,A3) returns 8; but =SUM(A1:A3) returns 7	1)TRUE, FALSE values ignored in Excel 2)SUM(A1:A3) returns 8 (Swapna 02/22/15)
SUM(3,FALSE,4)	7	7	A1=3, A2=FALSE ,A3=4 then =SUM(A1,A2,A3) returns '7'	TRUE, FALSE values ignored in Excel

SUM Test Comments

Results matching in ZOS and Calci. Issue resolved --- Swapan(09/02/2015)

HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)

e.g.

Spreadsheet

	ColumnA	ColumnB	ColumnC
1	22
2	29		20
3	40		25
4	30		30
5	48		35
6	24		40
7	21
8	19
9	24
10	22
11	25
12	52

=HISTOGRAM(A1:A12,C2:C6,TRUE,TRUE,TRUE,TRUE)

• Test Comments --- Swapna (02/23/15)

Cumulative Frequency values differ with respect to Excel.

Output in ZCalci:

Output in Excel:

HISTOGRAM Test Comments

Outputs matching in Calci and Excel for above example. Issue resolved--- (09/02/15).

HOUR, MINUTE Functions

• Value not carry forwarded if HOUR>24 , MINUTE>60
• HOUR("25:10") should display 1. Instead displays 0.
• MINUTE("12:72:20") should display 12. Instead displays #ERROR.

HOUR, MINUTE Test Comments

Outputs displayed as expected. Issue resolved--- (09/22/15).

FIXED ISSUES FROM TRIVANDRUM'

BETADIST

• In this function normally limit a and b are optional. But in calci a and b are required.
• So the limit of x is not in 0 to 1.
• BETADIST(0.4,8,10)= 0.359492343(Excel
• = NAN(CALCI)

Test Comments (BETADIST)

• Issue resolved. Working---(5/2/2014) Devi

ERF

• In this function when ll>ul the result showing in CALCI is 0. But the Excel value is displaying the value of ll < ul with the negative sign.
• ERF(3,2)= -0.004655645(Excel) = 0(CALCI)

Test Comments (ERF)

• Issue resolved.Working---(5/2/2014) Devi

ERFC

• In this function in Calci is assigned two variables like ERFC(x,accuracy), but when we are giving the 2nd variable, then the only result is 1 for any number.
• ERFC(2) = 0.004677762(calci)
• ERFC(2,5)=1(calci)

Test Comments (ERFC)

• Issue resolved.Working---(5/2/2014) Devi

SUMX2MY2

• This function is giving the result as null for any value.

Spreadsheet

	A	B	C	D
1	29	71	10	16
2	16	50	8	14

=SUMX2MY2(A1:D1,A2:D2) = null

Test Comments (SUMX2MY2)

• Issue resolved.Working---(5/2/2014) Devi

MIRR

• For this function result is coming as error.

Spreadsheet

	A
1	-250000
2	20000
3	30500
4	25000
5	37000
6	28000
7	11%
8	12%

1. MIRR(A1:A6,A7,A8)= -30%(Excel)

Test Comments (MIRR)

• Issue resolved.Working---(5/2/2014) Devi

CLEAN

• In this function result value is different compared with Excel.
• CLEAN("�double�") = �double�(EXCEL) = double(CALCI)

Test Comments (CLEAN)

• Issue resolved.Working---(5/2/2014) Devi

TRIMMEAN

• The result of this function is different compared with Excel.

Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L
1	14	18	21	19	20	23	8	10	7	18	12	11

1. =TRIMMEAN(A1:L1,0.2) = 15.6(CALCI) = 15.1(EXCEL)
2. =TRIMMEAN(A1:L1,0.4) = 15.625(CALCI) = =15.25(EXCEL)

Test Comments (TRIMMEAN)

• Issue resolved.Working---(5/3/2014) Devi

TDIST

• In this function for the arguments values of df and t are taking only integers. It is not accepting the values of decimals.
• i.e., when we are assigning decimal values ,it should change in to integers.
• TDIST(2.4579,20.4,1)=0.0122238(CALCI) = 0.011612361(EXCEL)
• TDIST(2.4579,20.4,1.2)=0.011612361(Excel) = Null(CALCI)

Test Comments (TDIST)

• Issue resolved.Working---(5/3/2014) Devi

COMBINATION,PERMUTATION

• In combination and permutation functions when we are using the like 6c2, then the result is wrong.

1. 11c5 = 11(CALCI) = 462 (By checking)
2. 10p4 = 10(CALCI) = 5040(By checking)

Test Comments (COMBINATION,PERMUTATION)

• Issue resolved.Working---(5/3/2014) Devi

MULTINOMIAL

• This function is giving the different answer for the decimals.
• For e.g.,MULTINOMIAL(0,1.2,1.3,1.4,1.5)= 24(Excel) = 120 (CALCI)

Test Comments(MULTONOMIAL)

• Issue resolved.Working---(7/25/2014) Devi

STDEV FUNCTIONS

• For standard deviation functions like STDEV,STDEVA,and STDEVPA functions is considering only the logical value TRUE, but it is not taking the value of FALSE.
• i.e., in a logical value FALSE is not taking for the calculation.
• STDEV(10,15,17,FALSE)= 7.593857167(Excel) = 3.60555127(CALCI)which is equal to STDEV(10,15,17)
• STDEVA(12,18,27,32,FALSE)=12.61744824(EXCEL)=8.958236433584458(CALCI)
• Array={2,12,22,32,false}
• STDEVPA(A1:A5)=12.09297317(Excel)=11.180339887498949(CALCI)

Test Comments(STDEV,STDEVA)

• Issue resolved.Working---(7/25/2014) Devi

VAR FUNCTIONS

• For variance functions like VAR,VARA,VARP,and VARPA funtions for logical value TRUE , the result is correct.
• But the logical value FALSE ,the result is different compared with Excel.
• i.e., in a logical value FALSE is not taking for the calculation.
• VAR(10,25,18,FALSE) = 115.5833333(Excel) = 141.592592(CALCI)which is equal to VAR(10,25,18)
• VARA(10,15,20,25,FALSE)=41.666666666(CALCI) = 92.5(Excel)
• VARP(40,61,53,46,FALSE)=449.2(Excel) = 549.2(CALCI)
• VARPA(12,23,34,45,FALSE)=250.96(Excel) = 151.25(CALCI)

Test Comments(VAR FUNCTIONS)

• Issue resolved.Working---(7/25/2014) Devi

GROWTH

• For this function result is different compared with Excel.

Spreadsheet

	A	B	C	D	E
1	2001	2002	2003	2004	2005
2	1000000	1100000	1252000	1375000	1500000

1. GROWTH(A1:E1,A2:E2) = 1.0000000039046144(CALCI) = 2001.081161(Excel)

GROWTH([2001,2002,2003,2004,2005],[1000000,1100000,1252000,1375000,1500000]) 2001.0811609385346

• When we are selecting the entries in a horizontal only one result is displaying.
• But when we are selecting the entries in a vertical few result is displaying.

Test Comments(GROWTH)

• Issue resolved.Working
• The results are coming in array result, but how to make the result in a single value.---(7/25/2014) Devi

ISPRIME

• In this function ,when we assigning decimals it is giving different result.
• For e.g., ISPRIME(5.1)= true.But it is not prime.
• So it should give result as false.

Test Comments(ISPRIME)

• Issue resolved.Working---(7/25/2014) Devi

FDIST

• For some values results are different compared with Excel.
• FDIST(70.120045,12.2,6.35) = 1.93536 E-05(Excel) = 0.000011229898(CALCI)
• FDIST(10,1.3,1.5) = 0.134947329626(EXCEL) = 0.194982229(CALCI)

Test Comments(FDIST)

• Issue resolved.Working---(7/25/2014) Devi

ROMAN

In this function the result is different compared to Excel. When the 2nd argument value is taking only 0.i.e., The t value is not calculating for 1,2,and 3.

• ROMAN(999,1)= LMVLIV(EXCEL) = CMXCIX(CALCI)
• ROMAN(999,2) = XMIX(EXCEL) = CMXCIX(CALCI)
• ROMAN(999,3) = VMIV(EXCEL)= CMXCIX(CALCI)

Test Comments(ROMAN)

• Issue resolved.Working---(2/11/2015)

RANKANDPERCENTILE

• This function for the rows arrangement the result is wrong.
• RANKANDPERCENTILE(ar,rows,FALSE), the result is wrong compared with excel.

Please give an exact example with input etc.

• Screenshot attached on 2nd May 2014

RANKANDPERCENTILE([15,10,5,12,25],"rows",false)

Rank And Percentile Point Row1 Rank Percent 5 25 1 100 1 15 2 75 4 12 3 50 2 10 4 25 3 5 5 0

Test Comments(RANKANDPERCENTILE)

• Issue resolved.Working---(2/11/2015)

SAMPLING

• In this function type of the sampling is RANDOM, then the result is correct.
• But the type is PERIODIC, it is not showing the result.

Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	10	20	11	24	19	17	23	65	10	5	14	45	28

1. SAMPLING(A1:M1,PERIODIC,5)=NULL

Test Comments(SAMPLING)

• Issue resolved.Working---(2/11/2015)

IMLN

• This function is not considering the zero value of imaginary value of z.
• The result is different is compared with excel.
• IMLN("4")=1.38629436111989(Excel)= 1.38629436111989+6.283185307179586i

Test Comments(IMLN)

• Issue resolved.Working---(2/11/2015)

SUM

Correcting these for ss like behavior according to ss rules. SUM(10,15,17,false) 42 $>SUM(10,15,17,true) 43

Test Comments(SUM)

• Issue resolved.Working---(2/11/2015)

STDEV

STDEV(10,15,17,true) 7.135591542869215

Test Comments(STDEV)

• Issue resolved.Working---(2/11/2015)

UNIFORM

• In this function it is showing only random numbers between the limits, but it is not showing the value of uniform distribution.
• UNIFORMDISTRIBUTED(5,3,6)=1/3(by checking)
• =5.522187389200553,3.566177821950987,5.04674904467538,5.301322509767488,4.9094569575972855(CALCI)

This is expected to give a distribution. UNIFORMDISTRIBUTED(SomeNumbers, SomeMin, SomeMax) The answer will be an array.

Test Comments(UNIFORM)

• This function giving the array result according to the ZOS definition.
• Issue resolved.Working---(6/10/2015)

DAY

• DAY function is not showing correct result.
• DAY("4/9/2019") = 10(CALCI) = 9(Excel)

Test Comments(DAY)

• Issue resolved.Working---(6/10/2015)

BESSEL FUNCTIONS

• BESSELI,BESSELY and BESSELK functions only showing the result for 1st derivative.
• It should show the result for nth derivative.
• For e.g.,
• 1.BESSELI(3,2)= 2.245212431(Excel) this is the n th derivative(In(x))
• = 3.9533702171(Calci)this is the 1st derivative(I1(x))
• 2.BESSELY(0.7,4) = -132.6340573(EXCEL)Yn(x) = -1.1032498713(CALCI)Y1(x)
• 3.BESSELK(5,2)= 0.005308944 (EXCEL)Kn(x) = 0.0040446134(CALCI)K1(x)
• BESSELJ functions is not working for some values.
• BESSELJ(2,3)= 0.12894325(EXCEL)Jn(x)
• = 0.10728467204(calci)J1(x)
• BESSELJ(7,2) = -0.301417224(EXCEL)Jn(x)
• = NULL

Test Comments(BESSEL)

• Issue resolved.Working---(6/10/2015)

BETAINV

• In this function the CALCI result is different compared with EXCEL.
• For e.g.,BETAINV(0.359492343,8,10) = 0.399999976(EXCEL)
• BETAINV(0.359492343,8,10) = 1.75(CALCI)
• BETAINV(0.359492343,8,10,0,1) =0.375(with the upper and lower bound value)

-- Give proper params and test: BETAINV(Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy, DivisionsAndDepthArray)

Test Comments(BETAINV)

• For this function we need to know the default value for the lowerbound and upperbound values.
• Issue resolved.Working---(6/10/2015)

PPMT

• In this function ,the result is different compared with excel for the ty value is 1.

1. PPMT(8%/12,1,4*12,10000,1000,1) = -260.14(Excel)

• =-193.474537727(CALCI)=No result(ZOS)

==PPMT(0.08/12,1,4*12,10000,1000,1) works. In ZOS, we should give the parameter as 0.08 not 8%. It is best not to autoconvert in ZOS since it may conflict with mod sign %

Test Comments(PPMT)

• Issue resolved.Working---Devi(6/10/2015)

IMSUM

• This function is taking only first two arguments.
• It is not considering from the third argument.
• For e.g.,IMSUM("12+10i","8+16i","5+2i")= 20+26i(Calci)= 25+28i(Excel)

Test Comments(IMSUM)

• Issue resolved.Working---Devi(6/10/2015)

MAGIC SQUARE

• When we are checking with other sites, it is saying that MAGICSQUARE of order 2 is not possible to construct.
• CALCI is giving the result for the magicsquare of size 2x2, but sum of rows and columns are not same.
• MAGICSQUARE(2) gives wrong result

== Let us leave this one as it is. I think this is better, than returning null. If it becomes a problem, we will take a look at it.

• The minimum Magic Square matrix size is 3x3. 2x2 matrix is not possible.

Test Comments(MAGICSQUARE)

• Issue resolved.Working---Devi(6/10/2015)

WILCOXONRANK,SIGNEDRANK

• The functions WILCOXONRANK and SIGNEDRANK is not existing in ZOS and Calci.

Spreadsheet

	A	B	C	D	E
1	19	25	28	30	18
2	5	9	8	11	10

• =WILCOXONRANK(A1:E1,A2:E2)=Null
• =SIGNEDRANK(A1:E1)=Null.

--5/15/2014 Please try WILCOXONSIGNEDRANKTEST.

• WILCOXONSIGNEDRANKTEST((A1:E1,A2:E2,0.05,true)=Null

Test Comments(WILCOXONSIGNEDRANKTEST)

• Issue resolved.Working---Devi(6/10/2015)

IPMT

• In this function the CALCI result is different compared with EXCEL.
• IPMT(0.045/2,3,2*2,50000,10000,1) = -454.78 (EXCEL) = -480.666(CALCI)

Test Comments(IPMT)

• Issue resolved.Working---Devi(6/10/2015)

UPPERBIDIAGONAL

• For UPPERBIDIAGONAL function, MATRIX("upperbidiagonal") is not showing the correct result.
• But that is giving the corrcet result when the syntax is MATRIX("upper-bidiagonal").

Test Comments(UPPERBIDIAGONAL)

• Issue resolved.Working---Devi(6/10/2015)

REGRESSION

• For the more x values(two columns of x values) the result is error.

Spreadsheet

	A	B	C
1	Unit sales	Ads	population
2	4000	12000	300000
3	5200	13150	411000
4	6800	14090	500000
5	8000	11900	650000
6	10000	15000	800000

1. REGRESSIONANALYSIS(A2:A6,B2:C6)= NAN

Test Comments(REGRESSION)

• Issue resolved.Working---Devi(9/1/2015)

Sign test

• This function is indicating whther single or more than one array.
• Because it is giving the result as null for both single or double array.

Spreadsheet

	A	B
1	15	20
2	19	17
3	32	35
4	42	38
5	24	16

• =SIGNTEST(A1:A5,5,10,true)=Null
• =SIGNTEST(A1:B5,5,10,true)=Null

Test Comments(REGRESSION)

• Issue resolved.Working---Devi(9/1/2015)

ISNONTEXT

• When we are giving the text as the argument, the result shows as "Null".
• But the answer should come as FALSE

Spreadsheet

	A	B	C
1	74509	"65142"	MONTHS
2		"months"

1. =ISNONTEXT(B1) = Null
2. =ISNONTEXT(C1) = Null
3. =ISNONTEXT(B2) = Null

• The function is working in ZOS but not working CALCI.

Test Comments(ISNONTEXT)

• Issue resolved.Working---Devi(10/3/2015)

NORMAL

• In this function is generating only random numbers.
• But it should give the result according to the formula of the normal distribution.

1. NORMALDISTRIBUTED(250,255,2.5) = 0.022(By checking)

• =748.545737759758,417.93831835416444,-92.67846228553037,etc(CALCI)

1. NORMALDISTRIBUTED(30,36,20.9) = 0.018(By checking)

• = 7.937852412035841,10.385286729354199,83.54572095198611 etc (CALCI).

Check again. NORMALDISTRIBUTED is intended to give random numbers back. NORMDIST is a different function.

NORMDIST(250,255,2.5) 0.021596386605275224 NORMDIST(30,36,20.9) 0.018317552240650948 NORMDIST is showing the correct result instead of NORMALDISTRIBUTED.

Test Comments(NORMDIST)

• Issue resolved.Working---Devi(10/3/2015)

Quadratic

QUADRATIC(1,-10,34) The result shows correct but the format is wrong. "+" and "-" comes together

This is ok. 4/28/2014 jp

Close in Release 5.0.101 since this is ok.

ZTEST

• In this function, the decimal values in the result is different compared with excel.

Spreadsheet

	A	B	C	D	E	F	G
1	10	15	7	2	19	20	12
2	3	4	8	1	10	15	5

1. =ZTEST(A1:G1,4) = 0.00042944272036(CALCI) = 0.000431321(Excel)
2. =2*MIN(ZTEST(A1:G1,4),1-ZTEST(A1:G1,4)) = 0.000858885440(CALCI) = 0.000862641(Excel)

• The above issue is occurring again.

This issue is ok since NORMSDIST is accuracy based, and involves iterations which will increase in accuracy with iterations allowed.

ZTEST(SomeArray,SomeMean,SomeStandardDeviationForPopulation, IsTwoTailed, SomeAccuracy)

1. =ZTEST(#TABLE1!B1:H1,4,6.466028,false,0.000000000001) =0.00043162493951653946

As the accuracy increases the the value is getting closer to excel results but the speed will be slow.

Close in 5.0.101.

No need of fix for the above reasons. Please check and close. Mary(06/10/2015)

IMCONJUGATE

• Calci displays Conjugate of 3+4i as 3+-4i.
• It should display 3-4i

-- this is ok.

MANNWHITNEYUTEST

• This function is not displaying any result.
• What is the values we can refer for the "type"(5th) argument?.

Spreadsheet

	A	B
1	20	22
2	15	17
3	25	19
4	35	38
5	17	16

• =MANNWHITNEYUTEST(A1:A5,B1:B5,0.05,TRUE)= Null

Test Comments(MANNWHITNEYUTEST)

• Issue resolved.Working---Devi(10/21/2015)