public void StdevpaIsGivenStringNumbersAsInputs() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs("5", "6", "7"), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs("5.5", "6.6", "7.7"), this.ParsingContext); Assert.AreEqual(0.816496581, result1.ResultNumeric, .00001); Assert.AreEqual(0.898146239, result2.ResultNumeric, .00001); }
public void StdevpaIsGivenAMixedStringInputWithAEmptyCellInTheMiddle() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs(10, 2, "6/17/2011 2:00", "02:00 am"), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(10, 2, "6/17/2011 2:00", null, "02:00 am"), this.ParsingContext); Assert.AreEqual(17626.6725, result1.ResultNumeric, .00001); Assert.AreEqual(16283.22541, result2.ResultNumeric, .00001); }
public void StdevpaIsGivenAStringInputWithAEmptyCellInTheMiddle() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs(66, 52, 77, 71, 30, 90, 26, 56, 7), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(66, 52, 77, 71, null, 30, 90, 26, 56, 7), this.ParsingContext); Assert.AreEqual(25.43303966, result1.ResultNumeric, .00001); Assert.AreEqual(28.85914067, result2.ResultNumeric, .00001); }
public void StdevpaIsGivenAMixOfInputTypes() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs(1, true, null, "6/17/2011 2:00", "02:00 am"), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(1, true, "6/17/2011 2:00", "02:00 am"), this.ParsingContext); Assert.AreEqual(16284.22501, result1.ResultNumeric, .00001); Assert.AreEqual(17628.11549, result2.ResultNumeric, .00001); }
public void StdevpaIsGivenBooleanInputs() { var function = new Stdevpa(); var boolInputTrue = true; var boolInputFalse = false; var result1 = function.Execute(FunctionsHelper.CreateArgs(boolInputTrue, boolInputTrue, boolInputFalse), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(boolInputTrue, boolInputTrue, boolInputTrue), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(boolInputTrue, boolInputFalse, boolInputFalse), this.ParsingContext); Assert.AreEqual(0.471404521, result1.ResultNumeric, .00001); Assert.AreEqual(0d, result2.ResultNumeric, .00001); Assert.AreEqual(0.471404521, result3.ResultNumeric, .00001); }
public void StdevpaIsGivenADateSeperatedByABackslash() { var function = new Stdevpa(); var input1 = "1/17/2011 2:00"; var input2 = "6/17/2011 2:00"; var input3 = "1/17/2012 2:00"; var input4 = "1/17/2013 2:00"; var result1 = function.Execute(FunctionsHelper.CreateArgs(input1, input1, input1), this.ParsingContext); var result2 = function.Execute(FunctionsHelper.CreateArgs(input1, input2, input1), this.ParsingContext); var result3 = function.Execute(FunctionsHelper.CreateArgs(input1, input3, input4), this.ParsingContext); Assert.AreEqual(0d, result1.ResultNumeric, .00001); Assert.AreEqual(71.18208264, result2.ResultNumeric, .00001); Assert.AreEqual(298.4295934, result3.ResultNumeric, .00001); }
public void StdevpaIsGivenASingleStringInput() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs("string"), this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result1.Result).Type); }
public void StdevpaIsGivenASingleFalseBooleanInput() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs(false), this.ParsingContext); Assert.AreEqual(0, result1.ResultNumeric, .00001);; }
public void StdevpaIsGivenDateTimeInputsSeperatedByADashAsInputs() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs("1-17-2017 2:00", "6-17-2017 2:00", "9-17-2017 2:00"), this.ParsingContext); Assert.AreEqual(100.1742926, result1.ResultNumeric, .00001); }
public void StdevpaIsGivenMonthDayYear12HourTimeAsInputs() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs("Jan 17, 2011 2:00 am", "June 5, 2017 11:00 pm", "June 15, 2017 11:00 pm"), this.ParsingContext); Assert.AreEqual(1101.621004, result1.ResultNumeric, .00001); }
public void StdevpaIsGiven12HourTimesAsInputs() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs("12:00 am", "02:00 am", "01:00 pm"), this.ParsingContext); Assert.AreEqual(0.238144836, result1.ResultNumeric, .00001); }
public void StdevpaIsGivenNumbersAsInputstakeTwo() { var function = new Stdevpa(); var result1 = function.Execute(FunctionsHelper.CreateArgs(-1, -1, -1), this.ParsingContext); Assert.AreEqual(0d, result1.ResultNumeric, .00001); }
public void StdevpaIsGivenMaxAmountOfInputs254() { var function = new Stdevpa(); var input1 = 1; var result1 = function.Execute(FunctionsHelper.CreateArgs( 100, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1, input1 ), this.ParsingContext); Assert.AreEqual(6.199572434, result1.ResultNumeric, .00001); }