Requirements

To follow are the requirements for analyzing sales records in the data set.

1. There are some typographical errors in the data set in the Region and Insurance Type fields. Find

and correct these errors.

2. Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the

data by sales, from highest to lowest.

a.

Which state had the highest sales? What was the total dollar amount?

b. Which state had the lowest sales? What was the total dollar amount?

c.

What is the average amount of insurance sold per state?

d. How many insurance policies were sold in each state?

e. Do any states not meet the $800,000 minimum sales level?

3. Sort the state data by average policy amount, from highest to lowest.

a.

Which state had the highest average policy amount?

b. Which state had the lowest average policy amount?

4. Rank the regions from the highest total insurance sales to lowest total insurance sales. Sort the

data by sales, from highest to lowest.

a.

Which region had the highest sales? What is the total dollar amount?

b. Which region had the lowest sales? What is the total dollar amount?

5. Who is the leading salesperson in each region?

6. What is the total dollar amount sold for each type of insurance? Create a graph to show total

dollar amount of each type of insurance sold, by region. What does this graph show?

7. Create a map chart that shows total sales for each state. What can you surmise from this map

chart?

8. Analyze all the information you have gathered or created in the preceding requirements. What

trends or takeaways do you see? Explain.

Answers

Related Questions

Business Finance : Provide an example of a policy...

Provide an example of a policy or regulation that can be implemented to reduce the effect of outsourcing....

Business Finance : Propose two methods to diminis...

Propose two methods to diminish the possibility that a business would rely to foreign rather than local suppliers. ...

Other : Do offenders see life in prison as a wors...

Class - Do offenders see life in prison as a...

Programming : Write a paper in which you explain...

What is SQL?...

Other : Give your opinion as to whether a lower i...

Give your opinion as to whether a lower inmate population equates to lower overall crime rates. Support your response with real-world exam...

Science : Please explain the cellular structure o...

Please explain the cellular structure of the eye? A credible reference would be awesome!...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it