The Mode function in Excel returns the most frequently repetitive value in an array or range of data. The formula for Mode function is Mode( number1, [number2,..]). In Excel, Modes can be arrays ...

For example, to calculate the value after 10, 20 and 30 days, enter those values in your vertical column, respectively. Enter the compounding formula to the cell immediately to the right of your ...

This will be one value for your two-stock portfolio, and we can call it C12. Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks.