Remote Whiteboard

admin@remotewhiteboard.comContact us on

Statistics Spreadsheet

stats144We have a new app coming out soon, a spreadsheet especially for anyone interested in doing statistical analysis. It is our popular statistics app, using lots of useful functions especially designed to analysis. Here are the list of what we have added, with more functions coming soon.

AVEDEV – Find the average deviation
STDDEV – Find the standard deviation
NORMDIST – Find the normal distribution (x,mean,stddev,cumulative)
NORMSDIST – Returns the standard normal cumulative distribution function. With a mean=0, stddev=1
ZTEST – one-tailed probability-value of a z-test (array,μ0,sigma)
COMBIN – Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
BINOMDIST – Returns the individual term binomial distribution probability. BINOMDIST(number_s,trials,probability_s,cumulative)
CORREL – Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.
CONFIDENCE – Returns a value that you can use to construct a confidence interval for a population mean.

And of course all our regular spreadsheet functions are also included.
SUM – Sum a range of cells
AVG – Average of a range of cells
DAT – Put date
MIN – The minimum value in a range of cells
MAX – The maximum value in a range of cells
ABS – Absolute value
CEIL – Rounds a number to the nearest integer
FLOOR – Rounds a number down, toward zero
COS – Cosine
SIN – Sine
TAN – Tangent
RAD – Convert degrees to radians
DEG – Convert radians to degrees
PI – Pi or Π
ACOS – Arccosine
ASIN – arcsine
ATAN – arctangent
EVEN – Rounds number up to the nearest even number
ODD – Rounds number up to the nearest odd number
INT – Rounds number up to the nearest integer
LN – Returns the natural logarithm of a number
LOG – Returns the logarithm of a number to a specified base
LOG10 – Returns the base-10 logarithm of a number
GRAPH – Create the graph using the graph button
SQRT – Square root of number
COUNT – Counts fields
TRUNC – Truncates number to whole number

Expect it out soon!