How to calculate mean median mode and standard deviation in excel?
Answers
Answered by
2
(i)mean=>sum of observation / no. of observation
for ex=> 1 + 2 + 3 + 2 / 4
=8/4
ans = 2
=> mean is also known as average
(ii) mode=> most common number in the interval
for ex=> 1 + 2 + 3 + 2
ans=>2
=>there is also a formula to find mode , but I don't know please find if you want .
(iii)median=>middle number is the median , if there are two middle numbers then follow the given formula :-
addition of both numbers / 2
for ex => 72 + 74 + 76 + 78
=>74 + 76/2
=>150 / 2
ans=>75
for ex=> 1 + 2 + 3 + 2 / 4
=8/4
ans = 2
=> mean is also known as average
(ii) mode=> most common number in the interval
for ex=> 1 + 2 + 3 + 2
ans=>2
=>there is also a formula to find mode , but I don't know please find if you want .
(iii)median=>middle number is the median , if there are two middle numbers then follow the given formula :-
addition of both numbers / 2
for ex => 72 + 74 + 76 + 78
=>74 + 76/2
=>150 / 2
ans=>75
Similar questions