Search code examples
excelminitabminitab-16

Do operations with the upper adjacent cell of a cell in Minitab 17. Is it possible?

I've been trying to make a graph of the estimated RTT in the TCP protocol, and the formula to get the estimated RTT is:

EstimatedRTT1 = (1- α)*EstimatedRTT0 + α*RTT

where EstimatedRTT1 is the value of the current estimation of the RTT and EstimatedRTT0 is the value of the previous estimation, RTT is the round trip time for a determined packet in a precise moment and α is just an tipical value that equals 0.125 . We assume that the first value for EstimatedRTT0 is equals α*RTT, and afterwards EstimatedRTT0 is EstimatedRTT1 of the previous RTT.

Example:

RTT = 23ms
α = 0.125
EstimatedRTT0 = RTT*α = 23 * 0.125 = 2.875

EstimatedRTT1 = (1- α)*EstimatedRTT0 + α*RTT = (1-0.125)*2.875 + 0.125*23
EstimatedRTT1 = 5.390

then the next estimation goes like this:

RTT = 30ms
EstimatedRTT0 = 5.390 (last EstimatedRTT1)

EstimatedRTT1 = (1-0.125)* 5.390 + 0.125*30 = 8,466

and so on..

The graphic should look like this:

Example: estimated RTT graph

The problem I'm having is that I can't do the graph with Minitab, because I can't find the way to put in a column the result of this formula applied to a column with RTT values.

If I were to put the result of the first operation with EstimatedRTT0 = α*RTT, then every cell in the column would need the value of the previous cell, in order to calculate its own value.

I've been wondering if it is even possible to do such a thing with Minitab..

So, can it be done? Is there any software capable of doing this, or should I try to make a little program to output the result of the formula with a little function?

I'm adding the minitab file with the RTT samples. MPJ file

Thanks,

and sorry if I didn't explain myself very clearly.

Solution

  • Found the way to do it with Excel.

    You just have to input the formula in a cell, and then copy that cell in the lower cells, and it copies the formula but it replaces the objective cells with the ones relative to the new cell.

    In this cell I input the formula

    Then I copy the contents of the cell, and we can see how the parameters of the formula have changed

    It was pretty easy after all.. It was a matter of trying things out.