Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I fix prior submission section? Create a PivotTable to show the 1 0 states in which the insurance companies are making the best

How do I fix prior submission section?
Create a PivotTable to show the 10 states in which the insurance companies are making the best ROI.
Place the PivotTable on the BestROI worksheet.
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.
15
Prior submission results:
[-3] The Values fields for the BestROI PivotTable does not contain BestInsROI
[-undefined] Full Credit
[-undefined] Full Credit
[-3.5] The PivotTable is not showing the correct set of states.
[-4.5] The BestROI PivotTable does not contain the correct values
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions