Creating a formula that modifies itself based on number of samples.

Hi tdurton,

If you add your Student T Chart to another worksheet, you'll be able to use the LOOKUP function in place of the student T in your formula.

Cheers,

Originally Posted by tdurton

If 6 samples are taken then the formula is =(A35+2*(A44/SQRT(6)))
If 3 samples are taken then the formula is =(A35+2.9*(A39/SQRT(3)))

If i make A1 a cell that gives me the number of samples (between 2 and 9) how can i get the formulas above to insert the correct Student T?

The Student T Chart for the number of samples is as Follows:
2=6.3
3=2.9
4=2.4
5=2.1
6=2.0
7thru 9=1.9

This formula converts your table above into a formula:
=LOOKUP(A1, {2,3,4,5,6,7}, {6.3,2.9,2.4,2.1,2,1.9})

This inserts it into the original formula:
=(A35 + LOOKUP(A1, {2,3,4,5,6,7}, {6.3,2.9,2.4,2.1,2,1.9}) * (A44 / SQRT(A1)))