Question

In: Statistics and Probability

An insurance company’s database includes a variable, DAMAGE, that records, for each customer claim of automobile...

An insurance company’s database includes a variable, DAMAGE, that records, for each customer claim of automobile damage due to hail, the severity of the damage to the car. DAMAGE is recorded as 1 = minor damage, …, 5 = totaled. Also in the data table is DAY, the day of the week of the hail damage (Monday, Tuesday, …). One of the following graphs is an appropriate way to display the association between DAMAGE and DAY. Which one?

a. Cross-tabulation

b. Scatterplot

c. Side-by-side boxplots

Solutions

Expert Solution

Variable 1: DAMAGE is recoras ded as 1 = minor damage, …, 5 = totaled.

Variable 2: The day of the week of the hail damage (Monday, Tuesday, …)

Now, there are two variables and to understand the correlation between different variables. Both the variables are categorical variables as there is order in the values. For ex. Value 1 to 5 in damage according to damage amount and type of accident

Here, we can use cross tabulation method as this method analyse relationship between multiple variables.


Related Solutions

An insurance company’s database includes a variable, DAMAGE, that records, for each customer claim of automobile...
An insurance company’s database includes a variable, DAMAGE, that records, for each customer claim of automobile damage due to hail, the severity of the damage to the car. DAMAGE is recorded as 1 = minor damage, …, 5 = totaled. One of the following graphs is an appropriate way to display the DAMAGE variable. Which one? a. Time-series plot b. Boxplot c. Pie chart
The owner of an automobile insures it against damage by purchasing an insurance policy with a...
The owner of an automobile insures it against damage by purchasing an insurance policy with a deductible of 250. In the event that the automobile is damaged, repair costs can be modeled by a uniform random variable on the interval (0, 1500) In the above question, I am asked to find Var(Y) where Y = (X - 250). The solution actually involves finding E(Y) and E(Y^2) through intergration, then Var(Y) = E(Y^2) - E(Y)^2. I understand the solution. My question...
Consider the automobile insurance company database we use for examples in class. For each problem, write...
Consider the automobile insurance company database we use for examples in class. For each problem, write an SQL statement to retrieve the specified data. For each accident that occurred in 2005, the names of drivers involved and the make and year of the auto they were driving. The name and ssn of automobile owners who have never been the driver in any accident. The name and ssn of people involved in accidents while driving a car they do not own....
Houston Company’s balance sheet includes the amounts shown below. Analysis of the company’s records reveals the...
Houston Company’s balance sheet includes the amounts shown below. Analysis of the company’s records reveals the following transactions during 2019, the company’s first year of operations: Cash received from customers, recorded as service revenue $217,650 Purchase of supplies for cash, expensed        $ 19,000 Cash paid for salaries, expensed         $ 85,400 At year-end, supplies on hand total $5,300, employees have earned $8,000 but have not yet been paid, and on the last day of the fiscal year, customers paid deposits...
In the automobile insurance industry, deductibles are meant to decrease the moral hazard associated with a claim.
In the automobile insurance industry, deductibles are meant to decrease the moral hazard associated with a claim.TrueFalse
Suppose the national average dollar amount for an automobile insurance claim is $565.412. You work for...
Suppose the national average dollar amount for an automobile insurance claim is $565.412. You work for an agency in Michigan and you are interested in whether or not the state average is less than the national average. The hypotheses for this scenario are as follows: Null Hypothesis: μ ≥ 565.412, Alternative Hypothesis: μ < 565.412. A random sample of 46 claims shows an average amount of $582.985 with a standard deviation of $91.4882. What is the test statistic and p-value...
Suppose the national average dollar amount for an automobile insurance claim is $890.34. You work for...
Suppose the national average dollar amount for an automobile insurance claim is $890.34. You work for an agency in Michigan and you are interested in whether or not the state average is greater than the national average. The hypotheses for this scenario are as follows: Null Hypothesis: μ ≤ 890.34, Alternative Hypothesis: μ > 890.34. You take a random sample of claims and calculate a p-value of 0.2844 based on the data, what is the appropriate conclusion? Conclude at the...
An automobile insurance company predicts that 15% of policy holders file a claim within the next...
An automobile insurance company predicts that 15% of policy holders file a claim within the next year. Since this company has many policy holders, we may assume that filing a claim is independent between policy holders. a. If 15 policy holders are randomly selected, what is the probability that exactly two will file a claim within the next year? What calculator command and inputs did you use? b. If 15 policy holders are randomly selected, what is the probability that...
An automobile insurance company predicts that 15% of policy holders file a claim within the next...
An automobile insurance company predicts that 15% of policy holders file a claim within the next (8pt) year. Since this company has many policy holders, we may assume that filing a claim is independent between policy holders. a. If 15 policy holders are randomly selected, what is the probability that exactly two will file a claim within the next year? What calculator command and inputs did you use?
An automobile insurance company predicts that 15% of policy holders file a claim within the next...
An automobile insurance company predicts that 15% of policy holders file a claim within the next (8pt) year. Since this company has many policy holders, we may assume that filing a claim is independent between policy holders. a. If 15 policy holders are randomly selected, what is the probability that exactly two will file a claim within the next year? What calculator command and inputs did you use? b. If 15 policy holders are randomly selected, what is the probability...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT