Submitted By: -
Jewel Johnson
Muhammad Muaaz
Mithil Patel
Dataset-D
21st November, 2021-11-21
ACC201
Introductory Financial Accounting Data Analytics Case
01.28.2019
1. There are some typographical errors in the data set in the Region and Insurance Type
fields. Find and correct these errors.
- Refer to the excel document.
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?
- NJ, $1,204,038.15
b. Which state had the lowest sales? What was the total dollar amount?
MA,
$841,395.41
c. What is the average amount of insurance sold per state?
-Please refer to the excel document (Too long to post here)
d. How many insurance policies were sold in each state?
- Please refer the excel document.
e. Do any states not meet the $800,000 minimum sales level?
01.28.2019
-No, all above $800,000.
3. Sort the state data by average policy amount, from highest to lowest.
a. Which state had the highest average policy amount?
-NJ.
b. Which state had the lowest average policy amount?
-CT.
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?
-Northeast, $10,261,593.36
b. Which region had the lowest sales? What is the total dollar amount?
-New England, $5,332,816.07
5. Who is the leading salesperson in each region?
01.28.2019
-Northeast: Matt - $3,488,992.14
Southeast: Jennifer - $2,917,331.19
Midwest: Dave - $2,909,431.43
West: Peter - $3,905,255.18
North Central: Mario – $3,870,836.49
New England: Sara – $2,713,176.39
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?
This graph shows that the professional insurance type has the highest sum of sales and
life insurance has the lowest sum of sales.
7. Create a map chart that shows total sales for each state. What can you surmise from this
map chart?
The least number of sales is done in the west whereas some states in the east have spent
more than $900 on insurance.
8. Analyze all the information you have gathered or created in the preceding requirements.
What trends or takeaways do you see? Explain.
01.28.2019
-The second answer talks about the highest total insurance sales to the lowest total
insurance sales, NJ had the highest sales worth 1,204,038.15$, and the state accountable
for the lowest sales was MA worth 841,395.41$.
The answer 3 talks about the average of sales amount in the different states, NJ had the
highest with $868.71, while CT had the lowest with $662.07.
The answer 4 talks about the regions from the highest total insurance sales to lowest total
insurance sales. The Northeast region had the highest sales worth $10,261,593.36 and the
region accountable for the lowest sales was New England worth $5,332,816.07. The total
sales of all the regions combined were $48,162,029.44.
The answer 5 addresses the leading salesperson in each region, In the Northeast the
leading salesperson is Matt having a total of $3,488,992.14 worth sales. In the Southeast,
Jennifer has the highest sales worth $2,917,331.19. Dave having the highest in the
Midwest worth $2,909,431.43. The highest sales in the West by Peter worth
$3,905,255.18. In the North Central the highest sales are done by Mario worth
$3,870,836.49. Sara having the highest sales in the New England worth $2,713,176.39.
The grand total of sales of all the regions accounted to $48,162,029.44.
The answer 6 talks about the different insurances like life insurance, disability insurance,
auto insurance and home insurance using a graph, so after analyzing the graph we can see
01.28.2019
that the professional insurance has the highest sum of sales whereas life insurance has the
lowest sum of sales.
The answer 7 talks about the total sales of each state using a map chart wherein we can
see that the least number of sales is done in the West whereas some states in the East
have spent more than $900 on insurance.
In all the information gathered above. We talk about the different insurances, the states
and regions sales of insurance and different leading salespersons. It helps us understand
that how some states and regions are spending more on insurance policies which is very
important for the security of their future whereas some states and regions are still
spending less on insurance which needs to be looked upon and improved. Every business
and profession require a different kind of insurance which safeguards it from the
uncertainties it could face in the in the future.
01.28.2019
