コード例 #1
0
        public void MultiplicationTest1()              //false test
        {
            ExcelFormulas ef = new ExcelFormulas();

            try
            {
                List <double> values = new List <double> {
                    5, 4
                };
                Assert.AreEqual(18, ef.GetMultiply(values));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        public void MeanTest1() //false test
        {
            ExcelFormulas ef = new ExcelFormulas();

            try
            {
                List <double> values = new List <double> {
                    45, 10, 78, 1
                };
                double Result = ef.GetMean(values);
                Assert.AreEqual(33, Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
        public void ModeTest() //true test
        {
            ExcelFormulas ef = new ExcelFormulas();

            try
            {
                List <double> values = new List <double> {
                    45, 10, 78, 1, 1, 10, 78, 1
                };
                double Result = ef.GetMode(values);
                Assert.AreEqual(1, Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #4
0
        public void MedianFalseTest2()
        {//This test for finding median is done for list containing odd count of values.
            ListManipulation LM = new ListManipulation();
            ExcelFormulas    ef = new ExcelFormulas();

            try
            {
                List <double> values = new List <double> {
                    45, 10, 78, 1, 56
                };
                List <double> sortedList = LM.GetAscendedList(values);
                double        Result     = ef.GetMedian(sortedList);
                Assert.AreEqual(56, Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        public void MedianTrueTest1()
        {//This test for finding median is done for list containing even count of values.
            ListManipulation LM = new ListManipulation();
            ExcelFormulas    ef = new ExcelFormulas();

            try
            {
                List <double> values = new List <double> {
                    45, 10, 78, 1
                };
                List <double> sortedList = LM.GetAscendedList(values);
                //Sorted List is passed because number needs to be arranged in order.
                double Result = ef.GetMedian(sortedList);
                Assert.AreEqual(27.5, Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }