For Outside Activity $2,$ create pivot tables from the closed claim data set $($in D$2$L

as $$ClosedClaimData$\_$Input$)$ to answer the following questions:

$$ Which line of business has the costliest average claims? How much?

$$ Which state has the most expensive average general liability claims? How

much?

$$ Which state has the least expensive average work comp claims? How much?

$$ Which state has the highest percentage of litigated claims? What$$s the

number?

$$ Given the cost of claims, which state would you stay away from and why?

Support your answers with data. Submit your assignment as a Word document in

complete sentences that answer each question along with Excel screenshots to

support your points. Be careful not to just $$plug and chug$$ but think about the

data and what$$s being asked