ELEMENTARY STATISTICS USING EXCEL
ELEMENTARY STATISTICS USING EXCEL
7th Edition
ISBN: 9780136921721
Author: Triola
Publisher: RENT PEARS
Students have asked these similar questions
Let X represent the full height of a certain species of tree. Assume that X has a normal probability distribution with mean 203.8 ft and standard deviation 43.8 ft. You intend to measure a random sample of n = 211trees. The bell curve below represents the distribution of these sample means. The scale on the horizontal axis (each tick mark) is one standard error of the sampling distribution. Complete the indicated boxes, correct to two decimal places. Image attached. I filled in the yellow boxes and am not sure why they are wrong. There are 3 yellow boxes filled in with values 206.82;  209.84;   212.86.
Could you please answer this question using excel.Thanks
Questions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax