Standard Function Search Results

How To: Activate Microsoft Office standard 2007 with key

Chances are if you've used a computer in the last decade or so, you've probably used Microsoft Office at some point. Activating Microsoft Office standard 2007 will give you access to functions you might not have even known existed that can increase your productivity and improve your work flow. This video will show you to activate Microsoft Office standard 2007.

How To: Set up your AppleTV with a standard definition TV

You don't need a high definition television to take advantage of AppleTV! This tutorial shows you how to set up your Apple TV to function with a standard definition television set. You'll need an HDMI to DVI cable anda VGA to DVI adapter, and use the yellow composite video cords. Then adjust your settings, and you're ready to start watching your new Apple TV!

How To: Use AGGREGATE instead of SUBTOTAL in MS 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 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...

How To: Write the equation of a circle in standard form

Here you'll be shown how to take the equation of a circle, and convert it into standard form. Also, it will be explained just what standard form is, while running through the process of conversion. You'll be able to use techniques to quickly work off the numbers on the equation, one by one, until it's simplified enough to understand. Complicated algebra functions become much simpler when you see these easy to use techniques, that will help you rearrange the equation into a form that is actual...

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: Extract records from a table to a column 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.

How To: Find deviations and variance for a population 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 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...

How To: Analyze a stock portfolio with Excel array functions

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 create array formulas for stock portfolio return & standard deviation.

How To: Construct confidence intervals with TINV in MS 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 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.

How To: Use the STDDEV IF function 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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the standard deviation when you have more than 1 criterion.

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: Celebrate the 8 days of Hanukkah with the standard Jewish traditions

If you don't know exactly what goes on during Hanukkah, this series of videos will set you straight. Hanukkah is the most recognized Jewish holiday, right around Christmastime, and Chaim from Maoz Israel is going to show you some traditional customs that are performed during the eight days of Hanukkah 2010. Learn about the menorah, sufgaiyots, the mysterious dreidel and the traditional Chanukah songs.

How To: Use the Empirical Rule w/ standard normal distribution

In this video tutorial the instructor explains about the concepts of standard normal distribution and the empirical rule and how to use it to solve an exercise. He starts by explaining about standard normal deviation saying that in a standard normal deviation the value of mean is zero and the value of standard deviation is one. Now he draws the standard normal deviation by drawing a bell curve on an axis. Now he points the mean and standard deviations on it. Now using these concepts he goes o...

How To: Create global illumination in a MAXON Cinema 4D scene

This tutorial will explain some of the ways you can implement global illumination in your scene, using luminous materials and HDRIs. It also presents a look at how to set up realistic reflections in your materials, using the standard reflection channel with a fresnel mixed in. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. F...

How To: Do basic statistical analysis 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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:

How To: Calculate sums in standard form

When a number is expressed in the form of x multiplied by 10^y such that, x < 10 and y is an integer, the number is said to be in standard form. Standard form of expressing numbers finds its use in scientific and statistical fields. This video demostrates how to express, as well as perform basic mathematical operations namely, addition/subtraction, multiplication and division of numbers in the standard form using four examples/mathematical problems. The first two examples demostrate multiplic...

How To: Know standard deviation in your financial portfoli

In this tutorial, we learn how to know what standard deviation is in your portfolio. Standard deviation is the amount of risk you have inside your portfolio, this will show you how much fluctuation you have in your portfolio. Depending on the expected return of your portfolio over an amount of time, you could have a different range of standard deviation. Knowing what your standard deviation can help you do the math to see what your chances of a return or loss will be for certain. This will he...

How To: Work with context and subcontext buttons in Blender

This clip covers the confusing array of buttons and controls in Blender that are used for the different functions. Specifically, it talks about context and sub-context buttons, presets for TV broadcast (and the different standards for those) in HD or high-definition broadcast. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free vid...

How To: Find confidence intervals without the sigma 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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Calculate standard deviation

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other.

How To: Perform the Slow Flight maneuver

In this AeroCast episode, UND Aerospace discusses the Slow Flight maneuver as performed in the Piper Warrior (PA-28-161), referencing the procedures and standards outlined in the UND Warrior Standardization Manual. All performance tolerances are based on the performance standards set forth by the FAA Private Pilot Practical Test Standards. Since the most critical phases of flight occur at airspeeds less than cruise, a pilot must always be comfortable with his or her airplane’s handling charac...

How To: Perform Power On Stall maneuvers

In this AeroCast episode, Anthony Bottini discusses the Power On Stall maneuver as performed in the Piper Warrior (PA-28-161), referencing the procedures and standards outlined in the UND Aerospace Warrior Standardization Manual. All performance tolerances are based on the performance standards set forth by the FAA Private Pilot Practical Test Standards. Power On Stall practice is vital in increasing a pilot’s proficiency in regards to stall recognition and stall recovery techniques during an...

How To: Convert numbers in and out of standard form

In this video, we learn how to convert numbers in and out of standard form. Standard form is a useful way of writing down very large numbers and very small numbers. To do this, you will look at the number you have and ignore the zeros that are just at the end. Then, write down the basic numbers. Put a decimal point in this number to make it between one and ten. Now, write down x 10 and put the power for how many places the decimal point moved to get to the new number. This will help you write...

How To: Build confidence intervals given the sigma in MS 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Compare 2 distributions with the Z-Score formula

This is a video tutorial in the Education category where you are going to learn how to compare 2 distributions with the Z-Score formula. In this example Doug's class has X bar as 71 and a standard deviation of 4. Corey's class has X bar as 68 and a standard deviation of 11. If both Doug and Corey beat the class average and have the same standard score, will Doug have a lower grade than Corey? If both of them have a standard score of 1.5, then Doug will get 77 marks and Corey will get 84.5 mar...

How To: Create a new standard user & admin in Windows 7

In this video tutorial, viewers learn how to create a new standard user and administrator account. Begin by clicking on the Start menu and select Control Panel. Then click on User Accounts and Family Safety and click on User Accounts. Now select the "Manage another account" option and click on "Create a new account". Users are able to name the account and select the account type (Standard or Administrator). Finish by clicking on Create Account. Users are then able to make changes to the accou...

How To: Graph x & y intercepts on a TI-84 Plus calculator

In this video the teacher shows us how to use a TI-84 plus graphing calculator to graph a function, adjust the view window, and determine the values of several types of critical points on the graph such as x-intercept, y-intercept, local maximums, and local minimums. After entering the function in the Y= editor she presses the ZOOM button and selects Z-Standard this adjusts the view window to a range of -10 to 10 on both axis. To find each of the critical points requested the teacher uses the...

Prev Page