Median Statistics Search Results

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: 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: Get statistics on your mouse and keyboard activity on a Microsoft Windows PC

Interested to know how many times you've clicked your mouse of the course of the past month? How many keys you've typed? This clip will show you how it's done. With WinOMeter, it's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.

How To: Test a hypothesis with Excel's TINV & TDIST functions

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 92nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the TINV and TDIST functions to test a hypothesis.

How To: Construct confidence intervals with Excel's NORMSINV

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 85th 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: Create a quantitative freq. 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 24th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data frequency distributions with pivot tables. See how to create the correct unambiguous labels ...

How To: Create a distribution for categorical 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 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Shorten links with bit.ly

Link shortening is the process of cleaning up the URL link which is long and converting it into a short URL. You can use bit.ly to do link shortening. Using bit.ly you can not only shorten the link but also track the users who are using those links. To use this service go to the http://www.bit.ly website. There in the home page you are provided with a text box. Enter your long link in the text box and submit it. Now the website converts the long URL and provides you with a short link which ca...

How To: Add and subtract complex numbers

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Find real and imaginary parts of a complex number

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Divide complex numbers

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Use imaginary numbers and quadratic equations

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Write the square root of a negative complex number

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Multiply complex numbers

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Represent complex numbers with the Argand Diagram

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Find the complex conjugate of a complex number

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Calculate the modulus and argument of a complex number

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Find the polar form of a complex number

Need a little help with your math homework? No problem, the Math Centre offers students video tutorials that will provide as a reference guide for self-study. Students get self-study resources targeted to the needs of individual courses, and teachers gain generic mathematics support and study materials for use with students.

How To: Solve permutation & combination word problems

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 unpack and solve word problems invplving permutations and combinations in basic stati...

How To: Estimate probabilities with the empirical rule

Learn how to use the empirical rule (or 68-95-99.7 rule) to estimate probabilities for normal distributions in statistics. 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 fre...

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: 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: Use the PERCENTILE & QUARTILE functions in MS Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.