Find percentage from data which are less than mean value

[azizurrahman]

Hi... Pls help me with the following....

A LED light producer tested the life of 30 samples. The question asked to find minimum and maximum LED light life by using spreadsheet formula, which I did. Then, I am stuck when it asked to Find the percentage of LED lights which have less than mean life.

 

[Joe4]

Welcome to the Board!

Here is a hint. Use the AVERAGE function to get the mean.
Then, you can use that in a COUNTIF formula to count the number of records below it.

 

[azizurrahman]

Oh.... it worked,... thanx a lot Joe...

 

[Joe4]

You are welcome!