Statistics Search Results

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: Chart data with a box and whisker plot

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free statistics tutorials, you'll learn how to use visualize data by graphing it in a box-and-whisker diagram.

How To: Determine the probability of dependent events

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the probability of two dependent events in statistics.

How To: Build confidence intervals & test hypotheses 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 47th 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. Compare building confidence int...

How To: Find confidence intervals without the sigma 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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Calculate the unemployment rate

All you hear about on the news, the radio, and in other media sources is how the unemployment rate is high. But how do they know that? How did they get to that conclusion? Well, wonder no more! In this video you will learn what formulas you can use and other statistics to find out what the unemployment rate is.

How To: Work with Chebyshev's Theorem & bell curves 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 48th installment in his "Excel Statistics" series of free video lessons, you'll see comparison of Chebyshev's Theorem and the Empirical Rule (bell curve) and learn when to apply which.

How To: Use Chebyshev's Theorem 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 46th installment in his "Excel Statistics" series of free video lessons, you'll learn about Chebyshev's Theorem and how to apply it in three different ways.

How To: Calculate the coefficient of variation (CV) 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 42nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate the coefficient of variation.

How To: Create a scatter diagram for 2 variables 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 30th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a scatter diagram for 2 quantitative variables.

How To: Find simple probabilities 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 51st installment in his "Excel Statistics" series of free video lessons, you'll learn how to understand, work with and find simple probabilities in Microsoft Office Excel.

How To: Work with probabilities in Microsoft Office 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 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:

How To: Use the NORMSINV & NORMSDIST 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 93rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV and NORMSDIST functions to complete a hypothesis test about a population proportion.

How To: Construct confidence intervals with TINV 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 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.

How To: Create quantitative data cross tabulation 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 29th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cross tabulation using a pivot table (PivotTable).

How To: Chart cross-sectional and time series data 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 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.

How To: Install the Microsoft Excel Data Analysis add-in

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 install the Excel 2007 Data Analysis add-in.

How To: Create a histogram using data analysis in Excel

A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.

How To: Find mean, median, & mode (averages)

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 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Find outliers using the Z-score method

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 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

How To: Use the RANK and PERCENTRANK 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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Group quantitative data into classes 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 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...

How To: Build confidence intervals given the sigma 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Work with skew and histograms 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 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Create a relative 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...

How To: Make calculations in Excel with formulas & references

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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Apply accounting & percentage formatting in Excel

This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...

How To: Monitor network activity on Windows 7 with Tekzilla

Veronica from Tekzilla teaches you how to monitor network activity on Windows 7. Go to ITSamples and download the Network Activity Indicator program. Install it and run it. This will add a new icon on your system tray. It blinks to reflect incoming and outgoing packets. You can right click to see a more detailed report. You also get statistics and a menu for your network and firewall settings. So to get the popular windows XP type network indicator icon all you need to do is follow the steps ...

How To: Understand the central limit theorem

Central limit theorum is easily one of the most fundamental and profound concepts in statistics and perhaps in mathematics as a whole. In probability theory, the central limit theorum (CLT) states conditions under which the mean of a suffiently large number of independent random large variables (each with finite means and variance) will be normally distributed, approximately. Huh? If you are having trouble understanding central limit theorum and need help trying to solve it, check out this tu...

How To: Calculate proportions and percentages in Excel

This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...

How To: Organize your garage to save space

According to a U.S. survey, the crud in our garages is taking up most available floor space. Hence the average North American chucks up to $6500 worth of mostly useless stuff on the floor of the garage, while the $20,000 vehicle sits outside in the cold, rusting. It's time to get our cars back into garages. We spent more than $688 million dollars last year on garage organization and it barely made a dent. If you don't believe me, walk down your street and count the number of houses with cars ...