avg or stdev of non-contiguous data

G

Guest

I have a spreadsheet (auto-output from Quickbooks) that contains sales data
for 5 different items. I want to calculate the average and standard
deviation of the sales quantity for each item and ship day (Product is
shipped three times a week, so I need to combine Mon & Tues sales data, and
Wed/Thur and Fri/Sat). In other words, I want the avg and stdev of all the
Mon & Tues orders for Item 1 through 5, same for all the Wed and Thur orders
etc.

I have a couple sumproduct formulas to calculate total sales for Mon/Tues
and number of data points so I can get the average, but I was wondering if
there is someway to get the stdev in a similar manner. The only thing I can
think of resorting the spreadsheet by Item and Weekday, and then manually
entering in "=Stdev('range')" for each item/ship day combination, but that
will be labor intensive. I'd rather solve the problem with a formula. Any
ideas?

TIA,
Marcotte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top