Creating Histogram With Analysis Tool Pack
One of the best ways to find how your data is behaving is to plot a histogram. Creating histogram is amongst the firs step we take to analyze the data as it outlines how the data is distributed, details about the skew-ness and kurtosis (described later in this section).
Generating Random Data In 5 Minutes
When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.
Using RANDBETWEEN For Dates In Microsoft Excel
The RANDBETWEEN function is available for use in Microsoft Excel. The function is used to generate randomized dates between a specified start date and end date.
How To Randomize A List In Excel
Suppose you want to randomize a list, for this you have to have a list of random (or shuffled) numbers, which can be used to randomize the list you want.
 function.png "Getting real random numbers with RAND() function")
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
