calculating a weighted average uisng formula

B

bob green

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating a weighted average using formula 1
Finding the weighted average of text that have been given values 1
weighted average - 1 column 2
Simplify Weighted Average Formula 4
weighted average from table 4
Formula (array?) to compute weighted average balance 1
Create Formula for Weighted Average in non-consecutive cells 0
How to omit blank cells when calculating weighted averages 20

Top