ms excel as a mean to calculate mean,mode ,median, standard deviation, regression, plot curve fitting?

0 ⤊

ms excel as a mean to calculate mean,mode ,median, standard deviation, regression, plot curve fitting?

2007-03-18 21:31:59 · 3 answers · asked by bipan r 1 in Science & Mathematics ➔ Mathematics

3 answers

yeah, it can do all of those calculations

2007-03-18 21:41:09 · answer #1 · answered by abd 5 · 0⤊ 0⤋

If the data is Perfectly normally distributed, then the mean and median are the same. However, unless you are *specifically* told that the data is normally distributed, you can't determine the median. (or, if you've been given a set of numbers, you can find the median using the regular methods, but you can't assumed the mean and median are the same if it's not normally distributed.)

2016-03-29 05:59:56 · answer #2 · answered by Anonymous · 0⤊ 0⤋

checkout this website www.ExcelGoodies.Com , They teach u all there..

2007-03-22 12:11:12 · answer #3 · answered by Anonymous · 0⤊ 0⤋