Regular Search Results

How To: Plot data with Microsoft Excel's REPT & COUNTIF 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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.

How To: Create a cumulative 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 26th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cumulative frequency distributions with pivot tables.

How To: Cross tabulate categorical data 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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).

How To: Group categories in an Excel frequency distribution

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 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping fea...

How To: Cross tabulate categorical data with formulas 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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.

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: 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: Make simple and quick frozen grape snacks

Grapes as dessert? After watching this food video you'll think twice about these juicy purple orbs. While we think popping some grapes into our mouths is delicious enough as it is, this recipe combines grapey goodness with icy coldness for a delicious, almost popsicle like snack.

How To: Draw graffiti lettering

In this tutorial, we learn how to draw graffiti lettering. To do this, you will use a pen and draw out your letters adding a graffiti flare to them. Do not draw regular letters, these have outlines and a flare out to the ends of them. This is very similar to the graffiti you will see written outside, but used with spray paint. Fill in the middles of the letters, then draw lines around it to make it look like it's standing off of the paper. use a marker to outline the sides of the letters so e...

How To: Avoid skin irritation while shaving

In this tutorial, we learn tips on how to avoid skin irritation while shaving. For women, this is a necessary thing they must do everyday, but irritation occurs often. First, shave only in the shower. In the beginning, use a cleanser on the area you are going to shave. During the course of the shower, your skin will soften. Now, take shaving cream and rub it onto your leg. Now, take a regular razor and have with the grain, then against it until your legs are smooth. When finished shaving, dry...

How To: Use salty hashes to keep passwords secure

In this tutorial, we learn how to use salty hashes to keep passwords secure. A hash is stored in a database that is hashed with an algorithm, so not everyone can see exactly what your password is. When you type your password into a website, it doesn't actually register as words, it registers as a hash. This keeps your passwords secure so not everyone can see them. Salting is when you use random pits and attaching them to your regular hashes so not every password is the same. The salt is what ...

How To: DIY your own iPad stylus

While the iPad can do many things, it is missing the ability to be controlled by anything other than a finger. This can be frustrating if you would like to use your iPad for more intricate activities such as drawing or designing.

How To: Protect your non-stick cookware

Non-stick cookware is a great way to cook and not have to deal with foods that stick to regular pans or deal with the cleaning up after cooking. A few rules to keep in mind are to not preheat a non-stick pan and do not use a heat level above medium. If you break or damage the surface of the pan, it could cause more damage than you think. There have been reports where you could develop flu-like symptoms just from cooking with a bad pan.

How To: Calculate a trimmed 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 36th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate a trimmed mean, which is used when there are extreme values in the data set that might skew the mean.

How To: Create an X-Y scatter diagram chart 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 39th installment in his "Excel Statistics" series of free video lessons, you'll learn about variability (or dispersion or spread). Create an X-Y Scatter Diagram chart showing data points and the mean.

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: Group quantitative data 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 32nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to group when the quantitative data are whole numbers, integers or discrete data and how to group when the quantitative ...

How To: Create percent & relative freq. distributions 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 25th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data percent & relative frequency distributions with pivot tables. Also see how to create a histo...

How To: Make distributions, ogive charts & histograms 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 22nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a percent (%) cumulative frequency distribution with formulas, a histogram and an ogive chart. See how to add ...