This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Have had a good look through the archives, but not had any joy in working out how to solve the problem I am grappling with around trying to summarise a histrogram in a single string.
I have some leadtime information from production runs, and wish to present them (in another application) as a histogram. In order to do this, I need to summarise the leaditme information, and capture some key statistics. I have done this successfully, but am struggling to collate the information for a single product from across the rows of a final table. I suspect a macro (or macros) is the answer....
Images below show - I hope - the data for the three products that I am looking to summarise. The end table shows the key statistics for the three products, giving the number of 'bins' that the observations are placed in to, the size of the bins (the value range), and the average value of the observations in each of the bins (note, that not all bins have observations in them).
What I am looking to do is generate a single text stream that has:
Maximum Observation value
Minimum Observation value
Bin Range 1, start value, finish value
Bin Range 2, start value, finish value
Bin Range 1, % of observations
Bin Range 2, % of observations
and then express it something like: "ProductNN_MaxLT=XX_MinLT=YY_TotalObs=ZZ_FirstBinRange_SecondBinRange_First.....
Can you post what the actual string for Product NN would be? Your description "ProductNN_MaxLT=XX_MinLT=YY_TotalObs=ZZ_FirstBinRange_SecondBinRange_First...." is open to interpretation. For example, what is the FirstBinRange and SecondBinRange.
Product NN, Max value 15, Minimum value 1. Four observations, Bin 1 has a lower value of 1.00, Bin 2 a lower value of 1.4..... and after the ":", Bin 1 has 89% of the observations, Bin 2 has 0% of observations....
Product NN, Max value 15, Minimum value 1. Four observations, Bin 1 has a lower value of 1.00, Bin 2 a lower value of 4.5..... and after the ":", Bin 1 has 75% of the observations, Bin 2 has 0% of observations....
I realise that there is an error in the calculation of the average per bin, which I will try and create, but hopefully this corrects the confusion of what I am trying to achieve.
To your final question - the min and max values are the min and max value observations for 'NN', across all bins