Patterns Search Results

How To: Calculate a standard (z) score 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 45th installment in his "Excel Statistics" series of free video lessons, you'll learn how to see how to calculate a z-score.

How To: Calculate geometric average in Excel with GEOMEAN

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 35.2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's GEOMEAN function to find geometric mean.

How To: Find range and interquartile range 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 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.

How To: Create confidence intervals for proportions 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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.

How To: Find the sample size for confidence intervals 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.

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: Make cable knits

Cable knits are sometimes considered too complex for hobbyist knitters to attempt, but this video tutorial from the folks at Make Magazine will introduce you to this classic technique. Pioneered in Ireland by the wives of fishermen, the look of cable knits actually reflects fishermen's ropes and other aspects of their lives. While cable knits look complex, in this video you will see that they really don't have to be that much more complicated to create then the patterns you're used to working...

How To: Simulate brick wall effects for dioramas

Here are some examples of brickwork for dioramas or war game terrain. Create a fine grit coating for foam carvings using a mixture of white glue, paint and fine sand. Press in brick patterns into foam, or if working in smaller scale, you can coat cardboard with a thin coat of plaster. Find old pieces of dry flat wood to create miniature slats of wood for sides of a barn or haunted house.

How To: Play drums

Do you want to learn to play drums for the very first time? Watch Mike Michalkow's step-by-step training video to get started. It will guide you through four simple patterns that form a basic rock drum beat.

How To: Paint spring-loaded clothespins into colorful, decorative wooden fasteners

Spring-loaded clothespins are used for more than just clothes. If you looked in anyone's home, you'll see these springy wooden clothespins used for things like chip clips, photo holders and even for attaching sports cards on bicycle spokes. They're even used in the film industry (called C47s or bullets) for clamping colored gels or diffusion to hot lights on set. So, there's a million uses for these wooden clamps, but that doesn't mean they have to look the same— drab and unoriginal.

How To: Make a hip hop beat in FL Studio

In this video we learn how to make a hip hop beat in FL Studio. First, load up your drum sounds from the browser to the interface. After this, change the hits on the drums to make the beat sound different. Edit how high the volume is on the snare drum and then change the ghost kick so it's not too loud either. Once you have this figured out, add in the high hat and the shaker patterns. Once you have these added in and you like the volumes that they are at, you will have your very own hip hop ...

How To: Play basic Blues on the acoustic guitar

The blues is where it all began. Before you learn how to play rock or jazz or metal, you should start with the blues. Learning the basic 12 bar form can help you feel out measures and develop your sense of direction in music, and learning how to play the shuffled rhythm will help to increase your proficiency with learning other rhythm patterns. In this fantastic video you will get a basic over view of the Blues on the acoustic guitar and a quick variation on the standard blues shuffle.

How To: Create a macabre and beautiful dark fairy Halloween makeup look

Fairy costumes are as common as witch costumes or vampire costumes (especially now with the "Twilight" fever) for Halloween. But dark fairies are a whole other category altogether. Rather than the cute pink frills, golden hair, and pixie dust you imagine your typical Disney fairy to have, the dark fairy in this makeup tutorial is scary, though still beautiful.

How To: Make custom chipboard buttons for scrapbooking

In this video, we learn how to make custom chipboard buttons for scrapbooking. First, take a scrap of chipboard and use a circle trimmer to cut circles out. Cut circles out of patterned paper in different sizes using many different patterns. Now, apply glossy finish onto the papers and wipe off the excess liquid. Ink the edges after this, then put adhesive onto the back of each of the different circles. Now, you can punch holes into the center of the circle to make it look like a button. Now,...

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 ...

How To: Create frequency distributions with Excel pivot tables

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 15th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use create a frequency distribution, relative frequency distribution, percent frequency distribution and pie chart wi...

How To: Work with nominal, ordinal & interval scale 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 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...

How To: Play "Stairway To Heaven" by Led Zeppelin on electric

In this acoustic guitar video lesson, brought to you by RockGuitarPower, host Mike, will teach you how to play "Stairway To Heaven" by Led Zeppelin. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This tutorial covers the intro, solo, and rhythm patterns used in the song, and illustrates the chords used in tab notation.

How To: Use bent handled trimmers

Learn how to use bent handled trimmers: Kenneth D. King of ThreadBanger Quickies and NextNewNetworks explain how to use bent handled trimmers for working with fabric projects. Bent handled trimmers are great for cutting out fabric patterns and designs. The scissor itself slides along the smooth plane of the cutting table and it lifts the fabric just enough to successfully cut the pattern out. Bent handled trimmers make a very accurate cut. Never ever use your fabric scissors for cutting paper.