https://wiki.zcubes.com/index.php?title=Manuals/calci/AVERAGEBOTTOM&feed=atom&action=historyManuals/calci/AVERAGEBOTTOM - Revision history2024-03-28T21:54:06ZRevision history for this page on the wikiMediaWiki 1.35.2https://wiki.zcubes.com/index.php?title=Manuals/calci/AVERAGEBOTTOM&diff=211505&oldid=prevDevika: Created page with "<div style="font-size:30px">'''AVERAGEBOTTOM (Range,TopCount) '''</div><br/> *<math>Range</math>can be any set of real numbers. *<math>TopCount</math> can be number of numbe..."2018-12-27T23:34:00Z<p>Created page with "<div style="font-size:30px">'''AVERAGEBOTTOM (Range,TopCount) '''</div><br/> *<math>Range</math>can be any set of real numbers. *<math>TopCount</math> can be number of numbe..."</p>
<p><b>New page</b></p><div><div style="font-size:30px">'''AVERAGEBOTTOM (Range,TopCount) '''</div><br/><br />
<br />
*<math>Range</math>can be any set of real numbers.<br />
*<math>TopCount</math> can be number of numbers from Bottom.<br />
**AVERAGE(), returns the average of its arguments.<br />
<br />
==Description==<br />
<br />
*This function gives the Average for given set numbers. <br />
*Average means sum of all the given elements divided by Number of given elements.<br />
*It is also called Arithmetic mean. <br />
*i.e if <math>n</math> numbers are given and each number is denoted by <math>a_i</math>, where <math>i=1</math> to <math>n</math>, then <br />
<math>A.M=\frac{1}{n}\sum_{i=1}^n a_i</math> = <math>\frac{1}{n}(a_1+a_2+.....+a_n)</math>. <br />
*In this function,the parameters can either be numbers,arrays,references of cells or we can enter the logical values directly.<br />
*Arithmetic mean is the most common measures of central tendency.<br />
*Central tendency is a single value that attempts to describe a set of data by identifying the central position within that set of data. <br />
*The other common measures of central tendency are: Median,& Mode. <br />
*A.M is calculated by adding the given set of numbers and divided by the count of the given set of numbers. <br />
Average of 2,4,2,7,2,3 and 5 is 3.6<br />
*Median: It is the middle number of a sorted list(Ascending order) of numbers.<br />
The median of 2,2,2,3,4,5,7 is 3<br />
*Mode: It is the most frequently repeated number in a given set of numbers. <br />
The mode of 2,2,2,3,4,5 and 7 is 2.<br />
*This function will show the result as Error,<br />
#when the values are error values or text that cannot change in to numbers.<br />
<br />
<br />
==Examples==<br />
<br />
*AVERAGEBOTTOM([18,23,87,45,56,17,26,67,19,20],4) = 33<br />
*AVERAGEBOTTOM([5,-2,7,8,11,20,25,-9,12,18,23,76,89,129,98],7) = 63.57142857142857<br />
<br />
<br />
==Related Videos==<br />
{{#ev:youtube|9VZsMY15xeU|280|center|Average}}<br />
<br />
==See Also==<br />
<br />
*[[Manuals/calci/AVERAGE | AVERAGE ]]<br />
*[[Manuals/calci/AVERAGETOP | AVERAGETOP ]]<br />
*[[Manuals/calci/AVERAGEA | AVERAGEA ]]<br />
<br />
==References==<br />
[http://en.wikipedia.org/wiki/Average| Average]<br />
<br />
<br />
<br />
*[[Z_API_Functions | List of Main Z Functions]]<br />
<br />
*[[ Z3 | Z3 home ]]</div>Devika