Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm

Hint for Assignment #4 (ETL and Pivot Tables)

I got quite some questions related to Part 4, Question (b) of Assignment #4, which asks you to create a pivot table first, and then use the excel AVERAGE function in a separate cell outside the pivot table.

Here is an example of what I mean by “use the Excel AVERAGE function to average those values … in a separate cell outside the Pivot Table.”

Link: Hint for HW4 – Part4Qb

Let me know if you have any questions.


Leave a Reply