![]() ![]() If you have daily data to aggregate into weekly or monthly data, you can accomplish that easily in Microsoft Excel, thanks to pivot tables. Just select any other time unit you like instead of days. NOTE: The method to create by MONTHS (or any other time period listed in the GROUPING screen) is the same. (5) Click OK to create your aggregate table for WEEKS: In the GROUPING dialog box select DAYS and “7” in the NUMBER OF DAYS drop-down list: (4) Now, select any of the days and right-click. Your Pivot Table will be created automatically: (3) Click DATA to insert it in the VALUES quadrant of the Pivot Table and click DAYS to insert it in the ROWS quadrant. (2) In the Create Pivot Table dialog box, select Existing Worksheet and then click on a cell for insertion point: ![]() Let’s say this is what your daily data looks like: With that precautionary note, here is how you can accomplish this procedure. However, if for example your data is “average temperature per day,” then it of course does not make sense to aggregate such data since the temperature for a week is not the aggregate sum of daily temperatures but their arithmetic mean. You can apply this method to, for example, a data of “trucks arrived” or “shirts bought” per day since the total aggregate amounts would still make sense for longer time units. If you have daily data that still makes sense when aggregated into weekly or monthly data, then you can accomplish that very easily in Microsoft Excel, thanks to the pivot table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |