Require Regular Search Results

How To: Use the MEAN, PERCENTILE & RANK functions 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 33rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the AVEARGE, MEDIAN, MODE, PERCENTILE, QUARTILE and PERCENTILERANK functions to measure location.

How To: Create a percentage frequency table in Microsoft 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 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).

How To: Get candle wax out of your carpet

Want to remove dried wax from a carpet? You'll need four items: a white towel, a regular electric iron, a carpet cleaning solution and a hot-water extraction machine. For a complete, step-by-step demonstration of how to remove pesky paraffin wax stains from your own carpet, watch this free housekeeping video tutorial.

How To: Create a starry sky in Photoshop

The video is a Photoshop tutorial teaching how to create the starry sky effect, an effect that turn regular sky in a photo into a starry night sky using the Adobe Photoshop software. This effect is created by the use of Photoshop filters like noise, blur, levels and masking in order to achieve the look of a real night sky. By following the tutorial you will learn how to create and control the amount of stars in the photo's sky in only 6 minutes.

How To: Convert cassettes to CD

Cassettes take up quite a bit of space, and can sometimes start showing wear, which can affect the sound. This video shows you how to take this information from your cassettes, and move them on to a CD. Detailed instructions, and photos in this video, will have you transferring analog information into a digital format within just minutes. This allows you to be able to use the audio recording on your computer, as well as being able to listen to it in a regular CD player.

How To: Do basic and simple jazz walks

Jazz walks are basically regular walking combined with a tiptoeing motion that makes the walk like a cat strut. Jazz walks are beautiful and sexy ways to transition from one part of your routine to another, and they're also great as coreography of their own.

How To: Use the standard Brush tool in Adobe Illustrator CS4 or CS5

In this clip, you'll learn how to make use of the regular Brush tool when doing design work in Adobe Illustrator CS4 or CS5. Whether you're new to Adobe's popular vector graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Get a tremolo or wah sound on an acoustic ukulele

There's no getting around it: if you want to get good at playing the ukulele or any other instrument, you'll need to practice. Fortunately, the Internet is awash in free uke lessons, like this one from Ukulele Live, which make the task not only easy but fun. This clip, in particular, demonstrates how to achieve an entirely analog wah-wah effect on a regular acoustic ukulele by applying pressure with your forearm.

How To: Clean and overhaul a Shimano bike pedal

Cleaning your pedals is an important part of regular bike maintenance, but annoyingly enough there is no one way to overhaul a pedal. Every bike maker builds their pedals differently. This video demonstrates how to disassemble, overhaul, and clean Shimano pedals so that they will be free-spinning and functional as the day that you got them.

How To: Calculate skew in a distribution in Microsoft 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 44th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the SKEW function to calculate the skew in a distribution of data.

How To: Calculate percentiles and quartiles in Microsoft Excel

f 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 37th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the PERCENTILE and QUARTILE functions.

How To: Make a paper cup

If you're finding yourself without dishes due to the fact that you're packing or unpacking, getting a quick drink can be a pain. So instead of rummaging through all those boxes try this quick nifty tutorial. This video shows you how to make a paper cup using just a couple sheets of regular paper. It's so easy and efficient you'll be sipping water in no time. Enjoy!

How To: Work with bell curves in Microsoft 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 47th installment in his "Excel Statistics" series of free video lessons, you'll learn about the basics of the empirical rule (the bell curve) and how to apply it in various ways.

How To: Find statistical critical & p values 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 89th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values.

How To: Find critical values with T functions 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 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.

How To: Find confidence intervals with a sigma value 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 80th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is known known using the CONFIDENCE and NORMSINV functions.

How To: Build labels for a frequency distribution 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 21st installment in his "Excel Statistics" series of free video lessons, you'll learn how to build labels and counting formulas for a frequency distribution.

How To: Use NORMSINV with critical values in Microsoft 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use NORMSINV to test a hypothesis with population standard deviation (sigma) known and proportions.

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

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 28th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data stem & leaf charts using the REPT and COUNTIF functions.

How To: Chart a categorical frequency distribution 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 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a column chart from a frequency distribution for categorical data.

How To: Use absolute and relative cell references 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 5th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use relative and absolute cell references to save time when writing formulas.

How To: Blow bubble rings underwater

Anyone can blow bubbles with that soap formula and a bubble wand, but what about blowing bubbles rings underwater. It surprisingly, isn't too much different from blowing regular bubbles underwater. You'll need to be able to hold your breath for a long time and to be able to stay under the water's surface (the deeper you can go, the longer the bubble ring will last). Watch this video bubble-blowing tutorial and learn how to blow bubble rings underwater.

How To: Make a Mexican Mojito

Anthony Caporale bar instructor extraordinarie is here in another "Art of the Drink" episode. This week he is showing how to make a Mexican Mojito. The twist from a regular mojito? Replace the rum with tequila!

How To: Grow blue corn

Blue corn is a special variety of corn which can be differentiated by the majority of the corn species by looking at the unusual top growth of the corn. It is a hybrid and grows very uniformly throughout. Now take a corn from the field and peel it off. You shall notice that it has a blue color corns. Blue color corns are hard from outside but they are very soft and tender in the middle. You can use these blue corns in making commercial products like blue corn chips, tortillas, and atole ’,‘ c...