truecalc-core 1.0.2

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

use crate::types::{ErrorKind, Value};
use super::stat_helpers::collect_nums_direct;

/// `VAR.P(value1, ...)` — population variance.
pub fn var_p_fn(args: &[Value]) -> Value {
    if args.is_empty() { return Value::Error(ErrorKind::NA); }
    let nums = match collect_nums_direct(args) { Ok(v) => v, Err(e) => return e };
    pop_variance(&nums)
}

pub(crate) fn pop_variance(nums: &[f64]) -> Value {
    let n = nums.len();
    if n == 0 { return Value::Error(ErrorKind::DivByZero); }
    let mean = nums.iter().sum::<f64>() / n as f64;
    let var = nums.iter().map(|x| (x - mean).powi(2)).sum::<f64>() / n as f64;
    if !var.is_finite() { Value::Error(ErrorKind::Num) } else { Value::Number(var) }
}

#[cfg(test)]
mod tests;