Decrease Function Search Results

How To: Use functioning & static dominant chords in jazz guitar

In this video, we learn how to play Jazz guitar: Functioning & Static Dominant Chords. When you play an A7 going to a D chord, you are playing a functioning dominant, because a five chord always wants to go to a one chord. This is because of the tension in the five chord and how it resolves to the one chord. You will hear that the chord wants to go to a different chord, so make sure you understand this concept as you are playing. If the chord does go to the other, it's referred to as a functi...

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Ignore nested subtotals with AGGREGATE in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Use the AGGREGATE function in Microsoft Excel 2010

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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Apply quadratic functions in 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 than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to apply quadratic functions in algebra.

How To: Graph and solve quadratic functions in 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 than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find answers to quadratic function problems in intermediate algebra by graphing.

How To: Find the inverse of a function in algebra

Need a little help figuring out how to find the inverse of a function in algebra? 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 to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this free math tutorial, you'll learn how to calculate the inverse of a given algebraic fun...

How To: Solve problems involving functions in algebra

Need to know how to solve function problems in 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 than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with and solve functions.

How To: Perform a general neurological exam on a patient

As a doctor, sometimes it will be necessary to perform a neurological examination of your patient to rule out any neurological disorders. Your objective is to identify abnormalities in the nervous system, to differentiate peripheral from central nervous system lesions, and to establish internal consistency. This is a great video less that outlines the complete neurological exam procedure. It's great for medical students or doctors, and even nursing students can learn a thing or two.

How To: Use Excel's SUMIF, RANK & IF functions

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Work with exponential growth functions in mathematics

Exponential functions are functions which contains terms which are integers raised to the power of variables. Note that the variables are not raised to the power of integers, but the integers are raised to the power of variables. Variables raised to the power of integers are called as polynomials and are a different class of functions. But exponential functions grow very fast than polynomials with the increase in the value of the variable. To understand the growth of these functions take a si...

How To: Sketch the graph of a piecewise function

This video teaches us to draw the graph of a piecewise function. This is shown using two examples. In the first example we have 'y' equal to 'x + 2' for x less than zero and '1 - x' for x greater than equal to zero. We plot two points on the function for x less than zero and do the same for the function with x greater than equal to zero. The graph for the first function is erased for x greater than equal to zero, and the same is done for the second function for x less than zero. Note that the...

How To: Graph the absolute value of a function

This video shows the method to plot the graph of the absolute value of a function. The video shows the example of the function of cube root of 'x'. The demonstrator first plots the graph of a cube root function. This is done by taking the reference point of positive one and positive eight. The graph is drawn for both negative and positive values of 'x'. After this the graph of absolute function is drawn by taking the absolute value of the cube root function. The resultant graph comes out to b...

How To: Graph the greatest Integer or floor function

The video shows the explanation of greatest integer function. This video explains this with the help of graphs. The video first describes the basic greatest integer function. This means the greatest integer less than or equal to the number gave. The graph of this function is drawn. The video then shows the variations of this function. The first variation shows the function that replaces the 'x' coordinate with it subtracted by three. This shifts the graph to the right by three units. The seco...

How To: Solve mathematical functions and graphs

Check out this instructional math video that demonstrates how to calculate mathematical functions and graphs. In this 9th lesson, learn how to solve on SAT Algebra problems using the Official SAT Study Guide (as always). Here are the math problems and their page numbers that this video covers:

How To: Find the sides of a right triangle with trig functions

Learn how to use trigonometric functions to calculate the sides of a right triangle. 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 finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to ...

How To: Build and use array formulas in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Build frequency tables & histogram charts in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:

How To: Use differential equations to represent growth

This video shows the method to use differential equations to represent growth. Consider the function y=multiple of C & e raised to kx or Ce^(kx). Differentiating it with respect to x, we get dy/dx=kCe^(kx) or ky. So, the solution of the differential equation dy/dx=ky is Ce^(kx). There are two possibilities in the function y=e^(kx). It can be exponentially growth or decay function. This depends on the value of k. If k is greater than 0 or k>0, we get an exponential growth function. On the othe...

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Create a chart for a linear function of X in MS 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 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.

How to Train Your Python: Part 10, Making Our Own Functions

Welcome back! In the last iteration of how to train your python, we covered error detection and handling. Today we'll be diverging from this and discussing functions. More specifically, we'll be creating our own functions. First we'll need to understand exactly what a function is, then we'll get on to making our own! So, let's get started!

How To: Determine if you have a function

In this tutorial, we learn how to determine if you have a function. You will start off with two functions and their points. The 'x' values make up the domain of the function and the 'y' values make up the range. The input values are the domain and the output are the range. If you're checking to see if you have a function, you will need one 'y' for every 'x'. This means that each value has another one that goes with it. Each of the points need to have one partner with them, no more and no less...

How To: Do normal probability calculations on a calculator

Probability computation is a complex process and even using a calculator can be difficult. But normal probability calculations can be performed quickly with the help of calculator once you know how to use it. So when you have to calculate a probability from a normal distribution you can use the functions on your scientific calculator. You can use the normal CDF function from you calculator to compute the area under a normal curve. The function requires lower band and upper band values, the me...

How To: Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...

How To: Graph a quadratic function in factored form

This video deals with solving quadratic functions. It does not involve the use of the quadratic equation; rather, only factored equations are used. The speaker starts out with a factored quadratic equation. The speaker goes on to do the mathematical steps necessary to find both the x and y intercepts of the quadratic function at hand. The author then continues on with the example to find the function's minimum. Next all of the points that have been solved for are plotted and the function is s...

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...