ExcelFormulaParser.Engine.Excel.Functions.Math.Stdev.Execute C# (CSharp) Method

Execute() public method

public Execute ( IEnumerable arguments, ParsingContext context ) : CompileResult
arguments IEnumerable
context ParsingContext
return ExcelFormulaParser.Engine.ExpressionGraph.CompileResult
        public override CompileResult Execute(IEnumerable<FunctionArgument> arguments, ParsingContext context)
        {
            ValidateArguments(arguments, 1);
            var values = ArgsToDoubleEnumerable(arguments);
            return CreateResult(StandardDeviation(values), DataType.Decimal);
        }

Usage Example

 public void StdevShouldIgnoreHiddenValuesWhenIgnoreHiddenValuesIsSet()
 {
     var func = new Stdev();
     func.IgnoreHiddenValues = true;
     var args = FunctionsHelper.CreateArgs(1, 3, 5, 6);
     args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell);
     var result = func.Execute(args, _parsingContext);
     Assert.AreEqual(2d, result.Result);
 }
All Usage Examples Of ExcelFormulaParser.Engine.Excel.Functions.Math.Stdev::Execute