correlation help

A pivot table would be helpful in this situation.
Make sure each of your columns has a heading e.g.
A1=Qty
B1=Weekday
C1=Date
D1 = Month

If your full dates are in Column C, create a formula in column D to determine the month e.g. D2 = MONTH(C2) or, if you want to be fancy, Text(C2,"MMMM")

Select all of the data, including the header row.

Click Data > PivotTable > Finish

To summarize qty by day of the week:

Drag the title "Weekday" to the area marked "Drop Row Fields Here"
Drag "Qty" to the area marked "Drop data items here."
If the top left of the pivot table reads "Count of ...", right click on that cell, and select Field settings and choose summarize by Sum.

You can also easily view the data as a chart by right-clicking on the pivot table and selecting "Pivot Chart."

Originally Posted by ChrisBbacon

Hi,

I have a column of numbers of items sold, and an adjacent column with days of the week (for 2 months)

Is there a formula to correlate these to find out e.g. if sundays are the worst days of the week for selling items


Similarly I have another adjacent column of dates (which i used to find the days of the week). Can I correlate months with items sold. i.e. what month is the best or worst for selling the items.



Cheers