Distribution Analysis

If you work in consulting or some other profession that requires you to analyze data, sooner or later, you'll need to build a histogram.  This is because the histograms is one of the most effective methods to visualize and understand a data set.  Averages, sums, and counts are calculations that only tell you part of ... Continue Reading >>
Whether you're building a model or trying to simulate a scenario within your analysis, at some point in your Excel career, you're going to need to use a randomized set of data.  If you need to create a purely random set of numbers, with no specific constraints or parameters, you can just use the RAND ... Continue Reading >>
One of the most annoying things to have to do in Excel is writing a Nested IF statement.  For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for.  The most common usage of this formula is to assign ... Continue Reading >>

Related pages

microsoft excel 2007 free trialucla wooden center classesvba excel vlookuphow to do a checkmark in excel 2010using vlookup in vbahistogram function excelexcel countif greater than 0calculator excel templatenormal distribution excel templateexcel financial model templatehow to nest functions in excelmultiple vlookup resultsvlookup excel formulas with exampleshow to make a randomizer in excelshortcut keys in excel 2007 for filtergpa uclaucla discount ticketsleft vlookupexcel formulas vlookup multiple entriesexcel offset formulalabel chart in excelvlookup cheat sheetexcel random generatorhow to make a bar graph on excel 2010gaussian random number generatorhow to create a distribution graph in excelhomework sheet templatevlookup isnazs associates consultingrandom chart generatorexcel matching formulavba excel samplebasic vlookup exampleshort cut for paste specialexcel bracket templateexcel remove duplicates and originalsucla requirements gpahow to make tick mark in excelimportant excel shortcutsdifference between lookup and vlookupcompare three columns in exceltoo many different cell formats excel 2010 fixexcel dedupeexcel filter using formulastep by step vlookup in excelexcel delete all macrosvlookup table rangeiferror excel functionremove duplicate data excelvlookup different sheetstax formula in excelthe goal by goldratt summaryirs tax liability calculatorexamples of if statements in excelround to the nearest 1000 in excelprice optimization models excelquestions to ask in mba interviewhow to compare 2 columns in excelexcel macro random numberconditional if statement exceltypes of excel formulasdefinition of vlookup in excel 2007vlookup function explainedexcel cell formatsdrag cell in excel not workingtracking inventory in excelhow to delete a row in excelwhen to use vlookupexcel macro tipsucla anderson directoryexcel multiply matrixstacked chartsexcel vloo