Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


Reply
 
Thread Tools Display Modes
  #41  
Old 12-19-2014, 04:37 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

There's lots of different choices.

I have this text:
http://www.wiley.com/WileyCDA/WileyT...470944889.html

Chapter 3 is all about how to choose. The author of the text primarily uses R.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #42  
Old 12-19-2014, 04:39 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

Want to mention -- you can download code from the text at the link I posted.

There is R, Python, and Flash. and Excel.

(DON'T USE FLASH)
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #43  
Old 12-21-2014, 02:22 AM
SpaceActuary's Avatar
SpaceActuary SpaceActuary is offline
Member
 
Join Date: Apr 2010
College: Drake U
Posts: 599
Default

Quote:
Originally Posted by prankius View Post
Hey does anyone know what software could be used to make such data visualizations? Seems like a lot of these are custom-built one-off graphs. I wonder if it would be possible to basically incorporate an "over-time" component to Excel...
I'd add d3.js to Mary Pat's list.

For adding an "over-time" component to Excel, it's possible, but it's not as pretty as in something that you could do in d3.js or R.

If you're interested in having an animated graph, you set up your graph data as a function of time (e.g. if the dimension you want to animate is in columns, you could use index / vlookup to grab whichever column you need for that point in time ("frame").

Then you could add some code like this:
Spoiler:
Code:
Sub Animate()

    If Range("Frame").Value = Range("StopFrame").Value Then
        Range("Frame").Value = Range("StartFrame").Value
    Else
        Range("Frame").Value = Range("Frame").Value + 1
    End If
    
    If Range("RunAnimation").Value = "Yes" Then
        Application.OnTime Now() + TimeValue("00:00:01"), "Animate"
    End If

End Sub
which increments the "frame" by one, then calls itself one second from now.

Note that the code above requires some named ranges:
- "Frame": the current timestop or "t"
- "StartFrame" and "StopFrame": the lowest and highest values of "t"
- "RunAnimation": controls the animation. I set this up as a cell with data validation (List=Yes,No).

Hope that helps. I think animation is one of the most effective ways to present a dimension of data, and sorely underused since it's so hard using the most common toolsets (e.g. Excel).
__________________
And all this science, I don't understand; It's just my job five days a week...a rocket man, a rocket man...

"I'm from Iowa. I only work in space." - Adm. James T. Kirk
Reply With Quote
  #44  
Old 12-21-2014, 08:55 AM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

Yeah, I've had some animations I've wanted to make - specifically the change of a specific distribution over time
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #45  
Old 12-24-2014, 03:25 AM
prankius prankius is offline
Member
Non-Actuary
 
Join Date: Dec 2014
Location: Chicago
College: UIC '12
Favorite beer: Svyturio Baltas
Posts: 45
Default

Quote:
Originally Posted by campbell View Post
There's lots of different choices.

I have this text:
http://www.wiley.com/WileyCDA/WileyT...470944889.html

Chapter 3 is all about how to choose. The author of the text primarily uses R.
Quote:
Originally Posted by campbell View Post
Want to mention -- you can download code from the text at the link I posted.

There is R, Python, and Flash. and Excel.

(DON'T USE FLASH)
Hey thanks for the info! Great to know, since I already have some experience with R and Python. But I think I'll try maximizing Excel's capabilities first. This should be fun.
Reply With Quote
  #46  
Old 12-24-2014, 03:26 AM
prankius prankius is offline
Member
Non-Actuary
 
Join Date: Dec 2014
Location: Chicago
College: UIC '12
Favorite beer: Svyturio Baltas
Posts: 45
Default

Quote:
Originally Posted by SpaceActuary View Post
I'd add d3.js to Mary Pat's list.

For adding an "over-time" component to Excel, it's possible, but it's not as pretty as in something that you could do in d3.js or R.

If you're interested in having an animated graph, you set up your graph data as a function of time (e.g. if the dimension you want to animate is in columns, you could use index / vlookup to grab whichever column you need for that point in time ("frame").

Then you could add some code like this:
Spoiler:
Code:
Sub Animate()

    If Range("Frame").Value = Range("StopFrame").Value Then
        Range("Frame").Value = Range("StartFrame").Value
    Else
        Range("Frame").Value = Range("Frame").Value + 1
    End If
    
    If Range("RunAnimation").Value = "Yes" Then
        Application.OnTime Now() + TimeValue("00:00:01"), "Animate"
    End If

End Sub
which increments the "frame" by one, then calls itself one second from now.

Note that the code above requires some named ranges:
- "Frame": the current timestop or "t"
- "StartFrame" and "StopFrame": the lowest and highest values of "t"
- "RunAnimation": controls the animation. I set this up as a cell with data validation (List=Yes,No).

Hope that helps. I think animation is one of the most effective ways to present a dimension of data, and sorely underused since it's so hard using the most common toolsets (e.g. Excel).
Oh wow this is awesome! I never really used timevalue in any of my VBA scripts. This creates so many new possibilities. Thanks!
Reply With Quote
  #47  
Old 05-31-2015, 10:30 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

gallery of excel charts

https://sites.google.com/site/e90e50charts/


some are really awful
some are good
all have downloadable workbooks with them
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #48  
Old 08-18-2015, 04:19 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

Guess that software/language/interface!

http://www.datasciencecentral.com/pr...r-excel-matlab

Quote:
Here we ask you to identify which tool was used to produce the following 18 charts: 4 were done with R, 3 with SPSS, 5 with Excel, 2 with Tableau, 1 with Matlab, 1 with Python, 1 with SAS, and 1 with JavaScript. The solution, including for each chart a link to the webpage where it is explained in detail (many times with source code included) can be found here. You need to be a DSC member to access the page with the solution: you can sign-up here.
I'm pretty sure I recognized the R & Excel ones.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #49  
Old 08-18-2015, 05:39 PM
whoanonstop's Avatar
whoanonstop whoanonstop is offline
Member
Non-Actuary
 
Join Date: Aug 2013
Location: Los Angeles, CA
Studying for Spark / Scala
College: College of William and Mary
Favorite beer: Orange Juice
Posts: 5,567
Blog Entries: 1
Default

First of all, I've never noticed this thread until now. I think it even talks about some of the ideas of "scraping" the SOA database before I did it, lol.

Quote:
Originally Posted by campbell View Post
Guess that software/language/interface!

http://www.datasciencecentral.com/pr...r-excel-matlab



I'm pretty sure I recognized the R & Excel ones.
As for this, SAS/SPSS were the only ones I couldn't sort out.

I might share some of my d3.js stuff here. =D

-Riley
__________________
It is impossible to have a professional forum where the majority of your professionals are anonymous.

Map of Actuarial Hiring Companies
Reply With Quote
  #50  
Old 10-04-2015, 03:16 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,406
Blog Entries: 6
Default

Been playing with Tableau Public

Here's an example of something somebody did with it:

https://public.tableau.com/s/blog/20...tableau-public

Quote:
Tuesday, October 20
Tableau Keynote: Developers on Stage
The Visual Design Tips Behind Great Dashboards
Self-Service Analytics with Tableau Server
Tips and Strategies for Taking Your Data to the Cloud
Becoming a Mix Master with Data Blending

Wednesday, October 21
Stories from Project Elastic
Understanding LOD Expressions
The Beautiful Science of Data Visualization
Forecasting with Tableau

Thursday, October 22
Tableau Tips for Beginners
Iron Viz Championship
Tips to Becoming a Tableau Jedi
it's in Vegas, so it's only on the first session right now.
__________________
It's STUMP

LinkedIn Profile

Last edited by campbell; 10-20-2015 at 01:44 PM..
Reply With Quote
Reply

Tags
data science, predictive analytics

Thread Tools
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:05 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, 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.18276 seconds with 10 queries