Array Average not working right..

[black02ss]

I have this problem and I don't know why. I have enclosed a copy of my spreadsheet. When I run the MACRO "MAIN" from the Test Run 1 Sheet, it plots everything just fine, but the averages are wrong. It shows a average of 15.00 when it should be 14.63 for 99% of the cells... Any ideas on why this is happening??

Also, Is there a way that I can plot on the same table or another table that shows how many data points for the given field?? IE. 20 data points at map 50 rpm 800..

Thanks
Chad

[Killian]

Hi Chad,
this is just me being stupid..!
I declared the arrays as arrays of integers :doh:
You need to change them to singles to accept floating point numbers
In Sub AnalyzeData, change:


Dim arrVals(1 To 19, 1 To 20) As Integer 'array to hold accumalated values
Dim arrCount(1 To 19, 1 To 20) As Integer 'array to hold count of values
to


Dim arrVals(1 To 19, 1 To 20) As Single 'array to hold accumalated values
Dim arrCount(1 To 19, 1 To 20) As Single 'array to hold count of values

[black02ss]

You are the man K!! Now I just need to figure out how to get the data points for those values. :)