Sorry for the vague subject header, but this problem is driving me crazy!!! . I'm trying to figure out the average volume distribution on a daily basis within a month as a percentage contribution. In other words, every Monday in August accounts for 5% of our volume for that month, every Tuesday accounts for 3.5%, every Saturday accounts for 1.5%, etc.

Here is the data that I have:

1)Days in month =31

2)Weeks in month =4.4

3)# of occurances for each day within month:

Mon, Sat, Sun = 5

Tue-Fri =4

4)% Contribution for each day within a normal week

Monday =21%

Tuesday =18%

Wednesday =17%

Thursday =16%

Friday =18%

Saturday =8%

Sunday =2%

5)Average Day contribution to week (day/days in week) =14.3%

6)Average Daily Contribution to month (day/days in month) =3.2%

How do i calculate the Daily contribution for each day over a month? Could anyone give me a hand?