Download the data here: ExcelAssignmentData.zip. That is a zip file with a folder for each student; use the folder with your EID as its name. Load each file into the tab of an Excel worksheet.
1. Use the INDEX MATCH procedure to join the user_type with the log data. Use the IF statement to include "user" as the user_type for users who are not managers or volunteers. This follows the procedure provided in the ExcelQueries.pdf You will have to edit the formula to correspond to the names you give your tabs, find the right cells, and remove a space that makes "user" show up as "use r".
2. Create a pivot table on a new tab that summarizes posts by managers, volunteers, and regular users by month. You should include the event_type in a filter, so that one can include or exclude post or create account events and have the pivot table recalculate.
3. Create a time series graph of managers, volunteers, and regular users posts over time. This one will have three lines on one graph.
4. Create a time series of "create account" events over time. This one will have a single line on one graph.
Submit your excel sheet showing five tabs: log_data, user_types, pivot table, graph 1 and graph 2.