+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Mean and StandDesviation (/thread-2483.html)
Mean and StandDesviation - Elton Freitas - 11-24-2014 01:31 PM
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?
RE: Mean and StandDesviation - CR Haeger - 11-24-2014 04:58 PM
(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.