Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
| Line 53: | Line 53: | ||
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-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-D-01'''</span>] | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-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-D-01'''</span>] | ||
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-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-D-01-Solns'''</span>] | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-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-D-01-Solns'''</span>] | ||
| − | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)- | + | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-02_problems_v02.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-D-02'''</span>] |
| − | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)- | + | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-02_solutions_v02.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-D-02-Solns'''</span>] |
||Reserving-D-03 <br> Reserving-D-03-Solns | ||Reserving-D-03 <br> Reserving-D-03-Solns | ||
||Reserving-D-04 <br> Reserving-D-04-Solns | ||Reserving-D-04 <br> Reserving-D-04-Solns | ||
Revision as of 00:35, 18 November 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
