HP Forums

Hi all,

I am tryed make mean and Sd of 6 valors:

Week 1 = 1500
Week 2 = 1600
Week 3 = 1920
Week 4 = 1560
Week 5 = 1340
Week 6 = 980

Doing in the spreadsheet

mean(b2:b7) have result 4450/3 ???
stddevp(b2:b7) have result 10* sqrt(8718/3).

someone could help me?

(11-24-2014 01:31 PM)Elton Freitas Wrote: [ -> ]Hi all,

I am tryed make mean and Sd of 6 valors:

Week 1 = 1500
Week 2 = 1600
Week 3 = 1920
Week 4 = 1560
Week 5 = 1340
Week 6 = 980

Doing in the spreadsheet

mean(b2:b7) have result 4450/3 ???
stddevp(b2:b7) have result 10* sqrt(8718/3).

someone could help me?

These are correct exact answers. If you want the approximate decimal ones, try

=approx(mean(b2:b7)) which should give 1483.33...

Interestingly, un-checking Exact: in CAS settings still required approx() in the spreadsheet, but not in CAS.