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

DW Simpson Global Actuarial & Analytics Recruitment
Download our Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-22-2019, 04:38 PM
Relmiw Relmiw is offline
Member
CAS
 
Join Date: Apr 2013
Posts: 171
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
  #2  
Old 06-23-2019, 10:00 PM
PinballWizard100 PinballWizard100 is offline
SOA
 
Join Date: Jan 2019
Posts: 24
Default

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
  #3  
Old 06-24-2019, 11:22 AM
DjPim's Avatar
DjPim DjPim is online now
Member
SOA
 
Join Date: Nov 2015
Location: SoCal
Posts: 503
Default

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:

Quote:
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)
__________________
Quote:
Originally Posted by Dr T Non-Fan View Post
"Cali" SMH.
Reply With Quote
  #4  
Old 06-30-2019, 04:28 PM
Relmiw Relmiw is offline
Member
CAS
 
Join Date: Apr 2013
Posts: 171
Default

Thank you both for your advice.
Reply With Quote
Reply

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 04:59 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.24490 seconds with 11 queries