Square Root in Excel

This tutorial demonstrates how to use the Excel function SQRT. This allows you to determine the square root of any number, within a spreadsheet program.

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics s ...more

In this video the instructor shows how to sketch the graph of x squared and square root of x. The first equation is the x squared which is y = x * x. Now to sketch this take a sample values of x and substitute in the equation to get the value of y. Similarly find the set of po ...more

In this video the instructor shows how to solve quadratic equation by the square root method. The square root property of equations states that if k is positive and a*a = k, then a is equal to square root of k or -1 times the square root of k. So to solve a quadratic equation ...more

Professor ElvisZap teaches you how to stretch shift and reflect the graph of a square root. A square root function is the opposite of a squared function. You start with y=square root of (x-1) it becomes 0<=x-1. then 1 <=x. You use the graph and solve it as you would for any fu ...more

On Yay Math, Robert Ahdoot, founder of Yay Math, will show you some square root functions and some inequalities. He begins with the problem y=x². Then he makes a sketch with two intersecting lines in a t shape. The problem is illustrated by a curved U shape, the U's bottom res ...more

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical sup ...more

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this in ...more

In algebra, you can solve a quadratic equation by applying the square root rule. With a squared term and a constant, the special quadratic equation is easily solved. Could you use a little help figuring out how to divide fractions? Watch this free video lesson. From Ramanujan ...more

With mathematics, as with anything else, not everyone progresses at the same rate. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time i ...more

This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are pu ...more

Solving 6 math problems using different methods is the idea behind this video. First, you make three rows of numbers vertically from 1-9. All the numbers match across for example, 1 1 1, 2 2 2, 3 3 3, and so on. Each set of numbers creates a mathematical problem who's solution ...more

Learn how to work with i, the imaginary square root of negative 1, in intermediate algebra. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier ...more

robichaudd teaches you how to simplify square roots. When you're dealing with variables, even powers and you want to find out the square root of it, you follow the process. Divide the power by the root, which is two, because it's a square root, that gives you what comes out. I ...more

In this math tutorial, you will learn how to simplify square roots with product and quotient rules. To begin, you will need to multiply the square roots so that the two square roots in your equation are reduced down into one. The rule for non-negative "A" and "B" is that the s ...more

In this video the instructor shows how to simplify radicals. A radical is nothing but another name for a square root. To find the square root of a simple number the first thing that you need to do is factor it. If you need to compute the square root of a number, you first need ...more

A square root of a number is a value which when multiplied to it self gives you the original number. The square roots of perfect squares are whole numbers. Like square root of 9 is 3, because 3 times 3 is 9. Similarly square root of 81 is 9 because 9 times 9 is 81. Others numb ...more

This is the video about how to evaluate square roots. The square root of a number is a number that you can square to get it, that is, a number that you can multiply by itself to get the number. So, 2 is a square root of 4, because 2 x 2 = 4, and 3 is a square root of 9, becaus ...more

Equations involving square roots are difficult to solve because of the complexity involved in performing operations on the square root terms. But you can follow a series of steps to solve these problems easily. To solve these kind of problems first isolate the square root term ...more

In this lesson we will learn about one of the most important concepts in algebra SQUARE ROOTS. The square root of a number m is another number n that satisfies the following formula: m = n x n. You can also say that m is the square of n. The opposite of squaring a number is f ...more

In this math lesson, you will learn how to find the square root of a number without using a calculator. You can even find the square roots of large numbers by following this simple algorithm. The above video demonstrates how to find the square root by hand. Sometimes you migh ...more

In this tutorial, we learn how to rationalize square roots. You cannot have square roots in the denominator of an equation. You need to multiply so the square root goes away. You can do this by multiplying the top and bottom of the equation by the bottom denominator. From here ...more

This is a video tutorial on how to simplify square roots. To simplify square roots, one must have the knowledge of splitting numbers into prime factors. For example,12 can be split into 4*3 and further more into 2*2*3. Here we see that all the factors are prime numbers. So the ...more

In this tutorial we learn how to multiply and simplify square roots. When you multiply square roots, you will first need to put them under one radical. From here, you will need to factor out what you have. Once you find a perfect square, find the square root of it. You can eit ...more

Could you use a little help figuring out how to simplify numbers left in square root form? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks ...more

This video in the Education category will show you how to simplify radicals before adding or subtracting. By doing this you will find all like radicals which will then ensure that you have all radicals in the simplest form. Let’s say you want to subtract square root of 45 from ...more

Radicals are square roots which are not integers; the square roots of 2 or 3 are examples of radicals. The presenters show simple ways of how to add and subtract such radicals. They explain that by using the method of factoring, the addition or subtraction is made very easy. I ...more

In this algebra video the instructor shows how to work with complex numbers. When you have a positive number under the square root, you can easily find its value by writing it in the form of product of numbers, and then solving. That is, to find the square root of a positive n ...more

When you need to compute the square root of a number you can do it by breaking it into perfect squares. When you can split the given number into small perfect squares you can cancel out the square root of the expression to the square of the perfect squares. You cannot always w ...more

While dividing the radicals, the numerator and the denominator must be combined into a single term, for example if we want to divide square root of 3 by square root of seven we need to combine the numerator and denominator into a single factor that is square root of 3/7, then ...more

In this video, we learn how to rationalize the denominator. This says that if there is a square root or any type of root, you need to get rid of them. Look at the examples given in the video to get an idea of what types of roots you will be removing and how to do it. To get ri ...more

In this video the instructor explains the concepts of rational and irrational numbers. Multiplying a number by itself gives the value of its square. If you apply the square root to that squared number it returns to you the original number. This square root is also called a rad ...more

Pythagoras was a smart man, so smart that his mathematical theory is named after him and still used today, more than 2,000 years later: the Pythagorean theorem. It implies that the square of the hypotenuse of a right triangle is equal to the sum of the squares of the other two ...more

In this video the instructor shows how to solve an equation with a radical under a radical. If you have an equation with a square root on both sides, with one of the sides having another inner square root under the original square root, it can be a little tricky to solve it. ...more

In this video, we learn how to rationalize a denominator that contains a surd. First, you need to rationalize the denominator by removing any square root sign. To do this, you will multiply the fraction but the flip of the denominator over itself, with the square root. Then, y ...more

This video teaches us the concept of nth roots. The video starts with the square root of constants. We find the number which when multiplies by itself for two times results in the constant inside the square root. Then we find the square root of variables. Here again the same c ...more

In this video, the instructor demonstrates how to solve radical equations and inequalities. If you have an equation that contains radicals, re-,arrange the equation so that all the radicals are on one side and the integers are on the other side. To cancel a square root from an ...more

Here we look at squaring expressions that involve radicals because people tend to make some common mistakes while solving such expressions. Take 5 times the square root of y quantity squared, the answer here is not 5y. Here's the reason, square means to multiply something with ...more

In this video the tutor shows how to simplify a quadratic formula result. You can solve a quadratic equation using the quadratic formula. The first thing you have to do when given the quadratic equation is bring all the terms to one side so that you have a zero on the other si ...more

This video demonstrates how to do anti-differentiate functions with radicals in calculus. To simply problems, try to substitute. For example, in the problem, the integral of x times the square root of x plus 2 dx. You can substitute w for everything underneath the radical: i.e ...more

This video shows the method to write a logarithm as a sum or difference of logarithms. The square root of the term given is taken out as half according to the rule. Then the numerator and denominator is divided into product of factors. This is broken into the difference of num ...more

In this video the instructor shows who to simplify radicals. If you have a term inside a square root the first thing you need to do is try to factorize it. First factorize the numerical term. Write down the numerical terms as a product of any perfect squares. Now split the ori ...more

YAYMATH. This video is a demonstration of usage of the distance formula to find the distance between two given (x,y) points. In this video, the tutor guy who is teaching the distance formula to his students takes an example of two (x,y) points such as (5,-1) and (11,7). He the ...more

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other. You Will Need: • Data • A calculator Step 1: Collect your d ...more

Radical expressions are those in which the radical symbol (under root sign denoting the square root or the nth root) is present (either multiplied or added). Solving these is a bit tricky, but involves similar algebraic maneuvers in a different way. This video begins with an ...more

Learn how to factor perfect square polynomials and how to solve equations using the square root property. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Interne ...more

In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square ...more

In this tutorial, we learn how to understand fractional exponents. Starting with an example, let's say you have the square root of four as an equation. The answer to this is two. A fractional exponent is not much different than this problem. Let's say you have 4 to the 1/2 pow ...more

If you are given an equation of ellipse in the form of a function whose value is a square root, you may need to simplify it to make it look like the equation of an ellipse. Now equate the function to a variable y and perform squaring on both sides to remove the radical. Now si ...more

In this tutorial, we learn how to use the distance formula for two points. The distance formula is D= the square root of (X2-X1) squared, plus (Y2 minus Y1) squared. It may look confusing, but it's just a derivation of a theorem. First, find the two points that you have and gr ...more

Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area ...more

In this video the instructor shows the different methods of solving quadratic equations. There are many methods to solve quadratic equations each with its pros and cons, each method suitable for a particular situation. The first method to solve quadratic equation is factoring. ...more

Algebra – The Distance Formula. This video describes how to find the distance between 2 points of a graph in a step by step method. Made by Ya Math, the instructor assists the class in finding the distance between (6,8) and (3,4) by showing us the equation d=v((x_1-x_2 )^2+(y_ ...more

In order to solve a quadratic equation by completing the square, take a quadratic equation and make sure that the coefficient of the first squared term in one. If it is not factor it by pulling the term out to get it to one. Now just write down the first two terms in side a br ...more

First you want to find X using the identities given for a 45-45-90 triangle. When comparing the triangles in the video, we find that X must be 6. Next, use the identity to solve for the measurements of the sides of the triangle. In the video example, 6 is the length of the two ...more

In Final Fantasy VII, it's possible to max out vitality without any store-related progress needed if your strength stat has already been maxed. Take a look at this video and learn how to max out vitality simply by targeting an enemy called "spiral". This enemy has around 2800 ...more

In this video, the narrator presents the viewer with a quick, painless way of simplifying cube roots. The narrator presents many methods to simplify square roots to appeal to different learning styles. By doing things like dividing the power by the root to figure out the power ...more

Kimchi can be spelled in a variety of ways (gimchi, kimchee, kim tee), but what is it exactly? It's a Korean pickled dish made with vegetables and varied seasonings, and it's the most common side dish in South Korea. In this video tutorial, you'll gain the recipe for making ki ...more

Watch this video from This Old House to learn how to transplant a tree. Steps: 1 Wrap tree with rope to protect the branches during transport to new location. 2 Measure the width of tree trunk; multiply by 10 to determine root ball diameter. 3 Tie tope around trunk to represe ...more