Trend Spotting Search Results

How To: Use Microsoft Excel's sort and pivot table tools

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 3rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's sorting and pivot tables (PivotTables) data analysis tools.

How To: Calculate weighted & geometric mean 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 35th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate weighted and geometric means and see how to use the GEOMEAN function.

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: Make a DIY vehicle immobilizer to stop car thieves

We all know the G-spot as that sensitive area that drives women crazy, but for auto enthusiasts, it has a whole new meaning. The G-Spot, designed by Daniel Davies, is a vehicle immobilizer, which keeps your vehicles safe from car thieves. And you don't need to pay a huge amount of money to get one, either! You can make on yourself, right at home, provided you have all the right materials.

How To: Properly fold a letter and look professional

From this video, learn a proper way to fold a letter professionally and place it an envelope. Basically take the letter and lay it in a flat surface, then find a spot in the paper which is almost a certain way up and then fold from bottom to that spot and crease it. Then fold from the top above the previous fold and then crease it so that it is a three fold letter. Make sure that the letter head is up when you place it inside the envelope. So that when a person opens the letter the letter hea...

How To: Perform the "serenade of the kings" card trick

This card trick is called Serenade of the Kings. Make two piles of four cards. The first pile contains all kings, and we set these face down (except for the leader king in front) on the table in a star shape. The other pile contains four black spot cards that help us do our magic. Burying the kings into the black spot cards, one by one, shows that they disappear into the pile with a little twist and shake. Now we place the kings and black cards in four different piles of two, but once we pick...

How To: Conceal acne spots on dark skin

The first trick to concealing acne spots on dark skin is to find a concealer with a lot of pigment. Test the concealer on a vein or freckle to make sure it covers completely. Using a synthetic brush, dot the concealer over the pimple, lightly feathering around it to blend in the makeup. You can set the concealer by applying pressed powder with a makeup sponge. When you apply your foundation, be sure to add it lightly, otherwise you may create unwanted smudges.

How To: Pierce your own lip like an emo kid

In this tutorial, we learn how to pierce your own lip like an emo kid. First, grab a safety pin and put heat with a lighter to it. Let this cool off, then put gloves on your hands. Mark where you want the piercing to be on your lip and look in the mirror to make sure it's in the right spot. Once you have this spot picked out, then you will poke the safety pin through the spot until you poke through the other side. Use tissues to clean up any blood that comes out. Next, you will slip the jewel...

How To: Pierce your own lip safely

In this tutorial, we learn how to pierce your own lip safely. First you will need to clean off your needle with a cleaning solution and clean out your mouth as well. After this, you will need to mark the spot where you want to pierce your lip at. Look at this in the mirror to make sure it's at the spot where you want it to be. From here, you will poke the needle through the lip at the spot you want it to be. From here, you will poke the jewelry through and then put the cap on that. To finish,...

How To: Create trending topics with hashtags on Twitter

In this clip, you'll learn how to incorporate hashtags or hash tags into your tweets on Twitter. What do President Obama, the Dalai Lama and Justin Bieber have in common? Why, they're all on Twitter, of course. Join the party. Whether you're new to Twitter's popular microblogging application or just missed a few of the essentials along the way, you're sure to benefit from this free video tutorial.

How To: Touch up portraits with the Photoshop CS5 Spot tool

Searching for a primer on how to use the Adobe Photoshop Spot Removal tool? This clip will teach you what you need to know. Whether you're new to Adobe's popular raster 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: 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: 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: Zap pimples with spot remover and blemish extractor

In this video tutorial, viewers learn how to quickly get rid of pimples. The products recommended to remove pimples in this video are Origin's Spot Remover and a blemish extractor. The spot remover can be used 2-3 times a day. This product costs $12. Simply squeeze the bottle and apply it on the infected area(s). It is also recommended to use a blemish extractor to pop pimples. It is also able to remove blackheads. Simply push it gently down the pimple or blackhead to remove it. This video wi...

How To: Crop an image in Adobe Photoshop CS2

In this how-to video, you will learn how to crop an image using Adobe Photoshop CS4. First, open Photoshop and open the image you want to crop. Next, press filter and select the edge hollow tool. Carefully draw around the image you want to crop. Once this is done, click on the fill tool and left click in the middle of the image. Now, press preview to see if you missed any spots. You can clean these spots up by pressing the clean up tool. This will allow you to erase these particular spots. On...

How To: Get rid of fake tan mistakes

If you've ever experienced problems with applying/getting a fake tan and having mistakes, then this video is going to show you how to cover up those fake tan mistake spots. The solution to this problem is very simple and all you need to do to start is buy any kind of white mint toothpaste. With this toothpaste apply it by hand to the trouble spots of your fake tan, and with the bleach inside of the toothpaste it will fade the tan. Another method is to take a regular lemon and rub it against y...

How To: Convert images to spot colors using Photoshop

In screen printing, Photoshop can be a powerful tool. If you have a jpg, tif, eps, or other type of file in which you can't alter, printing from Photoshop will give you too many separations. Here is a way to take a simple design in Photoshop and convert it to spot colors in order to print solid colors instead of mixing inks.