Excel Data Expolration and Analysis.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Last Name	First Name	Gender	Extra risk factor	Age	Risk Level	Policy Fee	Death Probablity	Insurance Amount	Insurance premium	Risk Premium
2	Aitkali	Makhambet	Male	0	26	No Risk	10	#N/A	20000	#N/A	#N/A
3	An	Ran	Male	0.03	30	Low Risk	15	#REF!	20000	#REF!	#REF!
4	Austin	Emily A.	Female	0.16	30	Low Risk	15	#REF!	20000	#REF!	#REF!
5	Bauer	Austin B.	Male	0.5	37	Moderate Risk	20	#REF!	20000	#REF!	#REF!
6	Beckley	Jenna K.	Female	0.55	37	High Risk	25	#REF!	20000	#REF!	#REF!
7	Bergmann	Mayfawny H.	Male	0.52	29	High Risk	25	#REF!	20000	#REF!	#REF!
8	Buness	Alicia N.	Female	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
9	Catania	Christian A.	Female	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
10	Chelius	Kevin P.	Male	0.22	27	Moderate Risk	20	#REF!	20000	#REF!	#REF!
11	Dong	Wanxue	Male	0.6	30	High Risk	25	#REF!	20000	#REF!	#REF!
12	Fisher	Bradley A.	Male	0.52	29	High Risk	25	#REF!	20000	#REF!	#REF!
13	Henry	Michael P.	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
14	Hillman	Matthew R.	Male	0	28	No Risk	10	#REF!	20000	#REF!	#REF!
15	Hooks	Malcolm T.	Male	0.53	28	High Risk	25	#REF!	20000	#REF!	#REF!
16	Hu	Zhouzi	Female	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
17	Huang	Jing	Female	0.32	26	Moderate Risk	20	#REF!	20000	#REF!	#REF!
18	Jiang	Shangying	Female	0.21	18	Moderate Risk	20	#REF!	20000	#REF!	#REF!
19	Khalid	Qistina	Female	0.18	28	Low Risk	15	#REF!	20000	#REF!	#REF!
20	Lindsay	Chloe J.	Female	0.16	26	Low Risk	15	#REF!	20000	#REF!	#REF!
21	Liu	Hao	Female	0.51	29	High Risk	25	#REF!	20000	#REF!	#REF!
22	Long	Derek J.	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
23	Losby	Jennifer C.	Female	0.21	27	Moderate Risk	20	#REF!	20000	#REF!	#REF!
24	Merritt	Conner R.	Male	0.55	28	High Risk	25	#REF!	20000	#REF!	#REF!
25	Mosshammer	Eric E.	Male	0	35	No Risk	10	#REF!	20000	#REF!	#REF!
26	Mosso	Matthew G.	Male	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
27	Mullen	Scott A.	Male	0.59	28	High Risk	25	#REF!	20000	#REF!	#REF!
28	Oh	Jimin	Female	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
29	Orazaliyev	Rustam	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
30	Patel	Surin R.	Female	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
31	Pendleton	James K.	Male	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
32	Pilawski	Alyson J.	Female	0.6	27	High Risk	25	#REF!	20000	#REF!	#REF!
33	Ratzburg	Erik C.	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
34	Sandmann	Tyler J.	Male	0.38	35	Moderate Risk	20	#REF!	20000	#REF!	#REF!
35	Senseman	Austin R.	Male	0	28	No Risk	10	#REF!	20000	#REF!	#REF!
36	Siddique	Rehan N.	Male	0.56	26	High Risk	25	#REF!	20000	#REF!	#REF!
37	St John	Hayden B.	Male	0.25	35	Moderate Risk	20	#REF!	20000	#REF!	#REF!
38	Stayback	Bradley K.	Male	0.49	29	Moderate Risk	20	#REF!	20000	#REF!	#REF!
39	Stephan	Brittny M.	Female	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
40	Tang	Yao	Male	0.16	29	Low Risk	15	#REF!	20000	#REF!	#REF!
41	Wang	Ruoyu	Male	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
42	Wang	Yang	Female	0	27	No Risk	10	#REF!	20000	#REF!	#REF!
43	Weidman	Nolan M.	Male	0.01	35	Low Risk	15	#REF!	20000	#REF!	#REF!
44	Amstutz	Jana R.	Female	0.4	28	Moderate Risk	20	#REF!	20000	#REF!	#REF!
45	Brutton	Hunter M.	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
46	Deno	Kameron D.	Male	0.56	30	High Risk	25	#REF!	20000	#REF!	#REF!
47	Figueroa	Rebekah R.	Female	0	35	No Risk	10	#REF!	20000	#REF!	#REF!
48	Fox	Lindsay K.	Female	0.19	29	Low Risk	15	#REF!	20000	#REF!	#REF!
49	Gao	Tong	Male	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
50	Gramse	Joseph A.	Male	0.22	26	Moderate Risk	20	#REF!	20000	#REF!	#REF!
51	Ha	Ziwei	Female	0.3	37	Moderate Risk	20	#REF!	20000	#REF!	#REF!
52	Han	Zeyu	Female	0	29	No Risk	10	#REF!	20000	#REF!	#REF!
53	Heston	William L.	Male	0.08	37	Low Risk	15	#REF!	20000	#REF!	#REF!
54	Hussin	Muhamad Hafiz	Male	0.14	29	Low Risk	15	#REF!	20000	#REF!	#REF!
55	Ivey	Brian K.	Male	0	26	No Risk	10	#REF!	20000	#REF!	#REF!
56	Kurtz	Jordan T.	Male	0.12	28	Low Risk	15	#REF!	20000	#REF!	#REF!
57	Le	Jialiang	Female	0.16	28	Low Risk	15	#REF!	20000	#REF!	#REF!
58	Leavitt	Kyle J.	Female	0.47	27	Moderate Risk	20	#REF!	20000	#REF!	#REF!
59	Li	Kunyu	Male	0	30	No Risk	10	#REF!	20000	#REF!	#REF!
60	Li	Yunrui R.	Female	0.48	35	Moderate Risk	20	#REF!	20000	#REF!	#REF!
61	Lyznicki	John T.	Male	0.57	28	High Risk	25	#REF!	20000	#REF!	#REF!
62	Maloney	Matthew J.	Male	0.59	29	High Risk	25	#REF!	20000	#REF!	#REF!
63	Mathieu	Elliot C.	Male	0.41	35	Moderate Risk	20	#REF!	20000	#REF!	#REF!
64	Mohammad Yusoff	Nur Liyana B.	Female	0	37	No Risk	10	#REF!	20000	#REF!	#REF!
65	Mohd Zulkifli	Aimi 'Aqilah	Female	0.11	30	Low Risk	15	#REF!	20000	#REF!	#REF!
66	Norman	John M.	Male	0.47	30	Moderate Risk	20	#REF!	20000	#REF!	#REF!
67	Rodenbeck	Blake D.	Male	0.51	30	High Risk	25	#REF!	20000	#REF!	#REF!
68	Scott	Tracy L.	Male	0.59	37	High Risk	25	#REF!	20000	#REF!	#REF!
69	Selm	Kevin C.	Male	0	26	No Risk	10	#REF!	20000	#REF!	#REF!
70	Shi	Huining	Female	0.55	29	High Risk	25	#REF!	20000	#REF!	#REF!
71	Tibbett	Jackson R.	Male	0.38	29	Moderate Risk	20	#REF!	20000	#REF!	#REF!
72	Wallace	Colin R.	Male	0	28	No Risk	10	#REF!	20000	#REF!	#REF!
73	Walsh	Kathryn N.	Female	0	18	No Risk	10	#REF!	20000	#REF!	#REF!
74	Wang	Shuwen	Female	0.33	29	Moderate Risk	20	#REF!	20000	#REF!	#REF!
75	Widmaier	Colleen A.	Female	0	35	No Risk	10	#REF!	20000	#REF!	#REF!
76	Wolff	Duncan E.	Male	0	18	No Risk	10	#REF!	20000	#REF!	#REF!
77	Yang	Ningzhu	Female	0	18	No Risk	10	#REF!	20000	#REF!	#REF!
78	Yin	Zhihan	Male	0.13	26	Low Risk	15	#REF!	20000	#REF!	#REF!
79	Zhang	Yue	Female	0.41	29	Moderate Risk	20	#REF!	20000	#REF!	#REF!
80									1560000
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100