Accurate Data 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: 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: 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: Create a list of hyperlinks in Microsoft Excel

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Remove the last two words from a column 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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.

How To: Use Excel data analysis subtotals

1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...

How To: Find a data point (Xi) with the Z-Score formula

In this free video math tutorial, we learn how to use the Z-Score formula to find a data point (Xi) in statistics. With mathematics, as with anything else, not everyone progresses at the same rate. Stats is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. Whether you need help finishing your homework or studying...

How To: Interpret a standard deviation

A rough definition of standard deviation is that it is a measure of expressing the observed variations about the average in statistical data i.e. by how much do the observed values vary from the mean. This video continues from the previous solved example and demonstrates the mathematical interpretation of the standard deviation that was calculated. We begin with stating the mean and standard deviation values and then calculating the upper and lower bounds of the data based on the standard dev...

How To: Protect data on an Android phone with the Lookout antivirus app

Your Android phone is a computer not unlike a laptop or desktop PC and it shares the same vulnerabilities. This clip presents a quick overview of how to safeguard against viruses and data loss. With the Lookout app, it's easy! So easy, in fact, that this video guide can present a complete overview of the process in about two minutes. For more information, including step-by-step instructions on how to adjust your own Facebook tagging settings, take a look.

How To: Convert Farenheit to Celsius in your head

This video tutorial is in the Education category which will show you how to convert Fahrenheit to Celsius in your head. This method is a good estimate for converting temperatures. However, do not use this for accurate temperature conversions. Let's say you want to convert 22 degree Celsius to Fahrenheit. 1st step is to double the figure, that is, add 22 plus 22 which is 44. Next add 44 with 30, which gives the result 74. So, 22degree Celsius is equal to 74 degree Fahrenheit. Similarly, 32 deg...

How To: Make a googly-eyed paper cat on a popsicle stick

Everyone loves cats, for the most part. It would be more accurate to say that everyone loves kittens. No one can resist the cuteness of brand new baby kitty, especially children, which is why kittens and cats make the perfect craft project for kids. In this video, you'll learn how you and your kids can create a googly-eyed paper cat upper on a popsicle stick. It's great for any young child. You'll need:

How To: Use data forms in Microsoft Excel 2003 or 2007

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data form in both Excel 2003 and 2007 as well as how to add a button to Excel's Quick Access toolbar.

How To: Use a caliper to measure body fat on an average person

One of the best ways to monitor your diet is by measuring your body fat content. In this three part tutorial, learn how to measure body fat using a caliper. A caliper is a device used to pinch and measure the fat on your body. A caliper is cheap, fast and accurate and makes an excellent alternative to electronic devices. Check out this video and stay on top of your new workout regime - mind the scale and use the caliper to know what's muscle and what's excess.

How To: Recover deleted files and lost data from disk crashes

This video from CNET Insider Secrets tells you how to recover deleted files from a data drive. If a disk is still readable by the computer, files may be recovered. Files may be recovered using the PhotoRec program, PC Inspector or other programs that may be available. An example is shown where mp3 files are deleted from a flash drive. We are then shown how files are recovered using the PhotoRec program, including how to select the correct file system. The mp3 files are recovered along with va...

How To: Restore your computer in Vista to factory settings

Here, you'll be shown how to revert your Windows Vista computer back to its factory settings, if you get stuck with a bad virus or anything else like that. Make sure to back up all of your important data before you decide to go back to the original factory settings, as you don't want to lose that precious data. After a quick backup, we'll run through the options from start to finish. We will run through a few restarts of the system, and then show you the easy path to getting your system back ...

How To: Sync an iPod with the Xbox 360

Do you want to know how to sync an iPod with the XBox 360? You must have an iPod and a XBox 360. Connect your iPod with your XBox with the USB cable. Transfer the files from the iPod to the XBox XBox helps play AAC format as well as MPEG movies. The iPod must be connected to the portable device section. This will help you share movies, music, pictures and other data and you can even copy the downloaded data to your iPod from the Xbox.

How To: Make a sun compass in the Southern hemisphere

This video gives you a quick and easy way to create a sun compass and how to use specifically in the southern hemisphere. With just the use of sticks, stones, and a shadow, you'll be able to get an accurate north/south line and determine your principle compass points. With the knowledge of course that the sun rises in the east and sets in the west. This is a great alternative if you were to ever loose or break your compass when hiking, camping, or simply being adventurous outdoors.