Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
| Line 60: | Line 60: | ||
|- | |- | ||
|| '''Reserving-E''' | || '''Reserving-E''' | ||
| − | || S/S multiplicative <br> reinsurance net unpaid <br> ALAE additive/mult. <br> ULAE - classical/Kittel <br> ULAE - | + | || S/S multiplicative <br> reinsurance net unpaid <br> ALAE additive/mult. <br> ULAE - classical/Kittel <br> ULAE - Conger/Nolibos |
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_problems.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01'''</span>] | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_problems.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01'''</span>] | ||
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01-Solns'''</span>] | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01-Solns'''</span>] | ||
Revision as of 00:02, 4 October 2020
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 short notice about CBT, I'm still working on these.)
The TBE exams from 2018.Spring:
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
