Last answered:

19 Nov 2022

Posted on:

31 Oct 2022


using excel for the calculations

Hi, is there aana excel formula for the pooled variance and the pooled stdv? thanks..

1 answers ( 0 marked as helpful)
Posted on:

19 Nov 2022


download Workbook 4.9.+Confidence+intervals+Two+neans.+independent+samples+(Part+2)_excercise

SHEET CI, indep, var unkwn
                           NY      LA
Sample mean $3.94   $3.25    ***MEAN FORMULA*** =AVERAGE(B10:B19) | =AVERAGE(C10:C17)
Sample std    $0.18   $0.27    ***Std. dev formula***  =STDEV.S(B10:B19) | =STDEV.S(C10:C17)
Sample size       10        8

***Pooled variance formula*** =(F11*F11*9+G11*G11*7)/16

what is being calculated inside the formula =               (NY*NY*9+LA*LA*7)/16
Column Row #s being pulled may differ in your sheet =(F11*F11*9+G11*G11*7)/16
the actual numbers being pulled =                             (3.94*3.94*9+3.25*3.25*7)/16

***Pooled std formula*** =SQRT(F14)
=SQRT of Pooled variance
Squared root of 0.05 equals Pooled variance = 0.22

Submit an answer