A new product will be added to your cart each time you click the Product button.
If additional options exist (checkboxes) to further customize your product and you'd like to choose one of the them, please select the option before clicking the product button to add to your cart.
Click here to edit your cart.
All prices shown in USD | Click here to view our digital terms
Introduction to Predictive Analytics Using Excel
Predictive Analytics is all the rage in the actuarial (and larger) world but what are they? Learn about the core models and concepts of Predictive Analytics and Modeling in this webcast, using a very familiar tool.
One barrier people often have in learning about Predictive Analytics is that they find they need to learn new software and programming languages to effectively implement these techniques. Unfortunately, many then spend a great deal of time having to learn new systems and not as much time understanding how the models work (and where they fail) until much later.
To provide an introduction to Predictive Analytics and Modeling, all examples will be implemented in Excel. While Excel is far from the best tool for implementation of these techniques for practical business uses, by using a familiar tool, you will be able to learn the concepts better and get a better feel for how these models behave. You can then determine for yourself if it will be worthwhile to invest more time and effort to go farther in this field.
Sampling of Predictive Modeling approaches to be covered:
- Regressions—linear, logistic, and generalized approaches
- Clustering
- Decision trees
- Evaluation of these models
Participants will receive the spreadsheets used in the webcast following the session so they can try out the models for themselves.
Who Should Attend:
Actuaries and non-actuaries who are interested in understanding the different approaches to predictive analytics, and who are more comfortable with using Excel than R or Python.
About Your Instructor
Mary Pat Campbell, FSA, MAAA, PRM
Mary Pat Campbell, is Vice President of Insurance Research at Conning in Hartford, Connecticut. In the past, she also taught courses on computing (Excel, Access, and VBA) and business writing for actuarial science students at the University of Connecticut. Mary Pat has had a long interest in spreadsheet best practices in actuarial work, writing for SOA publications on the topic since 2007. She has also spoken for SOA webcasts and at meetings on spreadsheet issues, such as at the 2015 SOA Annual Meeting: "Session 30: How to Keep Your Spreadsheets Out of the Headlines". Over the past two years, she has written a series of 5 articles on data visualization for CompAct, the newsletter of the SOA Technology Section. She is a member of the European Spreadsheet Risks Interest Group and on the SOA Modeling Section Council (2015 - 2018).
Corporate Customers:
- 10+ participants & 1 connection option: live simulcast via an internal screen-sharing utility.
- 10+ participants & multi-connection option: each associate receives login credentials to access the live event and the recording.
- ACTEX will provide a self-registration site and activation key for your participants. The first 100 will be enrolled in the webinar. This makes it easy to offer continuing professional development opportunities without the need for administrative attention.
- As a reminder, it is a violation of ACTEX Learning Terms of Service to record webinars for rebroadcast. Please respect our intellectual property.
Important CPD Information:
Recorded ACTEX Webinars do not qualify for EA credit under the guidelines of the JBEA. ACTEX Webinars are strictly for educational purposes and cannot be submitted to attest for EA core or non-core credit.