You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

You can estimate the expected value of your current venture, compare it to other opportunities and make a sensible decision on what is more beneficial for you.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.