Wedbush Calculated Search Results

How To: Make payment calculations with MS Excel's PMT function

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 47th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the PMT function to calculate payments. Specifically, this video addresses the following topics:

How To: Work with probabilities in Microsoft Office 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 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:

How To: Find the surface area of a basic cylinder

First of all cut of the top and the bottom of the cylinder to get two circles. Now take a scissors and cut of the cylinder into two halves from the top to the bottom as shown. Now you get a rectangle shape. You can easily measure the length of the cylinder but to measure the base is a problem. So mark a point on the table with tape and also make a mark on the can or the object you want to measure. Now place the two points over each other. Now use a ruler as a guide and move the can so that th...

How To: Do a similarity transformation in Geometry

In this video the author shows how to do similarity transformations. He says that similarity transformations are used to draw the similar images at a different location and the k value is most important while doing this kind of transformation. He says that a negative k value tells that the copy of the shape will end at the opposite side of the origin to the original shape. He says that a positive k value tells that the copy will lie on the same side of the origin. Next thing about the k value...

How To: Knit a Mobius Dog Scarf

If you save scraps of yarn, and have a dog, this is an easy project for you. The Mobius scarf has the advantage of not having any ends to come untied, or dangle down for your dog to trip over, or get tangled in branches and stuff. I made this one for Pepper, my 16lb rat terrier. Step 1: Choose Your Yarn: I had very little yarn to work with. I had one more ball, but it had just a little more on it than the largest shown here.

How To: Approximate the area under a curve using rectangles

The idea of finding the area under a curve is an important fundamental concept in calculus. Consider a function y = f(x). Now the area under the curve is to be calculated. The area under a curve problem is stated as 'Let f(x) be non negative on [a, b]. Find the area of the region lying beneath the curve y = f(x) and above the x-axes, from x = a to x = b. Note that finding the area under a curve will imply that you are dealing with a non negative function. The way to approach is to divide the ...

How To: Calculate weighted atomic mass

This video is about Level 2 atomic concepts, specifically the Pennium Lab. This helps you understand how atomic masses are derived for the periodic table. This teacher demonstrates how to do the calculation. He first reviews the Isotopes as they are different masses of the same type of atoms. He uses chromium as his example. It has a different number of neutrons in the nucleus. Using the equation, it could have either 26, 28, 29 or 30, with its 24 protons. So he subtracts the atomic number fr...

How To: Calculate and understand the concept of molar mass

Two college students; Kevin Martin and Joey Smokey introduce the concept of Molar Mass. They start of by explaining what molar mass is, which is the relationship of a mole and a gram, it totals up the weight(in g)of a molecule. An example: say you have this compound, Sodium phosphate (Na3PO4). You know you have three sodium atoms, one phosphorus atom, and four oxygen atoms. You basically find the weight of each atom, if you have three sodium atoms, you multiply it's atomic mass by 3 (the numb...

How To: Solve a linear system by graphing in math

This video teaches you how to solve a linear system by mathematically graphing it out. The video starts off with a problem, asking to solve the system, with two given equations. To solve the system, one would insert 0 for x and solve for y in the first equation to obtain a point. Then one would insert 0 for y and solve for x at the second point. Afterwards, insert 1 for x and solve for y to obtain the third point. For the second equation, do the same thing, inserting 0 for x, 0 for y and 1 fo...

How To: Calculate variance and standard deviation using Excel

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 put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...

How To: Use Excel round function & number formatting

In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...

How To: Find the equation of a line easily

This is the video about how to Find the equation of a line. The equation of a line with a defined slope m can also be written as follows: y = mx + b where m is the slope of the line and b is the y intercept of the graph of the line. The above form is called the slope intercept form of a line. Step1 Set m to a fixed value (m = 1) and change b (b = 1, 2, 3, 4, -1, -2, -3, -4). Compare each value of b to the y-intercept of the line obtained. Step2 Set b to a fixed value (b = 1) and change m (m =...

How To: Calculate a handicap in golf

This video presentation details the process of calculating a handicap in golf, in this presentation the handicap will be calculated on the USGA handicap system which is the official handicap system to be used in the United States. On each score card, there is a designation for the handicap and slope, these numbers do not vary frequently between sixty-eight and seventy-four, and one-fifteen, and one-thirty, respectively. The 'Slope' is a new calibration that is used to help make a handicap fai...

How To: Find standard deviation

In this video tutorial, viewers learn how to calculate the standard deviation of a data set. The standard deviation of a statistical population, a data set, or a probability distribution is the square root of its variance. To calculate the standard deviation, users will need to follow these steps. 1) Find the mean of the data. 2) Subtract the mean from each data point. 3) Square each of the values you got in step 2. 4) Then find the mean of the values you get from step 3. 5) Finally, square r...

How To: Solve an algebraic equation

Math can be tricky, especially when you're trying to decipher algebra. It's a love-hate thing; if you don't love math, then you hate it, and there's no in-between. But it doesn't have to be a pain to solve a few problems. It's actually quite simple once you figure it out. An algebraic equation is an equation that includes one or more variables. These equations can be solved as long as the number of variables does not exceed the number of equations.

How To: Find the area of a parallelogram using geometry

The video shows us how to find the area of parallelogram using geometry. Here in this video it is done by using an example where the parallelogram is given ABCD. The area of the parallelogram is base times height (bh). Here the base is given as 15 but the height is not known but it is represented by the segment BD. To find the value of h, let’s use right triangle BDC on the right side of the figure. Since base is 15 and the opposite side of the parallelogram is congruent, the hypotenuse of th...

How To: Give Your Android Phone Some “Material Design” with Google's New Calculator App

With Google's latest version of their mobile OS, Android L, the most notable aesthetic difference is the newly introduced Material Design concept that will soon be ever-present through the interface. The objective of this bold design is to create "hierarchy, meaning, and focus," as described by Google, and the deliberate choices of color and white space "to create immersion and clarity."