
Re: Histogram  what is the goal?
christian juillard Aug 10, 2017 9:10 AM (in response to Andrea Gigliotti )hi
i am like you
as far as I have understood Histogram is like a light version of bar chart
juju

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 10, 2017 9:54 AM (in response to christian juillard )bar chart with only one dimension and no measures ?


Re: Histogram  what is the goal?
Bill Markham Aug 10, 2017 10:30 AM (in response to Andrea Gigliotti )Wikipedia say a Histogram is a kind of bar graph.
Or more verbosely and more confusingly: A histogram is an accurate graphical representation of the distribution of numerical data. It is an estimate of the probability distribution of a continuous variable (quantitative variable) and was first introduced by Karl Pearson.
The example they give is petal length vs frequency.

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 10, 2017 10:34 AM (in response to Bill Markham )i was looking for a real use case in some business scenario.

Re: Histogram  what is the goal?
Bill Markham Aug 10, 2017 11:19 AM (in response to Andrea Gigliotti )I have used it for data that is number of active users in 15 minute buckets
So the x axis is number of users in each discrete 15 min bucket and the y axis is the number of buckets with that number of users, which produced a type of histogram called a Standard Distribution Plot. It had the lower 99.9 percentile as normal and the upper 0.1 percentile highlighted in red as outliers. This was and still is used to work out of monies due for an application with a somewhat obtuse pricing method.

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 11, 2017 4:35 AM (in response to Bill Markham )Hi Bill,
can you tell me dimension type and histogram settings used for that scope ?
thanks.
BR
Andrea




Re: Histogram  what is the goal?
Andrea Gigliotti Aug 11, 2017 5:07 AM (in response to Andrea Gigliotti )it's really hard to find a right dimension for histogram object...
any idea ???

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 11, 2017 9:14 AM (in response to Andrea Gigliotti )I also facing the label of frequency (y axis) can't be changed.

Re: Histogram  what is the goal?
Prashanth Reddy Aug 11, 2017 9:28 AM (in response to Andrea Gigliotti ) 
Re: Histogram  what is the goal?
Luiz DePaula Aug 17, 2017 10:57 AM (in response to Andrea Gigliotti )Hello guys,
The difference between histogram and bar chart is that bar chart uses the real number of the dimension, where histogram is used to measure the frequency of each number, and histogram separates the numbers into frequency buckets.
I am using right now to measure the moisture of samples out of production. So, let's say I perform 7 tests in a week. I will get numbers like 71%, 71%, 71%, 73%, 76%, 77%, 79%, and so on. I want to know the frequency in buckets of 3. So, the results are.
Buckets:
7173 = 4
7476= 1
7779= 2
So, instead of using the percentage numbers, the chart uses the frequency (4,1,2). Bar chart does have the logic to build certain chart. It serves to measure frequency of large sets of results for one specific field as measure.
I hope it helps.
LD

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 23, 2017 8:37 AM (in response to Luiz DePaula)could you please provide a sample qvf using an Histogram chart ?

Re: Histogram  what is the goal?
Luiz DePaula Aug 23, 2017 9:59 AM (in response to Andrea Gigliotti )Sure Andrea,
For example, I created a table with 20 employees and their ages. I want to know how spread out the ages are, in buckets of 5 years. So, the only dimension I use is Age, and nothing else. I know that the numbers in this dimension are the ages of the employees. Find table below and an image of the histogram. Also I attached the QVF. I hope it helps.
[Employee_Age]:
load * inline [
Employee_ID,Age
1,27
2,33
3,56
4,41
5,22
6,44
7,58
8,26
9,36
10,45
11,80
12,18
13,43
14,31
15,32
16,28
17,34
18,46
19,51
20,40
];
LD

Test Histogram.qvf 176.0 K




Re: Histogram  what is the goal?
Vlastimil Kosik Aug 24, 2017 9:13 AM (in response to Andrea Gigliotti )I would see a business case in any possible occasion when you would like to see distribution of something per some "measure".
Histogram allows you to create groups out of the numerical data based on "increasing logic" and then see the distribution of something else that is in your interest within those groups. For example, a Bell shaped histogram will indicated a normal distribution, etc..

Re: Histogram  what is the goal?
Andrea Gigliotti Aug 24, 2017 9:29 AM (in response to Vlastimil Kosik )yes but i think you can do the same using bar chart.

Re: Histogram  what is the goal?
Vlastimil Kosik Aug 24, 2017 9:41 AM (in response to Andrea Gigliotti )Yes, but that is not really the best practise from a statistical point of view. Simply said:
Bar charts: Group defined by a categorical variable (here is likely what we are looking for the total amount and usually the order is not important, sometimes we group it from Highest to Lowest.., sometimes alphabetically, but it is not necessary)
Histograms: Group defined by a numerical variable (Here what we are looking for is rather the skewness of the chart to see what kind of data distribution it is, Basically commenting on skewness on a bar chart is nonsense and every statistication would get mad if he saw that happen , data is usually ordinally because of a reason, also the groups are created to be equal based on math)
Histogram will automatically create the dimensions for you all you need to set up is for example the total number that you would like to see. (5 groups or 10.etc...)
There is no space between the barts so the distribution is easier to detect.
I mean... if you really wish, you can achieve basically the same with Bar Chart, yes, but you will have to work harder to do so and it will never be so neat due to the gaps between the bars.

