Türk | İngilizce |
---|---|
KAREKÖK | SQRT |
Calculating and Using Square Roots
Microsoft Excel and Google Sheets are spreadsheet programs that include an extensive set of mathematical functions. One such function, SQRT, calculates the square root of a number. A square root is a number which, when multiplied by itself, yields the original number. The SQRT
function returns only positive results and will produce an error if a negative number is input.
Function Syntax
The basic syntax of the SQRT
function is as follows:
SQRT(number)
Here, number
is the number for which you want to find the square root. If the number is negative, Excel returns a #NUM! error.
Examples of Using SQRT
-
=SQRT(9)
yields a result of 3. -
=SQRT(16)
yields a result of 4. -
=SQRT(-4)
results in a #NUM! error because the square root of a negative number is not defined as a real number in mathematics.
Practical Applications
The SQRT function can be used in various fields, from engineering to finance. Here are two practical applications:
Application 1: Geometric Problems
Suppose you know the area of a square and need to determine the length of its sides. If the area is 25 cm², you can calculate the side length using the square root function:
=SQRT(25)
This formula computes the length of one side of the square as 5 cm.
Application 2: Financial Modeling
The SQRT function can be utilized to calculate the standard deviation of investment returns. For example, if the variance of annual return rates is 16%, to compute the standard deviation, you would use:
=SQRT(0.16)
This calculation indicates that the standard deviation is approximately 0.4%, which is critical for assessing risk.
Summary
The SQRT function is easily accessible in Excel and Google Sheets and serves as a fundamental tool for mathematical calculations. It offers a wide range of applications, from geometric computations to financial analysis.
Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/karekök-işlevi-654975c2-05c4-4831-9a24-2c65e4040fdf