Pivot tables are disabled on Prometric computers.
A lot of people get stumped on the ggplot formatting when first starting out. Fortunately, the SOA gives you template code to create all of the graphs that are needed. You can use Excel for inspecting the data, but just not with a pivot table. In R, just use write.csv(data, “data.csv”) to create a copy and then open it in Excel.
You can find save yourself time by only learning the R necessary for this exam. In Chapter 5 of our Spring 2021 Study Guide, there is an explanation.
Best regards,
Sam Castillo
Course Instructor at ExamPA.net