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

how to delete a row in excelluvalle uclaexcel vlookup practicefind duplicates in excel spreadsheetexcel count formulashow to compare two column in excelformula in excel sheet with examplesstacked chart excelvlookup tutorialshow to make column graph in excelexcel formula for random selectiondget excelucla gpa scalecopy vlookup formulapay stub format in excelhlookup in excel with exampleexcell histogramhow to get rid of duplicates in excelconstruct a histogram in excelvba range syntaxexcel formula cheat sheet pdfexcel vba isnavlookup in two columnsdefine the column input cell for the selected tablems excel 2007 formulas and functionsthe goal eliyahu goldratt moviecalculating cpk in excelmicrosoft word insert check markexel vlookuptick mark in powerpointhow to prepare checklist in excelvlookup for two columnscalculating cpk in excelbell curve templatemultiple vlookuprandom name selector downloadcheckmarks in excelgoldratt the goal summarylookup value in excelexcel 2010 compare two columnsvlookup not workingwhat is vlookup function in excelexcel embed functionshow leading zeros in excelexample vlookupvlookup 2 spreadsheetsexcel if statement formatcreating a histogram in excelfancy excel templatessemester planner templateexcel shortkeyjob estimate template excelexcel vlookup for dummiesexcel sort ascendingexcel duplicate cellsexcel count cellsexcel formulas nested iftroubleshooting vlookupexcel 2010 match functionvlookup within an if statementzs consultingvlookup functions in exceleasy excel shortcutsremove duplicates from excel columnexcel symbol formulamy ucla log intask tracking spreadsheet templatehow to tick a box in excelinverse normal distribution excelzs associates bostonexcel logical testscmc student webmailexcel writing formulashistogram microsoft exceldelete duplicate rows from tabletax forecasterindex and match function in excel