Okebiz Video Search



Title:Learn Excel 2010 - "Random Around Mean and Standard Deviation": Podcast #1507
Duration:183
Viewed:21,714
Published:12-01-2012
Source:Youtube

Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWEEN won't do it, but a clever use of =RAND and =NORM.INV ["Normal Inverse"] will do it. In Episode #1507, Bill shows us how to generate Random Numbers with this method.

...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

SHARE TO YOUR FRIENDS


Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Generate Random Numbers in Excel Generate Random Numbers in Excel
05:46 - 302
FRM: Using Excel to simulate standard random normal variable FRM: Using Excel to simulate standard random no...
08:57 - 126
Learn Excel - Place People on Bell Curve - Podcast 2217 Learn Excel - Place People on Bell Curve - Podc...
07:11 - 508
Random Numbers - Numberphile Random Numbers - Numberphile
11:39 - 970
☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft Excel ☑️ Top 25 Advanced Pivot Table Tips & Trick...
28:30 - 426
Beginners Guide to Excel Macros - Create Excel Shortcuts Beginners Guide to Excel Macros - Create Excel ...
14:35 - 121
Pick Names at Random from a List Pick Names at Random from a List
08:30 - 24
Excel: Graphing with separate Error Bars of Standard Deviation Excel: Graphing with separate Error Bars of Sta...
06:38 - 340