Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring: | These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring: | ||
| − | : [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1_(questions_only).xlsm <span style="color: black; font-size: 12px; background-color: | + | : [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1_(questions_only).xlsm <span style="color: black; font-size: 12px; background-color: powderblue; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 1) - QUESTIONS ONLY'''</span>] |
| − | : [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1.xlsx <span style="color: black; font-size: 12px; background-color: | + | : [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1.xlsx <span style="color: black; font-size: 12px; background-color: powderblue; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 1)'''</span>] |
: [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <span style="color: black; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 2) - QUESTIONS ONLY'''</span>] | : [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <span style="color: black; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 2) - QUESTIONS ONLY'''</span>] | ||
Revision as of 00:11, 24 January 2021
These are the 3 most recent published exams for CAS Exam 5 converted into Excel format. See examiner's reports for solutions. You can download the examiner's report from the CAS website or use the Exam Summaries wiki article.
These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:
Due to the transition of CAS exams from paper/pencil to CBT for Fall 2020, I am creating problem sets in Excel and will provide links below. (Due to the compressed time frame and other events in 2020 and early 2021, I'm still working on these.)
BattleActs Practice Problems in Excel Format:
set problem types Version 01 Version 02 Version 03 Version 04 Reserving-A building triangles
development method
ECR method
BF method
CC methodReserving-A-01 Reserving-A-02 Reserving-A-03
Reserving-A-03-SolnsReserving-A-04
Reserving-A-04-SolnsReserving-B FS basic method
COS formula method
RBS methodReserving-B-01 Reserving-B-02 Reserving-B-03
Reserving-B-03-SolnsReserving-B-04
Reserving-B-04-SolnsReserving-C building triangles
development method
BF method (tort reform)
CC method (adjs)Reserving-C-01 Reserving-C-02 Reserving-C-03 Reserving-C-04 Reserving-D disposal rate method
PBS method
case O/S hard method
evaluationReserving-D-01 Reserving-D-02 Reserving-D-03
Reserving-D-03-SolnsReserving-D-04
Reserving-D-04-SolnsReserving-E S/S multiplicative
reinsurance net unpaid
ALAE additive/mult.
ULAE - classical/Kittel
ULAE - Conger/NolibosReserving-E-01 Reserving-E-02 Reserving-E-03
Reserving-E-03-SolnsReserving-E-04
Reserving-E-04-Solns
Excel Pricing Problems: Coming in January 2021. Until then, you can find Excel pricing problems in the recent CAS exams at the top of this page.
