excel workshop i: introduction to excel › ... › 2018 › 2018_excel_workshop_i.pdfexcel workshop...

26

Upload: others

Post on 07-Jul-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 2: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 3: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 4: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 5: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

Here, the black arrow does not indicate a relative shift, but an absolute shift to row 3.

Page 6: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

Here, the black/gray arrows do not indicate relative shifts, but absolute shifts to column D.

Page 7: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 8: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 9: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 10: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 11: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 12: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 13: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 14: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 15: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 16: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 17: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 18: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 19: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 20: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 21: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 22: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM
Page 23: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

LRLA =∑ClaimsLA

∑PremiumLA=

∑ClaimsLABaseRate ⋅ ∑FactorLA

FactorLA Factor

Page 24: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

Let LRT be the target loss ratio. Then, multiplying our previous equation by LRT

LRLA,

LRLA ⋅LRT

LRLA=

∑ClaimsLABaseRate ⋅ ∑FactorLA

⋅LRT

LRLA

LRT =∑ClaimsLA

BaseRate ⋅LRLALRT

⋅ ∑FactorLA

Page 25: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

LRLA

LRT

LRLA =∑ClaimsLA

BaseRate ⋅ ∑FactorLA

LRT =∑ClaimsLA

BaseRate ⋅LRLALRT

⋅ ∑FactorLA

=∑ClaimsLA

BaseRate ⋅ ∑LRLALRT

⋅ FactorLA

LRLA

LRT

Page 26: Excel Workshop I: Introduction to Excel › ... › 2018 › 2018_Excel_Workshop_I.pdfExcel Workshop I: Introduction to Excel Author Kevin Zhu Created Date 11/7/2018 9:52:44 PM

LRLA =∑ClaimsLA

BaseRate ⋅ ∑FactorLA

LRT =∑ClaimsLA

BaseRate ⋅ ∑LRLALRT

⋅ FactorLA