Hi I am lookng for some help with an average question,
I have a spreadsheet to work out lines and parts picked per minute and then
the average. The only problem i have is person a does less in more minutes
but his average works out more than person b an example
Lines Parts Minutes Ave Lines per min Ave Parts per min
47 63 435 15 12
67 67 315 8 8
Now the sum for ave per min is C2/A2/60*100 Format cell minus 2 decimal point
Just by looking at it person a has done less inmore time but averages twice
as much, what am i doing wrong?