ganit-core 0.3.4

Spreadsheet formula engine ā€” parser and evaluator for Excel-compatible formulas
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

use crate::types::{ErrorKind, Value};
use super::stat_helpers::collect_nums;
use super::var_s::sample_variance;

/// `STDEV.S(value1, ...)` ā€” sample standard deviation: sqrt(sample variance).
/// Requires nā‰„2. Returns `#DIV/0!` if fewer than 2 numeric values.
pub fn stdev_s_fn(args: &[Value]) -> Value {
    if args.is_empty() {
        return Value::Error(ErrorKind::NA);
    }
    let nums = collect_nums(args);
    match sample_variance(&nums) {
        Value::Number(v) => {
            let s = v.sqrt();
            if !s.is_finite() {
                Value::Error(ErrorKind::Num)
            } else {
                Value::Number(s)
            }
        }
        other => other,
    }
}

#[cfg(test)]
mod tests;