1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralSupportedStatisticalFormulasTest extends TestExecution {
 7  @Test
 8  public void test_AVEDEV() {
 9    runner().addCell("Alpha", "A1", "= AVEDEV(1, 3, 5, 7, 11)").addExpectedValue("Alpha", "A1", 2.88).run();
10  }
11
12  @Test
13  public void test_AVERAGE() {
14    runner().addCell("Alpha", "A1", "= AVERAGE(1.0, 2.0, 3.0, 4.4)").addExpectedValue("Alpha", "A1", 2.6).run();
15  }
16
17  @Test
18  public void test_AVERAGEA() {
19    runner()
20        .addCell("Alpha", "A1", "= AVERAGEA(1.0, 2.0, 3.0, 4.4, {\"ToZero\"})")
21        .addExpectedValue("Alpha", "A1", 2.08)
22        .run();
23  }
24
25  @Test
26  public void test_COUNTA() {
27    runner().addCell("Alpha", "A1", "= COUNTA(1.0, 2.0)").addExpectedValue("Alpha", "A1", 2.0).run();
28  }
29
30  @Test
31  public void test_COUNTBLANK() {
32    runner().addCell("Alpha", "C22", "= COUNTBLANK(B1:B10)").addExpectedValue("Alpha", "C22", 10.0).run();
33    runner().addCell("Alpha", "A1", "= COUNTBLANK(M1:M10)").addExpectedValue("Alpha", "A1", 0.0).run();
34  }
35
36  @Test
37  public void test_COUNT() {
38    runner().addCell("Alpha", "A1", "= COUNT(1.0, 2.0)").addExpectedValue("Alpha", "A1", 2.0).run();
39  }
40
41  @Test
42  public void test_MAXA() {
43    runner().addCell("Alpha", "A1", "= MAXA(1.0, 2.0, 6.0)").addExpectedValue("Alpha", "A1", 6.0).run();
44  }
45
46  @Test
47  public void test_MAX() {
48    runner().addCell("Alpha", "A1", "= MAX(1.0, 2.0, 6.0)").addExpectedValue("Alpha", "A1", 6.0).run();
49  }
50
51  @Test
52  public void test_MINA() {
53    runner().addCell("Alpha", "A1", "= MINA(1.0, 2.0, 6.0)").addExpectedValue("Alpha", "A1", 1.0).run();
54  }
55
56  @Test
57  public void test_MIN() {
58    runner().addCell("Alpha", "A1", "= MIN(1.0, 2.0, 6.0)").addExpectedValue("Alpha", "A1", 1.0).run();
59  }
60
61  @Test
62  public void test_STDEV() {
63    runner().addCell("Alpha", "A1", "= STDEV(1.0, 2.0, 6.0)").addExpectedValue("Alpha", "A1", 2.6457513110645907).run();
64  }
65}