I am a first time user. I am grateful that you there is a place in the world for people like us, the excel misfits.
I am working on a case and need your help. I need to count the number of occurences of each category, i.e. between 0 and -1, 0 and -2, 0 and -3, 0 and 1, 0 and 2, 0 and 3 of the following data:
-2.01646833
-1.614184032
-0.458823528
0.422983654
0.91216136
-1.041331191
-1.203854048
1.155141077
-0.954437783
-0.4749149
1.705465996
1.785922856
-0.8643261
-0.688930146
-0.450777842
0.067364334
-0.22228036
-0.391239766
-0.460432665
-0.328483415
1.068247668
-1.137879423
0.138166371
-0.312392043
-0.770996143
0.11563845
0.524359297
0.571024276
1.579953295
1.089166452
1.924308655
0.775384699
0.884806028
-0.463650939
-0.626173796
0.699755251
0.886415165
1.122958333
0.336090245
-0.569853994
-0.927082451
0.046445551
0.178394801
-2.011640919
I will be using 6 different columns to capture each segment. Can you help?
Thank you.
I am working on a case and need your help. I need to count the number of occurences of each category, i.e. between 0 and -1, 0 and -2, 0 and -3, 0 and 1, 0 and 2, 0 and 3 of the following data:
-2.01646833
-1.614184032
-0.458823528
0.422983654
0.91216136
-1.041331191
-1.203854048
1.155141077
-0.954437783
-0.4749149
1.705465996
1.785922856
-0.8643261
-0.688930146
-0.450777842
0.067364334
-0.22228036
-0.391239766
-0.460432665
-0.328483415
1.068247668
-1.137879423
0.138166371
-0.312392043
-0.770996143
0.11563845
0.524359297
0.571024276
1.579953295
1.089166452
1.924308655
0.775384699
0.884806028
-0.463650939
-0.626173796
0.699755251
0.886415165
1.122958333
0.336090245
-0.569853994
-0.927082451
0.046445551
0.178394801
-2.011640919
I will be using 6 different columns to capture each segment. Can you help?
Thank you.