Use Descriptive Statistics. Go to the “Data” tab on the Ribbon. Click on “Data Analysis” in the “Analysis” group. If you don’t see this option, you may need to add the Analysis ...

Descriptive Statistics provides a summary of data, including measures of central tendency and variability. Access Data Analysis: Go to the Data tab on the ribbon.

Investors can use Excel to run technical calculations or produce fundamental accounting ratios. Corporations may use Excel to run a capital budgeting analysis, risk analysis or discount cash flows.