Return to Question

##INTRO

Is returning the total number of records in column F1 that are equal to searchKey and dividing that number by the total number of records in column F1. ##CODE

##Results

INTRO

Is returning the total number of records in column F1 that are equal to searchKey and dividing that number by the total number of records in column F1.

CODE

Results

EDIT: THIS SHOULD BE % NOT MANY

Variable 1 Occured 4.9837112427 Many Times
Variable 2 Occured 5.0171852112 Many Times
Variable 3 Occured 4.9752235413 Many Times
Variable 4 Occured 4.9716949463 Many Times
Variable 5 Occured 5.0051689148 Many Times
Variable 6 Occured 4.9989700317 Many Times
Variable 7 Occured 4.9901008606 Many Times
Variable 8 Occured 5.0283432007 Many Times
Variable 9 Occured 5.0018310547 Many Times
Variable 10 Occured 5.0164222717 Many Times
Variable 11 Occured 4.9933433533 Many Times
Variable 12 Occured 5.0059318542 Many Times
Variable 13 Occured 5.0333976746 Many Times
Variable 14 Occured 4.9952507019 Many Times
Variable 15 Occured 5.0163269043 Many Times
Variable 16 Occured 4.9654006958 Many Times
Variable 17 Occured 4.9822807312 Many Times
Variable 18 Occured 5.0310134888 Many Times
Variable 19 Occured 5.0113677979 Many Times
Variable 20 Occured 4.9770355225 Many Times
QUERIES RAN IN 38.754 SECONDS

EDIT: THIS SHOULD BE % NOT MANY -- FIXED

Variable 1 Occured 4.9837112427 % Of Time
Variable 2 Occured 5.0171852112 % Of Time
Variable 3 Occured 4.9752235413 % Of Time
Variable 4 Occured 4.9716949463 % Of Time
Variable 5 Occured 5.0051689148 % Of Time
Variable 6 Occured 4.9989700317 % Of Time
Variable 7 Occured 4.9901008606 % Of Time
Variable 8 Occured 5.0283432007 % Of Time
Variable 9 Occured 5.0018310547 % Of Time
Variable 10 Occured 5.0164222717 % Of Time
Variable 11 Occured 4.9933433533 % Of Time
Variable 12 Occured 5.0059318542 % Of Time
Variable 13 Occured 5.0333976746 % Of Time
Variable 14 Occured 4.9952507019 % Of Time
Variable 15 Occured 5.0163269043 % Of Time
Variable 16 Occured 4.9654006958 % Of Time
Variable 17 Occured 4.9822807312 % Of Time
Variable 18 Occured 5.0310134888 % Of Time
Variable 19 Occured 5.0113677979 % Of Time
Variable 20 Occured 4.9770355225 % Of Time
QUERIES RAN IN 38.754 SECONDS

EDIT: it should not say MANY times rather % of times

##CODE

EDIT: it should not say % in results not many times. I am getting the % of times each var occurred in my data set. I am basically seeing what the distribution is of randbetween(1-20) outputs are over X calls. In this instance x is 1,048,576.

My SQL Query

"SELECT Round(SUM(IIF([F1]=" & searchKey & ",1,0))*100.0/SUM(IIF([F1]<> Null,1,0)),10) From [Sheet1$];"

Is returning the total number of records in column F1 that are equal to searchKey and dividing that number by the total number of records in column F1. ##CODE