Hello,
                   This file is an amalgamation of various examples and instructions on functions that you may use in your role as a Cost Estimator.  
                   The topics are:
                   Tab1      1. Excel Basics
                   Tab2      2.  Regression Review
                   Tab3      3.  Outlier calcs
                   Tab4      4. Boeing Unit Curve Cumulative Progress Curves
                   Tab5      5.  Student T distribution
                   Tab6      6.  Normal Distribution
                   Tab7      7.  F Distribution
                   Tab8      8.  Sumproduct Examples
                   Tab9      9.  Weighted Index Calculations
                   Tab10     10.  EAC Calculations
                   Tab11     11.  Learning Curve Calculations
                   Tab12     12.  CPIF Price Calculation
                   Tab13     13.  Flat Regression Tool
                   This spreadsheet's tabs 1 through 13 are protected from changes, however, you can select cells and copy them to a new tab in this spreadsheet, or you can select a range of cells and copy those into an enirely new spreadsheet.
                   I encourage you to send any suggestions for improvement or suggestions for new functions and/or techniques to Keith.bare@dau.edu
This file is an amalgamation of various examples and instructions on functions that you may use in your role as a Cost Estimator.  
This spreadsheet's tabs 1 through 13 are protected from changes, however, you can select cells and copy them to a new tab in this spreadsheet, or you can select a range of cells and copy those into an enirely new spreadsheet.
I encourage you to send any suggestions for improvement or suggestions for new functions and/or techniques to Keith.bare@dau.edu
This spreadsheet's tabs 1 through 13 are protected from changes, however, you can select cells and copy them to a new tab in this spreadsheet, or you can select a range of cells and copy those into an enirely new spreadsheet.
           Formulas
           A formula in Excel always begins with an equal sign (=). Following the equal sign are the elements to be calculated (the operands), which are separated by calculation operators. 
           Arithmetic Operator               Meaning (Example)
           + (plus sign)                     Addition (3+3)
                                             Subtraction (3–1)
           – (minus sign)
                                             Negation (–1)
           * (asterisk)                      Multiplication (3*3)
           / (forward slash)                 Division (3/3)
           % (percent sign)                  Percent (20%)
           ^ (caret)                         Exponentiation (3^2)
           Reference (Description)           Changes to
           $A$1 (absolute column and                     $A$1
           absolute row)
           A$1 (relative column and absolute              C$1
           row)
           $A1 (absolute column and relative              $A3
           row)
           A1 (relative column and relative               C3
           row)
           Use of parentheses
           To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Excel calculates multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.
           =5+2*3
           In contrast, if you use parentheses to change the syntax, Excel adds 5 and 2 together and then multiplies the result by 3 to produce 21.
           =(5+2)*3
           In the example below, the parentheses around the first part of the formula force Excel to calculate B4+25 first and then divide the result by the sum of the values in cells D5, E5, and F5.
           =(B4+25)/SUM(D5:F5)
                                             To insert a function using the function menu, first select a cell.
                                             then click on the fx button to the left of the equation bar.
                                             The "insert function" GUI will pop up, if you know the function syntax you can start typing in the search box, or select a category and search for the function you desire.