Audio Formula Search Results

How To: Find the volume of a sphere

In this video the author show how to find the volume of a sphere. The formula for finding the volume of a sphere is 4/3 * Pi * r*r*r, where r is the radius of the sphere. Now to compute the volume of a sphere you have to note down the radius of the sphere and substitute it in the above formula along with the other substitutions. The author shows this with an example by taking a sphere of some radius and calculating its volume. To find out how to calculate the volume of a sphere watch this vid...

How To: Find the circumference of a circle in Geometry

In this tutorial the author shows how to find the circumference of a circle. He says that the circumference of a circle can be calculated by using the formula circumference C = 2 * Pi * R, where R is the radius of the circle. He shows how to solve these kind of problems using some examples and calculating the circumference by substituting the value of radius in the formula. This video gives a good introduction on how to find the circumference of a circle.

How To: Use YEARFRAC, INT, and DATEDIF in Excel

In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...

How To: Calculate the area of irregular shapes

In this tutorial the instructor shows how to compute the area of irregular shapes. He demonstrates this with an example showing an irregular area and says that as there is no direct formula to calculate it, you need to break up the irregular area into identifiable simple geometric figures. He goes on and breaks the irregular shape into a square, a triangle and a trapezoid. Now he computes the individual areas using a standard formula and sums them up to arrive at the final complete area of th...

How To: Use the Arbitrage Pricing Theory (APT)

This video teaches you how to use APT (Arbitrage Pricing Theory) models and formulas. This video shows two specific parts of the APT models the first being the after the fact version and the before the fact version. The before the fact version is focused on as being the most important which is used to calculate expected returns to calculate risk. It is discussed how flexible this model is and how different factors can be moved in and out of the formula and how each different factor is used. T...

How To: Lose weight fast using Jedi mind tricks (and without lifting a finger)

Everyone could benefit from shedding a few pounds, but what about those who need to lose a little bit more weight? Exercise isn't an option for everyone, with as busy as our lives are right now. It's hard to go running and do a few pushups when you have a hard enough time scheduling your day already. But if you're looking to shed a couple pounds here and there— without lifting a finger— this two-part video will help you out with some Jedi mind tricks!

How To: Graph an equation in point-slope form

This video tells you how to draft an equation in point-slope form. Consider the equation (y+4) = 2(x+7) for example. The formula for the point-slope form is (y-y1) = m(x-x1). To plot the graph you have to identify m the slope, the x intercept x1 and the y intercept y1. In this equation the slope is 2 and (x1,y1). The x intercept according to the formula is -x1 but the given value is +7 so you have to figure out what will give you +7,only -(-7) can give you +7 so the point is -7 and now the y ...

How To: Find molar mass

It’s time for science. You are able to calculate the molar mass for a compound using the periodic table and the amount of compound involved. You might need to know this in your everyday life but you will definitely need this in a chemistry class.

How To: Use a formula to find the area of a parallelogram

This video shows us how to use a formula to find the area of a parallelogram. The formula for finding the area of parallelogram is the same as finding the area of rectangle or a square which is equal to length time’s breadth. But the parallelogram looks a bit different and the parallelogram is basically a rectangle but it is not at right angles. If you draw two altitudes then it is a rectangle with two triangles and if you cut one of the triangles and paste it next to another triangle then we...

How To: Calculate interest rates for payday loans in MS Excel

The video demonstrates the way of calculating the interest rates for payday loans using MS Excel. The person presenting the video has got his MS Excel sheet with all the formulas and data ready. He first starts with the nominal & effect & future value tab. He gives us an example where you give the lenders a check of $250 that has a date 25 days in future and get $200 loan today. Now he teaches us hot to calculate APR and EAR. HE has got the data ready there, the period of the loan which is 25...

How To: Find the smallest number greater than zero 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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.

How To: Increment a number pattern by formula 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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.

How To: Work with math equations in Microsoft Excel 2010

Learn how to store, use and manipulate equations in MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started using mathematical equations and formulas in your own 2010 worksheets, watch this free video guide.

How To: Count times exceeding 5 minutes 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 and Mr. Excel, the 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.

How To: Create projections for sales numbers 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.

How To: Create confidence intervals for proportions in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.

How To: Group categories in an Excel frequency distribution

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping fea...

How To: Automatically highlight negative numbers 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 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!

How To: Increment column numbers for an Excel lookup 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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).

How To: Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Invert a range of values 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

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: Find a data point (Xi) with the Z-Score formula

In this free video math tutorial, we learn how to use the Z-Score formula to find a data point (Xi) in statistics. With mathematics, as with anything else, not everyone progresses at the same rate. Stats is no exception. 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 in the world to catch up. Whether you need help finishing your homework or studying...