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. DAU courses that may use this toolbox are BCE1000, BCE2000V, BCE3000 as well as pricing courses in the CON curriculum.

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