Cost Analyst Spreadsheet Toolbox

​This is an EXCEL spreadsheet that lists EXCEL functions that are commonly used by Cost Analysts.  There are videos on how to use the tools in the spreadsheet at the bottom of this page. It also shows some examples and provides discussion on how the Cost Analyst would employ these functions. 

1. Excel Basics
   
2. Regression Review
   
3. Outlier calcs
   
4. Boeing Unit Curve Cumulative Progress Curves
   
5. Student T distribution
   
6. Normal Distribution
   
7. F Distribution
   
8. Sumproduct Examples
   
9. Weighted Index Calculations
   
10. EAC Calculations
    
11. Learning Curve Examples
12. CPIF Price Calculations

Tutorials