Have you ever made a bar or column chart to represent some numerical data? I bet everyone has. And last but not least, the curve is the representation of the Gauss/Normal distribution (see ).Wikipedia defines a histogram in the following way: " Histogram is a graphical representation of the distribution of numerical data." Absolutely true, and… totally unclear :) Well, let's think about histograms in another way.Same thing for the standard deviation, you can use the 'STDEV' function of Excel.You can use the 'AVERAGE' function of Excel the Gauss mean value is also named 'Normal distribution mean value' and is in fact the classical mean/average of a set of values.Once you have loaded the scalar values, here are the informations you need:
If there are not too many points in the cloud you can import the point cloud in Excel as an ASCII file (the number of lines Excel can load depends on its version). To compute the same values as CloudCompare you will need the actual scalars values of the cloud (and not the histogram bins). But just with an simple image as a source, I can't get these mathematical facts I need.)Īh, generally people wants to export to Excel to do different things than CC, not the exact same thing ) (Basically, I am looking for some basic mathematical information behind the seen histograms because I'll likely show this data in a public presentation. functions but I need to know what data I'd use as an input if I used those Excel functions + What are the correct function syntaxes I should use in Excel. I know Excel has STDEV.S, AVERAGE, NORM.DIST etc.
What Excel functions and exported CSV data rows should I use in Excel to calculate/represent them the way CloudCompare does? I basically understand the meaning of all exported rows (Class, Value, Class start, Class end) but just can't get the math right. I'm especially interested in these three things.
There is some information missing, especially the Gauss Mean Value, Standard Deviation and grey-colored non-linear curve. I'm trying to create a similar histrogram in Excel as seen in CloudCompare ( Edit -> Scalar Fields -> Compute stat.params -> Distribution: Gauss).Įxcel histogram does not show exactly same data as seen in CloudCompare.
0 kommentar(er)
