Please help me wise ones
I am trying to do the following calculations but for some reason one formula which is =(Mean^2)/(SE^2) is only working for two of the calculations. There's no absolute references being used, the numbers are filling down okay, the values all come out the same wrong number. I have tried to copy the formatting of the formula that worked into those that aren't and that didn't work either
Unfortunately the L2BB won't install on my PC as it belongs to work so here's hoping this paste works
Thank you
I am trying to do the following calculations but for some reason one formula which is =(Mean^2)/(SE^2) is only working for two of the calculations. There's no absolute references being used, the numbers are filling down okay, the values all come out the same wrong number. I have tried to copy the formatting of the formula that worked into those that aren't and that didn't work either
Unfortunately the L2BB won't install on my PC as it belongs to work so here's hoping this paste works
Thank you
Alpha | =(Mean^2)/(SE^2) | ||||||||||
Beta | =(SE^2)/Mean | ||||||||||
Probabilistic value | =GAMMAINV(Rand(),alpha,beta) | ||||||||||
Standard error | =(upper value-lower value)/(2*NORMINV(0.975,0,1)) | ||||||||||
Confidence Interval | |||||||||||
Mean | Upper | Lower | S.E. | Alpha | Beta | Prob | |||||
£336.55 | 403.86 | 269.24 | 34.3 | 96.04 | 3.50 | £342.71 | |||||
£228.99 | 274.79 | 183.19 | 23.4 | 96.04 | 2.38 | £260.99 | |||||
£242.63 | 136.79 | 91.19 | 11.6 | 435.10 | 0.56 | £248.19 | |||||
£128.64 | 154.37 | 102.91 | 13.1 | 96.04 | 1.34 | £116.56 | |||||
£210.75 | 252.90 | 189.68 | 16.1 | 170.76 | 1.23 | £208.45 | |||||
£246.10 | 295.32 | 196.88 | 25.1 | 96.04 | 2.56 | £264.45 | |||||
£300.00 | 360.00 | 240.00 | 30.6 | 96.04 | 3.12 | £355.17 | |||||
£5,617.85 | 6741.42 | 4494.28 | 573.3 | 96.04 | 58.50 | £6,907.92 | |||||
£245.64 | 294.77 | 196.51 | 25.1 | 96.04 | 2.56 | £242.50 | |||||
£59.28 | 71.14 | 47.42 | 6.0 | 96.04 | 0.62 | £64.98 | |||||
£245.64 | 294.77 | 196.51 | 25.1 | 96.04 | 2.56 | £212.84 | |||||
£61.69 | 74.03 | 49.35 | 6.3 | 96.04 | 0.64 | £61.37 | |||||
£121.08 | 145.30 | 96.86 | 12.4 | 96.04 | 1.26 | £127.61 | |||||
15.00 | 18.00 | 12.00 | 1.5 | 96.04 | 0.16 | £18.34 |
336.55 | 403.86 | 269.24 | =(D10-E10)/(2*NORM.INV(0.975,0,1)) | =(C10^2)/(F10^2) | =(F10^2)/C10 | =GAMMAINV(RAND(),H10,I10) | |
228.99 | 274.788 | 183.192 | =(D11-E11)/(2*NORM.INV(0.975,0,1)) | =(C11^2)/(F11^2) | =(F11^2)/C11 | =GAMMAINV(RAND(),H11,I11) | |
242.63 | 136.788 | 91.192 | =(D12-E12)/(2*NORM.INV(0.975,0,1)) | =(C12^2)/(F12^2) | =(F12^2)/C12 | =GAMMAINV(RAND(),H12,I12) | |
128.64 | 154.368 | 102.912 | =(D13-E13)/(2*NORM.INV(0.975,0,1)) | =(C13^2)/(F13^2) | =(F13^2)/C13 | =GAMMAINV(RAND(),H13,I13) | |
210.75 | 252.9 | 189.68 | =(D14-E14)/(2*NORM.INV(0.975,0,1)) | =(C14^2)/(F14^2) | =(F14^2)/C14 | =GAMMAINV(RAND(),H14,I14) | |
246.1 | 295.32 | 196.88 | =(D15-E15)/(2*NORM.INV(0.975,0,1)) | =(C15^2)/(F15^2) | =(F15^2)/C15 | =GAMMAINV(RAND(),H15,I15) | |
300 | 360 | 240 | =(D16-E16)/(2*NORM.INV(0.975,0,1)) | =(C16^2)/(F16^2) | =(F16^2)/C16 | =GAMMAINV(RAND(),H16,I16) | |
5617.85 | 6741.42 | 4494.28 | =(D17-E17)/(2*NORM.INV(0.975,0,1)) | =(C17^2)/(F17^2) | =(F17^2)/C17 | =GAMMAINV(RAND(),H17,I17) | |
245.64 | 294.768 | 196.512 | =(D18-E18)/(2*NORM.INV(0.975,0,1)) | =(C18^2)/(F18^2) | =(F18^2)/C18 | =GAMMAINV(RAND(),H18,I18) | |
59.28 | 71.136 | 47.424 | =(D19-E19)/(2*NORM.INV(0.975,0,1)) | =(C19^2)/(F19^2) | =(F19^2)/C19 | =GAMMAINV(RAND(),H19,I19) | |
245.64 | 294.768 | 196.512 | =(D20-E20)/(2*NORM.INV(0.975,0,1)) | =(C20^2)/(F20^2) | =(F20^2)/C20 | =GAMMAINV(RAND(),H20,I20) | |
61.69 | 74.028 | 49.352 | =(D21-E21)/(2*NORM.INV(0.975,0,1)) | =(C21^2)/(F21^2) | =(F21^2)/C21 | =GAMMAINV(RAND(),H21,I21) | |
121.08 | 145.296 | 96.864 | =(D22-E22)/(2*NORM.INV(0.975,0,1)) | =(C22^2)/(F22^2) | =(F22^2)/C22 | =GAMMAINV(RAND(),H22,I22) | |
15 | 18 | 12 | =(D23-E23)/(2*NORM.INV(0.975,0,1)) | =(C23^2)/(F23^2) | =(F23^2)/C23 | =GAMMAINV(RAND(),H23,I23) |
Last edited by a moderator: