Actuarial Outpost
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > SoA/CAS Preliminary Exams > Exam PA: Predictive Analytics
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Thread Tools Search this Thread Display Modes
Old 06-22-2019, 05:38 PM
Relmiw Relmiw is offline
Join Date: Apr 2013
Posts: 201
Default Data Investigation / Cleaning in Excel

The first few modules stress data exploration and correction within R.
Do we have the ability to use Excel for this during the exam?
Do we have the ability to cite any Excel results in our formal report?

Thank you very much for any insight.
Reply With Quote
Old 06-23-2019, 11:00 PM
PinballWizard100 PinballWizard100 is offline
Join Date: Jan 2019
Posts: 34

Yes, you can use excel. I didn’t use it on the last exam, though, and it might be more difficult to communicate what you did to the graders. This exam is not just about what you do but also how well you can communicate what you did.
Reply With Quote
Old 06-24-2019, 12:22 PM
DjPim's Avatar
DjPim DjPim is offline
Join Date: Nov 2015
Location: SoCal
Posts: 698

Excel is available, but I would treat it as a last resort, panic-mode kind of thing. For one, Pinball mentioned the bonus of showing graders your work and coding ability. For another, in most cases it will take you extra time and increase margin for error. Try to get comfortable using only R. I suggest getting comfortable with dplyr package; functions work similar to SQL and have a logical order to them, which you can piece together using the pipe %>% function. For example:

data %>%
group_by(state, product) %>%
summarise(prem = mean(premium),
claim = mean(claims)) %>%
filter(product != "HMO")
Pretty easy to follow going in order, and pretty simple code. Filtering rows, selecting columns, and mutating (to change or create new variables) are among the most important for data exploration and correction IMO

ETA: The pipe function just means 'take everything from the left and use it as the first argument of the function on the right', so
a %>% fun(b)
is the same as fun(a,b)
Originally Posted by Dr T Non-Fan View Post
"Cali" SMH.
Reply With Quote
Old 06-30-2019, 05:28 PM
Relmiw Relmiw is offline
Join Date: Apr 2013
Posts: 201

Thank you both for your advice.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -4. The time now is 08:19 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.13627 seconds with 11 queries