Question

In: Statistics and Probability

*** Please solve in R *** You’re a newly hired analyst in Patriot Insurance Co. Your...

*** Please solve in R ***

You’re a newly hired analyst in Patriot Insurance Co. Your boss just asked to assess the relationship (if there is any) of the number of claims filed and length of time a policyholder hold his or her policy. You’ve randomly selected data on 20 policy holders: number of claims and length of time (in years) the policy holders held their policies. See “Prob 11-1 claims data.csv” for the data.

You decide that a Poisson distribution is a reasonable first choice as a data generating process that could have produced the counts of claims. Perform a Poisson regression to analyze the data; report your findings.

Claims Years
1 1.024733
2 2.696719
3 3.626263
2 4.948643
4 6.024718
8 6.254113
1 6.526594
4 7.108674
5 9.215436
7 9.683853
3 9.85961
6 10.90103
9 11.35428
4 13.24533
6 13.38556
7 14.65962
13 15.61379
14 16.1935
10 18.62843
16 18.71313

Solutions

Expert Solution

Poisson Regression Analysis: Years versus Claims

Method

Link function Natural log
Rows used 20

Deviance Table

Source DF Adj Dev Adj Mean Chi-Square P-Value
Regression 1 31.61 31.607 31.61 0.000
Claims 1 31.61 31.607 31.61 0.000
Error 18 25.59 1.422
Total 19 57.20

Model Summary

Deviance
R-Sq
Deviance
R-Sq(adj)
AIC
55.26% 53.51% 109.13

Coefficients

Term Coef SE Coef VIF
Constant 1.684 0.139
Claims 0.0869 0.0150 1.00

Regression Equation

Years = exp(Y')
Y' = 1.684 + 0.0869 Claims

Goodness-of-Fit Tests

Test DF Estimate Mean Chi-Square P-Value
Deviance 18 25.59001 1.42167 25.59 0.110
Pearson 18 23.87999 1.32667 23.88 0.159

The hypothesis being tested is:

H0: The data is of a Poisson distribution

Ha: The data is not of a Poisson distribution

The p-value is 0.159.

Since the p-value (0.159) is greater than the significance level (0.05), we fail to reject the null hypothesis.

Therefore, we can conclude that the data is of a Poisson distribution.


Related Solutions

You are a newly hired analyst at a top company Your starting salary is $80,000 year...
You are a newly hired analyst at a top company Your starting salary is $80,000 year You are attempting to save about 10% of your income You have the following options for savings and investment. A Company 401K Plan that matches the first 6% Pretax Contributions at a 50% Match rate Your own Individual Retirement Account (IRA) with a balance of $5,500. Your own Roth IRA with a balance of $1,250. Your brokerage account with a balance of $2,500 how...
Assume that you are a newly hired treasury analyst that is tasked with improving the liquidity...
Assume that you are a newly hired treasury analyst that is tasked with improving the liquidity position and overall financial management of Firm Y. Firm Y was incorporated 10 years ago and operates in the manufacturing industry. To begin your new position, you have been tasked with benchmarking Firm Y’s liquidity position. In terms of the key performance indicators to benchmark, your treasurer states that the “Current and quick ratios provide the best measures of our firm’s overall state of...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and Poor’s. The first day on the job you are asked to rate the following bonds: a. The bonds of an Internet start-up company b. The bonds of a country with a history of inflation and political instability c. The bonds of company operating a network of toll highways d. The bonds of a company with a long illustrious history that has fallen on hard...
Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first...
Congratulations, you have been hired as an analyst at the Procter and Gamble Co. (PG).  Your first assignment is to estimate the appropriate rate that a new 30-year bond would need in order to be issued competitively to the public.  It is April 1, 2020 (ignore actual current market rates).  PG just made a coupon payment (semi-annual) on its "8% 2045" bonds that mature on April 1, 2045. The bonds currently sell for 104 with a par value of 100.  Kimberly-Clark Corp. (KMB) has...
Discuss how to use R programming to solve the following problem. You’re not just writing the...
Discuss how to use R programming to solve the following problem. You’re not just writing the R code, you are also discussing the process. Given a person’s full name in the format of firstName middleName lastName such as Michael Carlos Dumas, write R code(s) to convert it to the format of lastName, middleInitial, firstName. In the case of Michael Carlos Dumas, the converted name is Dumas, C. Michael. Your solution should work with any names that comply with the format....
You are a newly hired financial analyst with Gold Coast Water Company (GCWC), a company operating...
You are a newly hired financial analyst with Gold Coast Water Company (GCWC), a company operating in Queensland, which specialises in bottling purified water sourced from Tambourine Mountains springs. GCWC is considering adding to its product mix a 'healthy' bottled water geared towards children, aimed at improving both its business focus and the return to shareholders. Scenario GCWC currently has 30,000,000 ordinary shares outstanding that trade at a price of $35 per share. GCWC also has 400,000 bonds outstanding that...
Please type your answer You are a nurse manager hired for a newly created 45-bed oncology...
Please type your answer You are a nurse manager hired for a newly created 45-bed oncology unit. Chemotherapy is to be administered by the registered nurses (RNs) who work on the unit. The expected ADC is 40. The clients admitted to the oncology unit have complex health care needs. Address these questions: 1: What factors should be considered when determining the staffing needs of the unit? Why are these factors important? 2: What process should you use to establish the...
please type your answer You are a nurse manager hired for a newly created 45-bed oncology...
please type your answer You are a nurse manager hired for a newly created 45-bed oncology unit. Chemotherapy is to be administered by the registered nurses (RNs) who work on the unit. The expected ADC is 40. The clients admitted to the oncology unit have complex health care needs. Address these questions: 2: What process should you use to establish the staffing needs of the oncology unit? What are the steps of this process? 3: Should variable or fixed staffing...
Task #2: Tomewin Water Company Role and Context You are a newly-hired financial analyst with Tomewin...
Task #2: Tomewin Water Company Role and Context You are a newly-hired financial analyst with Tomewin Water Company (TWC), a company operating in most states of Australia, which specialises in bottling purified water sourced from Tweed Valley springs. TWC is considering adding to its product mix a ‘healthy’ bottled water geared towards children, aimed at improving both its business focus and the return to shareholders. Scenario TWC currently has 30,000,000 ordinary shares outstanding that trade at a price of $41...
Please give me examples on innovative solutions to solve as a internal control analyst? Please be...
Please give me examples on innovative solutions to solve as a internal control analyst? Please be detailed?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT