Mean and StandDesviation
11-24-2014, 01:31 PM
Post: #1
 Elton Freitas Junior Member Posts: 17 Joined: Jun 2014
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

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

someone could help me?
11-24-2014, 04:58 PM
Post: #2
 CR Haeger Member Posts: 275 Joined: Dec 2013
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

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.
 « Next Oldest | Next Newest »

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