Calculating Population Mean in Excel

[dynamics]

Hello, i am having trouble with working out what the population mean is. Is there a formula in Microsoft Excel to workout the population mean. I have a population of 200

 

[HallsofIvy]

You learned how to find an "average" (mean) way back in elementary school! (There are several different "averages". The mean is the one you first learned as an average.) Add up all the numbers and divide by 200.

If you know all that and your question is specifically about how to do it in Microsoft Excel, use "average".

 

[ZioX]

Please do note if you're taking your data from a sample, you're calculating a sample mean. If you you're taking data from the whole population it is the population mean. The distinction is very important in statistics.

 

[aziz4z]

see I mde small calculation by excel for population statstic include mean,variance, standerd deviation,covariance and so on...

https://www.physicsforums.com/attachment.php?attachmentid=18387&stc=1&d=1239287367View attachment Aziz.xls