Spreadsheet::Engine::Function::STDEVP - Spreadsheet funtion STDEVP()


Spreadsheet-Engine documentation Contained in the Spreadsheet-Engine distribution.

Index


Code Index:

NAME

Top

Spreadsheet::Engine::Function::STDEVP - Spreadsheet funtion STDEVP()

SYNOPSIS

Top

  =STDEVP(list_of_numbers)

DESCRIPTION

Top

This returns the standard deviation.

We calculate as per Knuth "The Art of Computer Programming" Vol. 2 3rd edition, page 232

HISTORY

Top

This is a Modified Version of code extracted from SocialCalc::Functions in SocialCalc 1.1.0

COPYRIGHT

Top

LICENCE

Top

The contents of this file are subject to the Artistic License 2.0; you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.perlfoundation.org/artistic_license_2_0


Spreadsheet-Engine documentation Contained in the Spreadsheet-Engine distribution.

package Spreadsheet::Engine::Function::STDEVP;

use strict;
use warnings;

use base 'Spreadsheet::Engine::Function::VARP';

sub result_from {
  my ($self, $A) = @_;
  die Spreadsheet::Engine::Error->div0 unless $A->{count} > 1;
  return sqrt $self->SUPER::result_from($A);
}

1;

__END__