MS Excel comes with a tool to calculate simple moving averages. The Data Analysis Tool Pack is an add-in, which means you may not have it by default. We are listing here the steps to get this tool.

It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells. How to calculate Standard ...

The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used ...

How to Calculate Breakpoints in Excel. A price breakpoint is a discount you offer your customers based on the amount of units that they order. The breakpoint is the lower value of the range that ...

2. From the Formulas tab, click Define Name.. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).

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.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

I’m including demonstration files for both the .xlsx and .xls formats, but only RANK() will work in versions earlier than Excel 2010. Excel for the web supports all three ranking functions, for now.