jacquiejacuinde
New Member
- Joined
- Sep 27, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have data on revenues for 1 month but need to see what the average was for each day of the week ( M, TU, W, TH, F, SA, SU) and then plotting it against a moving average. How can I go about doing this? I am having a hard time coming up with the correct formulas
Here is some sample data fr=or one month:
Here is some sample data fr=or one month:
Tu | 1-Aug | 251.25 |
W | 2-Aug | 490 |
Th | 3-Aug | 572.5 |
F | 4-Aug | 878.75 |
Sa | 5-Aug | 893.75 |
Su | 6-Aug | 1182.5 |
M | 7-Aug | 447.5 |
Tu | 8-Aug | 236.25 |
W | 9-Aug | 330 |
Th | 10-Aug | 258.75 |
F | 11-Aug | 462.5 |
Sa | 12-Aug | 905 |
Su | 13-Aug | 411.25 |
M | 14-Aug | 160 |
Tu | 15-Aug | 195 |
W | 16-Aug | 442.5 |
Th | 17-Aug | 395 |
F | 18-Aug | 521.25 |
Sa | 19-Aug | 938.75 |
Su | 20-Aug | 155 |
M | 21-Aug | 137.5 |
Tu | 22-Aug | 283.75 |
W | 23-Aug | 273.75 |
Th | 24-Aug | 366.25 |
F | 25-Aug | 615 |
Sa | 26-Aug | 1912.5 |
Su | 27-Aug | 828.75 |
M | 28-Aug | 238.75 |
Tu | 29-Aug | 591.25 |
W | 30-Aug | 388.75 |
Th | 31-Aug | 375 |