If your data is in B1 thru B100, use:

=STDEV(B1:B100)
--
Gary''s Student - gsnu200738


"Kris@CEC" wrote:

I created a graph and then a trendline to get the slope of the line and then
used m to determine another value which would be constant for all data in
that data set (least squares regression). HOWEVER, I also have to find the
mean and st. dev. for this data. I know the mean is obviously the same at
the constant, but what is the standard deviation and how do i calculate that
off the chart (I'm assuming i do since it seems my only option as i'll always
get 0 in the numerator in the st. dev. function).