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 91st installment in his "Excel Statistics" series of free video lessons, you'll learn how to use TINV and TDIST functions to find critical values given an unknown sigma value.
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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories of values.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
This video tells you how to identify the coordinates of an ordered pair from a given point. An ordered pair is denoted by (x, y). Normally a graph has two axis, the x and the y axis. Consider a point on the graph. It will surely be the intersection of two values and one value will be from the x axis and the other valve from the y axis. Find the two corresponding values of the given intersection point. The value on the x axis will be x and the value from the y axis will be y. Now you have got ...
In this video the author shows how to graph using an X-Y table. He shows how to do this with a sample equation. He builds a table of x, y values where he takes sample values for x like -1, 0, 1 and now he substitutes these values in the equation of the line and obtains the corresponding y values. Now finally he has an x, y value table which now he shows how to plot it on a coordinate plane. He plots all the three pairs on the graph and connects them with a line finally obtaining the resultant...
In this video tutorial, viewers learn how to hack the flash game, Palisade Guardian 2: Modern Combat with Cheat Engine. Begin the game by entering your name and play the first level. After that, open up Cheat Engine and select your internet in the process list. Change the Value Type to Double and Truncated to Rounded (default). Enter in the value of your cash and press First Scan. Then buy something to lower your cash and enter in your new value. There should be only 1 address. Check the froz...
Welcome back, my hacker novitiates! Many of you have probably heard of a man-in-the-middle attack and wondered how difficult an attack like that would be. For those of you who've never heard of one, it's simply where we, the hacker, place ourselves between the victim and the server and send and receive all the communication between the two.
In this tutorial, we learn how to write a values statement. First, you will need to think of five to seven values that are important. Make sure these are more than one word and are shared ideas by everyone. There shouldn't be more than seven values, so everyone can remember them. The point is that everyone has values, find something that everyone has in common and guides your behavior as an organization. It may be in your mission statement, but don't worry about it, think of separate statemen...
In this video tutorial, viewers learn how to hack the flash game, Age Of War 2. Users will need to download the Cheat Engine program for this process. Begin by starting the game. The game should start with 2500 gold. Then pause the game and open Cheat Engine. Click on the Process computer icon and select the current web browser. Now type "@500" into the Value box and click First Scan. Then deduct your amount of gold, type in the new value and click on Next Scan. There should only be 1 result ...
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...
In this Computers & Programming video tutorial you will learn how to update a website with an FTP client (v† la FileZilla). Download FileZilla client from www.filezilla-project.org. Find your server IP address from your web host, which will be found in the hosting control center. In the video, it is GoDaddy.com. Open your filezilla client and put in the IP address of your web host and your username and password for your hosting account. Then click ‚Äòquickconnect‚Äô. This will connect you to ...
This video tutorial from Michael Espinosa shows how to install and use File Zilla Ftp client on Windows XP operating system.
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 267th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate percentage change using a simple universal formula: (End Value)/Beg Value)/Beg Value = Percentage Change.
A percent problem is one in which you are given a quantity and asked to compute the value of a percent of it. You may also be given the whole quantity and a part of it and asked to compute the percentage of the part in the whole. To do these kind of problems you need to use the rule which states that the ratio of the part to the base it equal to the ratio of the percent to hundred. That is part/base = percent/100. This comes from the definition of percentage which states that percentage is eq...
In this video the instructor shows how to find a formula describing direct variation between two variables. Variation between two variables can be either direct variation or indirect variation. If a variable y is in direct variation with a variable x we can write the general equation between them as y = k * x. That is as x varies, y varies directly in relation to x, as a multiple of x. Now if you have the values of y and x, you can substitute them in this general equation which gives you the ...
In this video the instructor shows how to solve a 3 x 3 linear system using the Cramer's rule. In this kind of problem you are given three equations in three variables x, y, z and you need to solve for the values of these equations. You can solve this using the Cramer rule which says that the value of x is Dx/D, where Dx and D are two different determinate. Now you have to figure out the determinate to get the value of variable x. The determinate D is called the foundation determinate and is ...
The video shows us how to solve a system of equations with the elimination method. First write the two equations one on top of the other, as it is going to be elimination method and it is recommended to write it in that way. Here the 2 equations are x+y=-3 and x-y=1. In the elimination method we need to add the 2 equations by columns. So adding it column wise we get to have 2x=-2 and solving this we will get the value of x=-1. Then you need to substitute this value of x in any of the two equa...
This video shows how to hack My Pet Protector 2. You can hack health by taking the amount you have and multiply it with 8. When you lose some health you will need to repeat it. Then drop it down and freeze it and change the value to 80000. Come to the cheat engine then put the value on the box for hex value. Then hit enter and you will get one result. If you didn't get any result, repeat the process by entering another value which is multiplied with 8. Once you got it double click on the link...
In this video tutorial the instructor shows how to find the slope of a line given two points with fractional values. To do this first name your two points as point 1 with coordinates as x1, y1 and point 2 with coordinates x2, y2. Then substitute the values in the equation of the slope which is slope m = (y2 - y1) / (x2 - x1). Now all you have to do is simply the fraction after substituting the point values. Be careful about the signs while substituting in the formula. Now finally after solvin...
The distributive property is a very important factor to consider in math and may save you a lot of trouble on your math homework. For values which lie right outside parentheses, you will need to distribute this value across the contents of whatever is inside the parentheses. You will need to multiply the value outside of the parentheses by first the first term inside the parentheses and then by the following terms inside the parentheses, distributing the value across all the terms found insid...
In this video the tutor shows how to solve the missing ratios or proportions. He explains it with an example, where a number in one of the ratios is missing and he intends to find this value. He shows the example of cross multiplication, where you multiply the values on the either side of the equation diagonally and finally solves the equation which results in the value of the unknown value. This is an introductory video explaining how to use rations and proportions to find missing values.
In this tutorial the instructor shows how to solve linear and quadratic equations. It is a liner quadratic system where he shows a parabola and a straight line and he intends to solve the points where the line intersects the parabola. Now he uses comparison to compare the values of y in both the equation resulting in a equation in x. Now he shows the factors of the obtained polynomial equation and there by finding the values of x coordinates. Now he substitutes these values of x in the origin...
When you have to find the average of two or five numbers then you have to add all the numbers and then divide then by two or five respectively. However in the case of the function you have infinite many values over any interval. But it is not possible to add all and then divide by infinity. Therefore you have to calculate in a different way. Imagine that you have to find the average of y=f(x). Then you have to average it from the interval from ‘a’ to ‘b’. The inner area under the curve shall ...
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
In this tutorial the instructor shows how to graph a parabola and also how to find its roots which are also known as zeroes. He gives the quadratic formula of how to find x-intercepts of a parabola. He takes an example and substitutes the values and finds out the values of the roots of the parabola. Now he substitutes these values in the equation to obtain the corresponding y coordinates. Now using these pairs of values he plots the parabola on a graph and draws it. This video shows how to fi...
In this tutorial the instructor shows how to convert a improper fraction to mixed number. In the example the instructor takes the denominator of the mixed fraction and writes it beside and keeps adding it self to the latest number and he keeps on doing that way generating a series until he reaches the value of the numerator. Now he counts the number of occurrences of the numbers in the series before the value of the numerator which gives the value of the whole number in the mixed fraction. No...
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...
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 about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
1. The following lines describes how to create animated glowing text on Flash. 2. Open a new Flash Project and select first Key Frame and place a Text Box and Type "HELLO" 3.Select TextColor as red. 4. Then Go to Filters->Glow a. select color as Dark Yellow b. increase the Blur x,y Property value to 5 c. strength value to 200 d. Quality: Low 5. Select 15th Frame and Right click->Select Insert KeyFrame. 6. Then increase the Blur x,y Property value to 50 and strength value to 300. 7. Then selec...
In this tutorial, we learn how to give a Swedish massage. First, you want to start off by making sure your client is comfortable. Next, you will start to gently rub the body, starting circulation. After this, put cream on your hands and rub them together so it gets warm. Now, rub the client's body with the cream, pushing in the body in the middle of the back. Use smooth strokes, because these will warm the client up. Now, use your elbows and place them along the spine, pushing your body weigh...
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...
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
This video teaches us the method to find the circumference of a circle given its radius. The video tells us to find the answer in terms of pi and also to the decimals value. The formula to find the circumference is two times the product of pi and the radius. The first step involves the drawing the circle and marking the radius. The radius of the circle in the video is 6.5 cm. Now use the formula to find the circumference. Substitute the value of the radius in the formula of circumference. We ...
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 points for the equation. Finally plot these points and sketch this graph which is in the form of a parabola. The curve is in the form of alphabet 'U' with its vertex at the bottom. Now similarly take the square root of x e...
In this video the instructor shows how to do temperature conversions using y = m*x + b. Now if Celsius is represented by the variable C and Fahrenheit is represented by the symbol F, you can replace then in the previous equation in place of the variables x and y giving you the equation C = m*F + b. Now to solve for the values of the constants m and b you need to have values of two sample temperatures in both Celsius and Fahrenheit. Take the first sample and substitute in the above equation gi...
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 simplify the equation and get it in the form of (x*x)/(a*a) + (y*y)/(b*b) = 1 which is the general form of an ellipse. Now you will have the x and y intercepts which are a and b respectively. Using this values graph the eq...
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...
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...
