topic Re: How do i group values and run on the groups descriptive statistic? in Discussions

How do i group values and run on the groups descriptive statistic?

Nataliia_bud — Sat, 27 Jan 2024 15:27:38 GMT

I have a table of MODIS. There is a column Confidence with the range from 1 to 100. I want to group it by low confidence 0-30, moderate confidence 31-60, high confidence 61-100 and run descriptive statistic on the groups. I have wrote the statement but all values disappeared and became a black dots.

How do i group columns right?

How do i bring back the data back instead of black dots?

Thank you.

Nataliia

Re: How do i group values and run on the groups descriptive statistic?

jthi — Sat, 27 Jan 2024 16:04:43 GMT

Where are you getting the confidence values from? It seems like you are referencing the Confidence column in your formula which calculates the confidence. You should separate these, calculate confidence and then have separate column for binning

Re: How do i group values and run on the groups descriptive statistic?

Nataliia_bud — Sat, 27 Jan 2024 22:43:28 GMT

I have already the values in the column Confidence, i just need to group them by the range. So i chose the column Confidence and run the statement on the column Confidence but it didn't work.

Here is the table in attach.

Thank you for helping.

Re: How do i group values and run on the groups descriptive statistic?

txnelson — Sun, 28 Jan 2024 04:08:21 GMT

Your Confidence column is numeric. Therefore, the whole column can contain only valid numeric values. When you run your formula, it the results you generate are character strings, "0-30" or "31-60" or "61-100". Because your column is defined as a numeric column, JMP will be forced to try and convert the resulting character string to numeric which will result in a missing value. What you need to do, is to create a new column, declare the column as a Character column, and then use your formula to calculate the values.

Re: How do i group values and run on the groups descriptive statistic?

Nataliia_bud — Mon, 29 Jan 2024 06:49:50 GMT

Thank you for explanation. I will try to do it.