Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi
I'm working with some values that must appear to be random and should also appear to be random when applying statistical tests. Not being a statistics person myself I'm not sure what tests, if any, i can use. Searching on the 'net I found references to the chi square test but I'm not sure if that is suitable for my sample nor how to use it.
Can someone with a statistics background point me in the right direction? Following is a sample of some of my data - each string is 50 characters long and contains alphanumeric characters.
Sample:
If I analyse the frequency of characters in a sample of 75 strings of 50 characters each, I get frequency values ranging from 1.8% to 3.6% - the numbers given are the outliers, most values are between 2.3% and 3.2%. However I think I need to test the 'runs' but am not sure how.....
Thanks in advance for any pointers
Andrew
I'm working with some values that must appear to be random and should also appear to be random when applying statistical tests. Not being a statistics person myself I'm not sure what tests, if any, i can use. Searching on the 'net I found references to the chi square test but I'm not sure if that is suitable for my sample nor how to use it.
Can someone with a statistics background point me in the right direction? Following is a sample of some of my data - each string is 50 characters long and contains alphanumeric characters.
Sample:
Code:
DOXKBZ1LXITP18BV1CEKTG5BKTC6TACO6CVEHZ56I5ZMJVSIKL
UYYLL7AWYIZNJ75L6HXXLU6SK5Q3DRL0EGCS5SGYX5CR9SJXGG
684Q19PQOHBU2PMB7TSQNREEFWXJOROPQMN7YB7NT884MKUEIL
5KY0QQ9DKJ69B90QSHER0Q81M8CA0VJIXKQYS0UKP5TCCEQ954
If I analyse the frequency of characters in a sample of 75 strings of 50 characters each, I get frequency values ranging from 1.8% to 3.6% - the numbers given are the outliers, most values are between 2.3% and 3.2%. However I think I need to test the 'runs' but am not sure how.....
Thanks in advance for any pointers
Andrew