Question
Create a PivotTable to show the 10 states in which the insurance companies are making the best ROI. Use a calculated field named BestInsROI(without the
Create a PivotTable to show the 10 states in which the insurance companies are making the best ROI.
Use a calculated field named "BestInsROI"(without the quotes) Hint: ROI is 1 minus the ratio of insurances losses to premiums. The ratio is calculated as Insurance companies losses divided by Car Insurance Premiums. Note that the Car Insurance Premiums ($) field contains the average premium for all customers in each state.
Display the values as a percentage with one decimal place.
Show the 10 states where insurance companies are making the best ROI.
Sort the PivotTable from largest to smallest.
Field Names: (State, Number of drivers involved per billion miles, Percent involved Who Were Speeding, Percent Involved Who Were Alcohol-Impaired, Percent Involved Who Were Not Distracted, Percent Involved With No Previous Accidents, car insurance premiums, insurance companies losses for collisions per insured driver)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting Principles
Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso
11th Edition
111856667X, 978-1118566671
