Solving Complex Search Results

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Apply the distributive property in math

To solve simple algebraic expressions you have to use different properties. Distributive property is one among them. To apply distributive property in a algebraic expression multiply each term inside the parenthesis by the outside term. In this way you are distributing the outside term to all the inside terms and removing the parenthesis. Hence it is called distributive property. After multiplying add the like terms to simplify it further. Care should be taken to ensure the proper sign change...

How To: Mutliply rational numbers and understand word problems

Rational numbers are numbers that can be expressed in the form of a/b, where a, b are integers and b is not equal to zero. Rational numbers are also called as fractions. Multiplication of fractions is very simple and straight forward. Two multiply two fractions a/b, c/d first multiply both the numerators to arrive at the new numerator. Next multiply both the denominators to arrive at the new denominator. Now the new fraction can be further simplified to arrive at the solution. Note that you a...

How To: Divide exponents with the quotient rule

Exponent of a number is nothing but the number multiplied to it self the exponent number of times. So five squared it equal to five multiplied to it self. Now when an exponential number is divided with another such number the result is the number raised to the different of the exponents. That is the ratio of x raised by a to x raised by b is x raised to (a-b). Similarly if we multiply a exponential number with other such number, the result is equal to that number raised to the sum of exponent...

How To: Find the equation of a line in point-slope form

When you are given a point through which a line passes and the slope of that line, you can calculate the equation of that line. The general equation to solve this kind of equations is called as point-slope form. The point slope of a line passing through (a, b) with slope of m is (y - b) = m * (x - a). Now substituting the values in the above equation you can obtain the equation of the line in terms of x and y. In case you are given with two points first find the slope of the line which is the...

How To: Properly read a decimal number

Decimal numbers are numbers which contain a integral part before a point and a decimal part after the point. The first step in solving decimal arithmetic is being able to understand decimal numbers. Reading a decimal number is similar to reading a whole number except for a few minor differences. In a normal number the right most digit is ones place and the place next to it is tens place and so on the value of the position increases as you move left. But a decimal number starts from a tenths p...

How To: Create a column of unique values in an Excel LU table

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.

How To: Calculate excess over a hurdle in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!

How To: Use Virtual DJ with a laptop, DJ|iO & a mixer

In this brief video tutorial, the host show you how to mix songs and DJ using Virtual DJ. He recommends that you use a laptop with a minimum of four gigs of ram, have a version of Virtual DJ 5.0 or higher, have a mixer readily available, and have your own DJIO machine with the proper drivers and installation discs. You'll also learn how to solve a few common problems you may encounter with this software. This video is very informative for everyone who is interested in learning how to DJ using...

How To: Solve basic percentages

In this video tutorial, viewers learn how to work out basic percentages. The key is to always find 10% of the number first. To find 10%, divide the number by 10. It's very simple because you simply move one decimal to the left. Once you have found the 10%, you can simply find the next 10% by doubling the number. The other thing you can do is find 5% of the number by dividing the 10% number in half. This video will benefit those viewers who have trouble with find percentage or forgot how to an...

How To: Repair a broken PS3

In this Video Games video tutorial you will learn how to repair a broken PS3. For this you got to put the PS3 into stand by mode. Press down the button located at the top end of the console for 7-10 seconds and listen for 3 beeps. It may not work the 1st time. So, do it again. Then this message is flashed on the TV screen – ‘connect the controller using a USB cable etc’. Once you connect the USB cable the trouble shooter prompt comes up displaying 6 options. If you are not using HDTV this wil...

How To: Find the area and volume of prisms

This helpful video gives simple step by step instructions on how to find area and volume of prisms. To find the area of a prism you must first find the area of the base, it may be rectangular, triangular, or otherwise. You must then multiply the area of the base times the height. Examples of all types of scenarios are given to better explain the method of finding the area. To find the volume of a triangular prism you must first find the area of the base. The next step is multiplying the area ...

How To: Begin playing Sudoku

Jacky Liao and Tony Liao describe the main attributes of Sudoku and provide tips on how to solve the puzzle. Sudoku is a popular puzzle just like crossword. It is a puzzle of a 9X9 square sub-divided into 3X3 squares. You have to fill each column and row with digits 1 through 9 in any order. Each 3X3 sub-square must include all digits 1 through 9. Every Sudoku game starts with a few of the squares filled in. The more squares that are filled in the easier it is to play. As you fill in the squa...

How To: Graph linear equations using y=mx+b

This video is an instructional guide about Graph Linear Equations presented in algebraic form. It is an easy to follow, step by step guide to solving such equations using the graph intercept formula. The first example equation is Y = 2x -1 over y = mx + b. The video then shows you how to breakdown the equation into manageable sums using fractions to represent the data, and then presents the formula for interpreting the answer from these sums onto the graph co-ordinates. The second and third e...

How To: Factor polynomials by grouping

A factoring problem that has to be solved by grouping is easy to identify, because you can always identify if there are any similar terms in a polynomial. Now, if you find any variable common in any terms pull them out as the common leaving the rest of the terms. After pulling out the common terms you can group the rest of the polynomial. Be careful while pulling out signs. Pulling out a positive number does not effect the signs of terms in the polynomial, where as pulling out a negative numb...

How To: Understand parabolas

The instructor in this video uses humor to teach people math, which is not a favorite subject for many. The video goes on to teach the students in the video different ways to cut the conic sections into different shapes. The teacher then focuses on parabolas and defines the formulas. The formula is y = x^2. The rest of the video dissects the equation breaking it down into much more meaningful statements so that the average human being who is not very good at math can understand the equation. ...

How To: Maintain and troubleshoot your home garbage disposal

In this video tutorial from RenaissanceRentals you will learn how to maintain and troubleshoot your home garbage disposal. First thing to do is to keep the water running during garbage disposal. Ensure that the leftovers are cut into small pieces and you put only small quantities for disposal at a time. Things like plastics, glass pieces, rocks and food items like egg shells, starchy foods like pasta or rice should not be put into the garbage disposal system. If you follow these simple tips, ...

How To: Use probability of dependent events

In this video you will learn how to use probability of dependent events. The video starts with a small advertisement to there website http://www.yourteacher.com. Then its followed up by a math instructor taking you through a example problem to help you understand how you can begin solving problems of your own. The problem used in the example is: Andrea has 4 red socks and 8 blue socks in her drawer, she chooses one sock at random and puts it on, she then chooses another sock without looking, ...

How To: Factor a trinomial

In this video the instructor shows how to factor a general quadratic polynomial. Here the first step is to identify the coefficient of the squared term. Write the reciprocal of the numerical coefficient of the squared term out side and write two separate parenthesis which are going to contain the binomials which are the factors of the original equation. The first term of both the binomials is the first term numerical coefficient times the unknown variable. Now multiply the first term numerica...

How To: Stretch, shift & reflect the graph of a square root

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 function using small values first, then you have y=square root of x - 1, the domain 0<=x. This shifted the graph down 1 unit. 0=square root of x - 1, 1=square root of x, 1=x. Then the range is [-1 + infinity). Continue in ...

How To: Solve operations on rational functions (f o g)(x)

YAYMATH In order to use rational functions in intermediate algebra, Robert Ahdoot begins by setting values to the functions f(x) and g(x). He then adds these functions together, with the equation (f+g)(x). After addition comes subtraction, using the equation (f-g)(x). And finally multiplication, which is (ftimesg)(x). This is a little more complicated, requiring distribution of a binomial across a polynomial, but it's clearly demonstrated and explained. This video explains what to do with add...

How To: Graph compounds sentences with the word "or" in hem

A Teacher shows us how to graph compound sentences with the word "or" in them. These graphs will have arrows pointing out in different directions. On the number line draw arrows from the numbers in your compound sentence. So for example if after solving a problem with inequalities the problem has two possible answers that it could be, you would record both of the answers that it could possibly be. For our example we will use x is greater than seven, and x is less than three. You would then dr...

How To: Find the percent change using proportions

In this video, the instructor shows how to identify the percentage change using proportions. When a given quantity increases or decreases by certain amount then we can calculate the percentage change in the quantity, which can be either increase or decrease based on the new value of the quantity. To solve these kind of situations you should know that the ratio of amount of increase (or decrease) of an amount to its original amount is equal to the ratio of percentage increase (or decrease) to ...

How To: Find the point slope form of a line equation

This is a mathematical instructional video on finding the point slope form of a line equation. This technique allows you to find the x and y intercepts of a line. The point slope form is (y-y1)=m(x-x1). The instructor tells you what each of the variables represents, and shows an example. He then shows you how to find the slope-intercept form from the point slope form. Finally, he shows you how to graph the line using both of the equations. He shows you how to find the equations with different...

How To: Factor a trinomial with negative leading coefficient

In this video the instructor shows how to factor a trinomial with negative leading coefficient. Most of the students are confused when they have to factor a trinomial with a negative leading coefficient. But there are many ways to solve these kind of problems as shown in this video. One way you can do is that take out the greatest common factor (GCF) of -1 from the equation. So pulling the -1 gives you the original trinomial with all the signs of the terms changed. Now go on and factor the ne...

How To: Deal with a guy who won't introduce you to his parents

In this video, Dan and Jennifer answer a 71 year old woman's question about her relationship. The asker has been staying with an 80 year old man that she met online, for three years. Throughout the duration of the relationship, the man has not told his family (which comprises of his two children) about the relationship. The woman is unsure about what exactly this means. In addition, the man has been over to the woman's house multiple times, but she has never been to his house. Dan and Jennife...

How To: Square expressions involving radicals

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 itself so the square of 5 root y would be 5 root y into 5 root y. So 5 x 5 is 25 and under root y into under root y equals just y so the answer will be 25y.

How To: Find the equation of a line

In this video the instructor shows how to find the equation of the line given its slope and a point that lies on it. If the slope of the line is m and the point that lies on it is (x,y) then you can find the equation of the line by substituting the values in the slope-intercept form of an equation which is y = mx + b. Now substitute the values in the above equation and solve it for the value if the y-intercept y. Now you have the slope m and y intercept b. Substitute these values in the gener...

How To: Solve an equation using the point slope form

In this video the instructor shows how to derive a general equation for a line in Point-Slope form. The slope of an equation is the ratio of difference of y coordinates to the difference of x coordinates. In other words, slope is the change of y up on change of x. So you have the basic slope equation m = (y2 - y1)/(x2 - x1). When you have fractions you can simplify them by multiplying the denominator to the numerator on both sides. So multiply the equation by (x2-x1) on both sides. This gives...

How To: Solve problems about linear equation

In this video the instructor shows how to write a linear equation. If you need to find the equation of a line that passes through the two given points then you need to find the linear equation of that line. The first step is to find the slope of the line that passes through these points. The slope can be calculated by finding the ratio of the difference of y coordinates to the difference of the x coordinates i.e. the change in y up on the change in x. Now substitute the value of slope and any...

How To: Solve direct & inverse variation word problems

In this video the instructor teaches about direct and inverse variation. Two variables x and y are said to be in direct variation with each other if you can write them in the form y = K * x. The value of y varies directly corresponding to the value of x. Y is said to be directly proportional to x. If you have a sample value of x and y, you can substitute the values in the above equation to compute the value of the constant K. Using this formula you can always find the value of one variable x ...

How To: Understand the basics of matrices

In this video you learn how to understand the basics of matrices. The video includes how to do matrices with addition, subtraction and multiplication. The teacher explains in this exercise that you will need to know the number of rows and columns. He breaks down all of the steps required to solve these problems. Not only does he show how to understand the basics of matrices, but he does it dressed up like a king and with a little reggae music. You can hear the class's reactions to his jokes i...

How To: Calculate a limit by getting a common denominator

This video explores how to get the limit by getting a common denominator. When you try and plug in a limit, for example when the denominator goes to zero, you can get yourself into a situation where you get the answer (0/0) which is mathematically irrelevant. To solve this problem, you must find a common denominator and split the problem up into its various parts. By setting common denominators in the numerator, you can then flip the fraction around allowing you to properly calculate the limi...

How To: Multiply rational expressions

The video describes the basic process of multiplying two rational expressions. The problem illustrated in this video involved multiplying rational expressions of monomial terms with integer coefficients. As with the other example problems, we follow the steps of: factoring, canceling, and multiplying. Because these terms are monomials, no factoring is required (but we still state it as a step for similarity to solving other problems). We then find the greatest common divisor for both terms to...

How To: Do the "PLL" Rubik's Cube solution technique

This is a demonstration on how to use the PLL method to solve a Rubik's cube. The author informs that what people do before and after applying the PLL technique is very important. According to him, people usually tend to first align as many faces as they can, when they see a partial algorithm and then apply the PLL method, which is very time consuming. Instead, one should stop one step short of alignment, apply the Pll method and then align the faces completely. The author, however, points ou...

How To: Factor a trinomial by GCF then grouping

In this tutorial the instructor shows how to factor a trinomial with Greatest Common Factor (GCF) and then how to group it. The first thing you have to do when you want to factor a trinomial is look for the GCF. First factor the numerical coefficients of the terms of the equation. Now separate out the common numerical factor and if any common variable. This leaves you with a binomial to be factored. Now to solve this multiply the numerical coefficients of the first term and the last term and ...