Difference between revisions of "Manuals/calci/STATS"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''STATS(a,b,c)'''</div><br/>
+
<div style="font-size:30px">'''STATS (Array,ResultTabular,IsHorizontal)'''</div><br/>
*<math>a</math> is the starting number of the set.
+
*<math>Array</math> is any set of numbers to start.
*<math>b</math> is the ending number of the set.
+
*<math>ResultTabular</math> is any set of numbers to end.
*<math>c</math> is the step number.
+
*<math>IsHorizontal</math> is the step number.
  
 
==Description==
 
==Description==
Line 10: Line 10:
 
*If the data set is based on a sample of a larger population, then the analyst can extend inferences onto the population based on the statistical results from the sample.
 
*If the data set is based on a sample of a larger population, then the analyst can extend inferences onto the population based on the statistical results from the sample.
 
*Statistical measures include regression analysis, mean, kurtosis, skewness, analysis of variance and variance.
 
*Statistical measures include regression analysis, mean, kurtosis, skewness, analysis of variance and variance.
*Here STATS(a,b,c),where a is the first number,b is the last number and c is the step number.  
+
*Let a=Array,b=ResultTabular and c=IsHorizontal.
 +
*Then STATS(a,b,c),where a is the first number,b is the last number and c is the step number.  
 
*In Calci,STATS function showing how many numbers, sum of the given numbers,average,variance,standard deviation,minimum and maximum value of the given set of numbers, median and mode of the numbers.
 
*In Calci,STATS function showing how many numbers, sum of the given numbers,average,variance,standard deviation,minimum and maximum value of the given set of numbers, median and mode of the numbers.
 
*The result values will display horizontally when the syntax is STATS(a..b,c).
 
*The result values will display horizontally when the syntax is STATS(a..b,c).
Line 41: Line 42:
 
| MODE || #ERROR
 
| MODE || #ERROR
 
|}
 
|}
<font color ="Red">Need to give examples for horizontal result.STATS(220,270,5) </font>
+
 
 
2. STATS(198,134,6)
 
2. STATS(198,134,6)
 
{| class="wikitable"
 
{| class="wikitable"

Latest revision as of 14:46, 18 June 2018

STATS (Array,ResultTabular,IsHorizontal)


  • is any set of numbers to start.
  • is any set of numbers to end.
  • is the step number.

Description

  • This function gives the statistics value of the given set of numbers.
  • Statistics is the general term and it is used to summarize a process that an analyst, mathematician or statistician can use to characterize a data set.
  • So Statistics is the science of learning from data, and of measuring, controlling, and communicating uncertainty.
  • If the data set is based on a sample of a larger population, then the analyst can extend inferences onto the population based on the statistical results from the sample.
  • Statistical measures include regression analysis, mean, kurtosis, skewness, analysis of variance and variance.
  • Let a=Array,b=ResultTabular and c=IsHorizontal.
  • Then STATS(a,b,c),where a is the first number,b is the last number and c is the step number.
  • In Calci,STATS function showing how many numbers, sum of the given numbers,average,variance,standard deviation,minimum and maximum value of the given set of numbers, median and mode of the numbers.
  • The result values will display horizontally when the syntax is STATS(a..b,c).
  • The result values will showing vertically when the syntax is STATS(a..b..c).

Examples

  • 1.STATS(5..450)
COUNT 446
SUM 101465
AVERAGE 227.5
VAR 16613.5
STDEV 128.89336678045152
VARP 16576.25
STDEVP 128.7487864020473
MIN 5
MAX 450
MEDIAN 227.5
MODE #ERROR

2. STATS(198,134,6)

COUNT SUM AVERAGE VAR STDEV VARP STDEVP MIN MAX MEDIAN MODE
1 198 198 NaN NaN 0 0 198 198 198 #ERROR

Related Videos

Statistical Functions

See Also

References