First time posting, looking forward to help from the experts, and this may a mix of math and Excel function question. I have 1.5 years of production weight data (estimated up to 90MM lines of data) that I queried the average weights per batch from an SQL table using external data through Excel. Each batch varies between 6,000 and 30,000 weights and there are 3008 batches. These batches are spread among 182 different 'flavors' and could be run across 11 different machines that will each have a slightly different weight pattern based on components of the batches and age, condition, etc. of the machines.
I have the averages for the 182 different flavors rolled up by batch numbers. I am trying to find the most accurate average by machine by flavor, so that would be using the average weight per batches, by flavor per machine. I know how averaging averages skews the results so does anyone have a suggestion on the best means of accomplishing this in Excel for the highest confidence? I don't have access to the granular level of how many units were run on each batch without extensive data mining. Any thoughts? Thank you!
I have the averages for the 182 different flavors rolled up by batch numbers. I am trying to find the most accurate average by machine by flavor, so that would be using the average weight per batches, by flavor per machine. I know how averaging averages skews the results so does anyone have a suggestion on the best means of accomplishing this in Excel for the highest confidence? I don't have access to the granular level of how many units were run on each batch without extensive data mining. Any thoughts? Thank you!