You can create a calculator with Excel which ... B1:C5,2,TRUE). Then type the following into cell "F2": Enter a test order quantity into cell "D2." The value in "E2" should be the correct unit ...

The other key result is the correlation of the two. Regression statistics will typically include an R-squared value ... How to Calculate the Regression of 2 Stocks Using Excel originally appeared ...