Post Reply 
Mean and StandDesviation
11-24-2014, 01:31 PM
Post: #1
Mean and StandDesviation
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?
Find all posts by this user
Quote this message in a reply
11-24-2014, 04:58 PM
Post: #2
RE: Mean and StandDesviation
(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.
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)