Difference between revisions of "Manuals/calci/SQRT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | <div style="font-size:30px">'''SQRT(n)'''</div><br/> | ||
| + | *<math>n</math> is any positive number. | ||
| + | |||
| + | |||
| + | ==Description== | ||
| + | *This function gives the square root of a positive real number. | ||
| + | *Squaring is the value that can be multiplied by itself to give the original number. | ||
| + | *The square root of a number is the inverse operation of squaring that number. | ||
| + | *The root of a number is an equal factor of the number. | ||
| + | *Every non-negative real number a has only one non-negative square root, called the principal square root, which is denoted by <math>\sqrt{a}</math>, where <math>\sqrt</math> is called the radical sign or radix. | ||
| + | *Square roots of positive whole numbers that are not perfect squares are always irrational numbers. | ||
| + | *Numbers not expressible as a ratio of two integers . | ||
| + | This function will give the result as NaN when n is a negative number. | ||
| + | |||
| + | ==Examples== | ||
| + | #=SQRT(0)=0 | ||
| + | #=SQRT(1)=1 | ||
| + | #=SQRT(136)= 11.661903789690601 | ||
| + | #=SQRT(ABS(-625))= 25 | ||
| + | #=1..10@SQRT | ||
| + | {| class="wikitable" | ||
| + | |+Spreadsheet | ||
| + | |- | ||
| + | ! !! Number !! Square Root | ||
| + | |- | ||
| + | | 1 || 1 | ||
| + | |- | ||
| + | | 2 || 1.414214 | ||
| + | |- | ||
| + | |3 || 1.732051 | ||
| + | |- | ||
| + | |4 ||2 | ||
| + | |} | ||
| + | |||
| + | |||
| + | 1 1 | ||
| + | 2 1.4142135623730951 | ||
| + | 3 1.7320508075688772 | ||
| + | 4 2 | ||
| + | 5 2.23606797749979 | ||
| + | 6 2.449489742783178 | ||
| + | 7 2.6457513110645907 | ||
| + | 8 2.8284271247461903 | ||
| + | 9 3 | ||
| + | 10 3.1622776601683795 | ||
| + | |||
| + | |||
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | ||
Revision as of 00:28, 24 March 2014
SQRT(n)
- is any positive number.
is any positive number.
Description
- This function gives the square root of a positive real number.
- Squaring is the value that can be multiplied by itself to give the original number.
- The square root of a number is the inverse operation of squaring that number.
- The root of a number is an equal factor of the number.
- Every non-negative real number a has only one non-negative square root, called the principal square root, which is denoted by , where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sqrt} is called the radical sign or radix.
- Square roots of positive whole numbers that are not perfect squares are always irrational numbers.
- Numbers not expressible as a ratio of two integers .
, where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sqrt}
is called the radical sign or radix.This function will give the result as NaN when n is a negative number.
Examples
- =SQRT(0)=0
- =SQRT(1)=1
- =SQRT(136)= 11.661903789690601
- =SQRT(ABS(-625))= 25
- =1..10@SQRT
| Number | Square Root | |
|---|---|---|
| 1 | 1 | |
| 2 | 1.414214 | |
| 3 | 1.732051 | |
| 4 | 2 |
1 1
2 1.4142135623730951
3 1.7320508075688772
4 2
5 2.23606797749979
6 2.449489742783178
7 2.6457513110645907
8 2.8284271247461903
9 3
10 3.1622776601683795
Syntax
It is the number for which you want the square root.
SQRT gives a positive square root.
If number is negative, SQRT gives ‘NaN‘ an error
Consider n = 625 then
=SQRT(625) gives 25
| Column1 | ||
| Row1 | 625 | |
| Row2 | 25 |
ZOS
1..10@SQRT
| Number | SQRT |
|---|---|
| 1 | 1 |
| 2 | 1.4142135623730951 |
| 3 | 1.7320508075688772 |
| 4 | 2 |
| 5 | 2.23606797749979 |
| 6 | 2.449489742783178 |
| 7 | 2.6457513110645907 |
| 8 | 2.8284271247461903 |
| 9 | 3 |
| 10 | 3.1622776601683795 |