# Market Trends Search Results

### 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: Craft a quick 2-minute tissue paper pom pom garland for Halloween

There's always a lot going on in the craft world, with ingenious new products being made every day. But there are also trends in decorating that rise up and end up on every crafter's blog. Right now, that ternd is garlands.

### How To: Craft a cracked glass patterned spring butterfly card

Crackled glass has made its appearance in lots of cultural avenues, including nail polish (remember the crackled nail polish trend popular a few years back?), glass designs, and now, cards.

### 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: 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: Sew a tailored jacket with OTIS College of Art&Design

Some trends come and go, but true style is timeless - just look at Coco Chanel, whose menswear two piece suits and quilted bags are just as beautiful today as when she wore them in the 1920's. And a tailored jacket is one piece that every woman should have - contoured, slimming, and sleek, it's as wearable to an office meeting as to lunch with the gals.

### How To: Use dramatic eye makeup for a gothic look

Here's a step-by-step on how to score three different versions of a gothic makeup trend.

### News: Not Digging the Notch on the Leaked OnePlus 6? Don't Panic Yet

Last week, the first possible image of the upcoming OnePlus 6 leaked. It was met with mixed reactions, most notably for its apparent iPhone X-style "notch." OnePlus fans seem concerned that the company is implementing a design choice based on what it thinks is trending, not necessarily what's best for the product. If you're one of those uneasy about OnePlus' future, don't be. At least not yet.

### How To: Craft simple beaded dangle earrings

There's no need to shell out tons of money to wear the latest jewelry trend. Craft your own bohemian, indie-cool jewelry by checking out this DIY video.

### How To: Get Jennifer Aniston's poofy high ponytail

Girl next door Jennifer Aniston is a master of sexy yet low maintenance hairstyles. She did famously start "The Rachel" haircut trend, which spread to salons all over America and remains a haircut staple today.

### How To: Craft a simulated wood (faux bois) tribal necklace

Besides crushed velvet clothing and accessories and anything with a lot of sparkly sequins, tribal jewelry is very in this holiday season. While it isn't necessarily as festive or as glitzy as the other fashion trends, it's uniquely, naturally beautiful and really makes a statement.

### How To: Upcycle an old t-shirt into a puff-sleeved shirt

Got a bunch of old, too large t-shirts lying around that you don't want to throw away, but that you also can't seem to wear? Then take the high road by upcycling it into this on-trend puff sleeved shirt.

### How To: Make easy embellished bohemian earrings using fabric stiffener

Bohemian hair, fashion, and beauty have been super hot in Hollywood for the past year or so, and the trend is showing no signs of slowing down. While many hip young designers offer bohemian bangles and earrings at trendy L.A. boutiques, avoid denting your wallet with their overpriced goods by making some bohemian earrings yourself!

### How To: Transform an old scarf into a tube scarf or infinity scarf

With winter in full swing, it's time to bring the scarves out of the closet. The trend this year is the tube scarf or infinity scarf, and here is how you can take a scarf you already have and update it to this style.

### How To: Style trendy "scene" bangs

"Scene" bangs is just a fancy way of saying cool-looking, hipster bangs. You can't rock the hipster trend the way it was meant to be rocked if you only have the skinny jeans, loose organic cotton top, and bangles, right?

### How To: Create a bold and brown smokey eyes makeup look à la Pat McGrath

Anyone in the world of makeup knows who Pat McGrath is. The world renowned makeup artist recently did the makeup for a catwalk for designer Roberto Caballi, and instead of taking the usual black smokey eyes look, she went for a new trend this season— BROWN! In this tutorial, you'll learn how to create a bold and beautiful brown smokey eyes look, great for the autumn and winter months.

### How To: Create a pretty Japanese dolly curls hairstyle

Dolls may freak the rest of us out, but for a lot of girls in Japan looking like a doll - scarily large, beady eyes, perfect ringlets, and porcelain skin - is its own beauty and style trend.

### How To: Style boho milkmaid braids like Nicole Richie

Braids seem to be the latest Hollywood trend. Very rarely do you see boho stars like Nicole Richie, Blake Lively, Mary-Kate Olsen or Mischa Barton without at least one twisted strand in their hair.

### How To: Dress like a young Hollywood celebrity

Feeling a tad bored with your look? Get some fashion help from Emmy-nominated costume designer, Cate Adair, on how to dress like a young, hot Hollywood celebrity. Looking like a Hollywood celebrity involves taking fashion risks, such as mixing designer clothing with vintage pieces, wearing over-the-top accessories and bringing back old trends. Find ways to dress like a hot young star with tips found in this how-to video.