| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
calculating a weighted average uisng formula
I have data from a series of studies in 2 columns of data (G1-G15) & (H1-H15). Column 1 = the number positive for an event in each study Column 2 = the sample size for each study I calculated a sum for column 1 & column 2 in G16 & H16 respectively. In addition I want to calculate the average and standard deviation. The following formula computes an average but I also need the standard deviation. =G16*100/H16 Any assistance is appreciated. Bob |
|
#2
|
|||
|
|||
|
Hi!
=STDEV(G1:G15) =STDEV(H1:H15) Biff "bob green" wrote in message .. . I have data from a series of studies in 2 columns of data (G1-G15) & (H1-H15). Column 1 = the number positive for an event in each study Column 2 = the sample size for each study I calculated a sum for column 1 & column 2 in G16 & H16 respectively. In addition I want to calculate the average and standard deviation. The following formula computes an average but I also need the standard deviation. =G16*100/H16 Any assistance is appreciated. Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
| Average Formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Weighted Average | Excel Discussion (Misc queries) | |||
| Calculating and locking the esult of a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
