nstruction: This homework needs to solved using both excel and python. Please submit one individual...

Question

nstruction: This homework needs to solved using both excel and python. Please submit one individual file for each question – use naming convention, ques*_studentname. *Attached is thedataset.Download dataset.

For this exercise, we use theHepatitis Disease datasetfrom UCI data repository. This data consists of 156 instances with 20 attributes.

Attribute information:

1. Class: DIE, LIVE

2. AGE: 10, 20, 30, 40, 50, 60, 70, 80

3. SEX: male, female

4. STEROID: no, yes

5. ANTIVIRALS: no, yes

6. FATIGUE: no, yes

7. MALAISE: no, yes

8. ANOREXIA: no, yes

9. LIVER BIG: no, yes

10. LIVER FIRM: no, yes

11. SPLEEN PALPABLE: no, yes

12. SPIDERS: no, yes

13. ASCITES: no, yes

14. VARICES: no, yes

15. BILIRUBIN: Continuous

16. ALK PHOSPHATE: Continuous

17. SGOT: Continuous

18. ALBUMIN: Continuous

19. PROTIME: Continuous

20. HISTOLOGY: no, yes

Question no 1: Use Excel and the hepatitis dataset. Answer the following questions:
XXXXXXXXXX=7)

a. Probability of a Male patient being dead.

b. There is one patient with attribute ANOREXIA value to be "?" -- question is, what is the likely value of this attribute for this patient?

c. What is the probability that a patient between age [10,50] use steroid? (Replace “?” with “Yes”)

d. Which one is more likely, a person with no ANTIVIRALS being Alive or a person with MALAISE being dead?

e. Which Age group is more likely to be dead ? What are the probabilities? (Group the ages in 3 groups. 20-40, 40-60, 60-80)

f. Is the age attribute normally distributed? Reason why or why not?

[ for Question no 1: you are allowed to use inbuilt excel function. As an example, for probability of a male being dead, I would like to see something as follows:

"This question could be answered by finding xx and doing xxx".

Show how finding XX

How doing XXXX

Therefore answer is:

2.Use Excel/Python and the Hepatitis dataset: (3+2= 5)

Create 3 different visualizations showing the mean and standard deviation (orstandard erroras it is referred to in this context) of the sampling distributions of sample age for sample sizes: 2, 5, 10
What happens to the mean of the sample means of age as the sample size is increased? What happens to the standard error ?

[description: In addition to doing the work in python or excel, you need to write a descriptive answer that summarizes your findings.

Question no 3: USE PYTHON (1+2+2)

a. Generate a discrete uniform distribution of population size 100 between interval (1,10).)

b Consider the sample size of N=10, Simulate the sampling distribution of the sample mean. (repeat 100 times) Draw the visualization.

c Consider the sample size of N=30, what is the sample mean and sample standard deviation? (repeat 100 times). Draw the visualization.

[Code+ graphs]

here is file if you need anything else let me know

also please if your doing work in excel not put screen shot just done in excle whatever question needs and asked

hepatitis-2cc1sb0h.xls 1-v02kvf1i-idlkx5ib.csv 2-zhw00zex-hswfe5x3.py 2-ax2s5cjr-fawcvtan.py ques3-llki54p2-qzv3gaz5.py

Baljit · Accepted Answer

Sheet 1 - hepatitis(3)
	hepatitis(3)
	Class	Age	Sex	STEROID	ANTIVIRALS	FATIGUE	MALAISE	ANOREXIA	LIVER BIG	LIVER FIRM	SPLEEN PALPABLE	SPIDERS	ASCITES	VARICES	BILIRUBIN	ALK PHOSPHATE	SGOT	ALBUMIN	PROTIME	HISTOLOGY
	Alive	30	Female	No	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	1	85	18	4	?	No			Total occ
	Alive	50	Male	No	Yes	No	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	0.9	135	42	3.5	?	No
	Alive	78	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	96	32	4	?	No
	Alive	31	Male	?	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	46	52	4	80	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	200	4	?	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	95	28	4	75	No
	Dead	51	Male	No	Yes	No	Yes	No	Yes	Yes	No	No	Yes	Yes	?	?	?	?	?	No
	Alive	23	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	?	?	?	No
	Alive	39	Male	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.7	?	48	4.4	?	No
	Alive	30	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	120	3.9	?	No
	Alive	39	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1.3	78	30	4.4	85	No
	Alive	32	Male	Yes	No	No	Yes	Yes	Yes	No	Yes	No	Yes	Yes	1	59	249	3.7	54	No
	Alive	41	Male	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.9	81	60	3.9	52	No
	Alive	30	Male	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	2.2	57	144	4.9	78	No
	Alive	47	Male	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	60	?	?	No
	Alive	38	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	No	Yes	2	72	89	2.9	46	No
	Alive	66	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.2	102	53	4.3	?	No
	Alive	40	Male	No	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.6	62	166	4	63	No
	Alive	38	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	53	42	4.1	85	Yes
	Alive	38	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	0.7	70	28	4.2	62	No
	Alive	22	Female	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	48	20	4.2	64	No
	Alive	27	Male	Yes	Yes	No	No	No	No	No	No	No	Yes	Yes	1.2	133	98	4.1	39	No
	Alive	31	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	20	4	100	No
	Alive	42	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	60	63	4.7	47	No
	Alive	25	Female	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.4	45	18	4.3	70	No
	Alive	27	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	95	46	3.8	100	No
	Alive	49	Male	No	No	No	No	No	Yes	No	Yes	No	Yes	Yes	0.6	85	48	3.7	?	No
	Alive	58	Female	Yes	Yes	No	Yes	Yes	Yes	No	Yes	No	Yes	Yes	1.4	175	55	2.7	36	No
	Alive	61	Male	No	Yes	No	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1.3	78	25	3.8	100	No
	Alive	51	Male	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	78	58	4.6	52	No
	Dead	39	Male	No	No	No	No	Yes	Yes	No	Yes	Yes	Yes	Yes	2.3	280	98	3.8	40	No
	Dead	62	Male	No	Yes	No	No	Yes	?	?	Yes	Yes	Yes	Yes	1	?	60	?	?	No
	Alive	41	Female	Yes	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.7	81	53	5	74	No
	Alive	26	Female	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.5	135	29	3.8	60	No
	Alive	35	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	58	92	4.3	73	No
	Dead	37	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	0.6	67	28	4.2	?	No
	Alive	23	Male	Yes	Yes	No	No	No	Yes	Yes	No	Yes	Yes	Yes	1.3	194	150	4.1	90	No
	Alive	20	Female	No	Yes	No	No	No	No	No	No	No	Yes	Yes	2.3	150	68	3.9	?	No
	Alive	42	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	14	4	100	No
	Alive	65	Male	Yes	Yes	No	No	Yes	Yes	No	No	No	No	Yes	0.3	180	53	2.9	74	Yes
	Alive	52	Male	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	75	55	4	21	No
	Alive	23	Male	Yes	Yes	Yes	Yes	Yes	?	?	?	?	?	?	4.6	56	16	4.6	?	No
	Alive	33	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	46	90	4.4	60	No
	Alive	56	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	71	18	4.4	100	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	86	?	?	No
	Alive	28	Male	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	74	110	4.4	?	No
	Alive	37	Male	No	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	0.6	80	80	3.8	?	No
	Alive	28	Female	Yes	Yes	No	No	Yes	Yes	No	Yes	Yes	Yes	Yes	1.8	191	420	3.3	46	No
	Alive	36	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	0.8	85	44	4.2	85	No
	Alive	38	Male	Yes	No	No	No	No	Yes	Yes	Yes	No	Yes	Yes	0.7	125	65	4.2	77	No
	Alive	39	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	85	60	4	?	No
	Alive	39	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	20	4	?	No
	Alive	44	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.6	110	145	4.4	70	No
	Alive	40	Male	Yes	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	1.2	85	31	4	100	No
	Alive	30	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	50	78	4.2	74	No
	Alive	37	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.8	92	59	?	?	No
	Alive	34	Male	No	Yes	?	?	?	?	?	?	?	?	?	?	?	?	?	?	No
	Alive	30	Male	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	52	38	3.9	52	No
	Alive	64	Male	Yes	No	No	No	Yes	No	No	Yes	Yes	Yes	Yes	1	80	38	4.3	74	No
	Alive	45	Female	No	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	1	85	75	?	?	No
	Alive	37	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	26	58	4.5	100	No
	Alive	32	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	102	64	4	90	No
	Alive	32	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	Yes	No	3.5	215	54	3.4	29	No
	Alive	36	Male	No	Yes	Yes	Yes	Yes	No	No	No	Yes	Yes	Yes	0.7	164	44	3.1	41	No
	Alive	49	Male	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	103	43	3.5	66	No
	Alive	27	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	?	38	4.2	?	No
	Alive	56	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	62	33	3	?	No
	Dead	57	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	No	Yes	4.1	?	48	2.6	73	No
	Alive	39	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	34	15	4	54	No
	Alive	44	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.6	68	68	3.7	?	No
	Alive	24	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	82	39	4.3	?	No
	Dead	34	Male	No	Yes	No	No	Yes	No	No	Yes	No	Yes	Yes	2.8	127	182	?	?	No
	Alive	51	Male	Yes	Yes	No	No	No	?	?	?	?	?	?	0.9	76	271	4.4	?	No
	Alive	36	Male	No	Yes	No	No	No	Yes	No	Yes	Yes	Yes	Yes	1	?	45	4	57	No
	Alive	50	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.5	100	100	5.3	?	No
	Alive	32	Male	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	55	45	4.1	56	No
	Dead	58	Male	Yes	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	2	167	242	3.3	?	No
	Alive	34	Female	No	No	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.6	30	24	4	76	No
	Alive	34	Male	No	Yes	No	Yes	Yes	No	No	Yes	No	Yes	Yes	1	72	46	4.4	57	No
	Alive	28	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	85	31	4.9	?	No
	Alive	23	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.8	?	14	4.8	?	No
	Alive	36	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	62	224	4.2	100	No
	Alive	30	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	100	31	4	100	No
	Alive	67	Female	No	Yes	No	No	Yes	Yes	Yes	?	?	?	?	1.5	179	69	2.9	?	No
	Alive	62	Female	Yes	Yes	No	No	Yes	Yes	No	Yes	No	Yes	Yes	1.3	141	156	3.9	58	No
	Alive	28	Male	No	Yes	No	No	No	Yes	No	Yes	Yes	Yes	Yes	1.6	44	123	4	46	No
	Dead	44	Male	No	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	No	0.9	135	55	?	41	Yes
	Dead	30	Male	Yes	Yes	No	No	No	Yes	No	Yes	No	No	No	2.5	165	64	2.8	?	Yes
	Dead	38	Male	No	Yes	No	No	No	Yes	No	Yes	No	No	No	1.2	118	16	2.8	?	Yes
	Alive	38	Male	No	Yes	No	No	No	No	No	Yes	Yes	Yes	Yes	0.6	76	18	4.4	84	Yes
	Alive	50	Female	No	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	0.9	230	117	3.4	41	Yes
	Dead	42	Male	No	Yes	No	No	No	Yes	Yes	No	No	Yes	No	4.6	?	55	3.3	?	Yes
	Alive	33	Male	Yes	Yes	Yes	Yes	Yes	?	?	Yes	Yes	Yes	Yes	1	?	60	4	?	Yes
	Alive	52	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.5	?	69	2.9	?	Yes
	Dead	59	Male	No	Yes	No	No	Yes	Yes	No	No	No	Yes	Yes	1.5	107	157	3.6	38	Yes
	Alive	40	Male	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	0.6	40	69	4.2	67	Yes
	Alive	30	Male	No	Yes	No	No	Yes	Yes	No	Yes	No	Yes	Yes	0.8	147	128	3.9	100	Yes
	Alive	44	Male	No	Yes	No	No	Yes	No	No	Yes	No	Yes	Yes	3	114	65	3.5	?	Yes
	Dead	47	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	No	2	84	23	4.2	66	Yes
	Alive	60	Male	No	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	?	?	40	?	?	Yes
	Dead	48	Male	No	Yes	No	No	Yes	Yes	No	Yes	No	No	No	4.8	123	157	2.7	31	Yes
	Alive	22	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	?	24	?	?	Yes
	Alive	27	Male	No	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	2.4	168	227	3	66	Yes
	Alive	51	Male	No	Yes	No	No	No	Yes	No	No	No	Yes	No	4.6	215	269	3.9	51	Yes
	Dead	47	Male	Yes	Yes	No	No	Yes	Yes	No	Yes	Yes	No	No	1.7	86	20	2.1	46	Yes
	Alive	25	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.6	?	34	6.4	?	Yes
	Dead	35	Male	No	Yes	No	Yes	Yes	?	?	No	No	No	Yes	1.5	138	58	2.6	?	Yes
	Alive	45	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	2.3	?	648	?	?	Yes
	Alive	54	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1	155	225	3.6	67	Yes
	Dead	33	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	Yes	0.7	63	80	3	31	Yes
	Alive	7	Male	Yes	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	Yes	0.7	256	25	4.2	?	Yes
	Dead	42	Male	No	No	No	No	Yes	Yes	Yes	Yes	No	Yes	Yes	0.5	62	68	3.8	29	Yes
	Alive	52	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	30	4	?	Yes
	Alive	45	Male	No	Yes	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	1.2	81	65	3	?	No
	Alive	36	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.1	141	75	3.3	?	Yes
	Alive	69	Female	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	3.2	119	136	?	?	Yes
	Alive	24	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	34	4.1	?	Yes
	Alive	50	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	139	81	3.9	62	Yes
	Dead	61	Male	No	Yes	No	No	Yes	?	?	Yes	No	Yes	Yes	?	?	?	?	?	Yes
	Alive	54	Male	Yes	Yes	No	Yes	Yes	No	No	Yes	Yes	Yes	Yes	3.2	85	28	3.8	?	Yes
	Dead	56	Male	No	Yes	No	No	No	No	No	Yes	No	Yes	Yes	2.9	90	153	4	?	Yes
	Alive	20	Male	No	Yes	No	No	No	Yes	Yes	Yes	No	No	Yes	1	160	118	2.9	23	Yes
	Alive	42	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	1.5	85	40	?	?	Yes
	Alive	37	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	0.9	?	231	4.3	?	Yes
	Alive	50	Male	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	Yes	Yes	1	85	75	4	72	Yes
	Alive	34	Female	Yes	Yes	No	No	No	No	No	Yes	No	Yes	Yes	0.7	70	24	4.1	100	Yes
	Alive	28	Male	Yes	Yes	No	No	No	?	?	Yes	No	No	Yes	1	?	20	4	?	Yes
	Dead	50	Male	Yes	Yes	No	Yes	Yes	Yes	No	No	Yes	No	No	2.8	155	75	2.4	32	Yes
	Alive	54	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	Yes	1.2	85	92	3.1	66	Yes
	Dead	57	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	No	No	Yes	4.6	82	55	3.3	30	Yes
	Alive	54	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	30	4.5	0	Yes
	Dead	31	Male	No	Yes	No	No	No	Yes	Yes	No	Yes	Yes	Yes	8	?	101	2.2	?	Yes
	Alive	48	Male	Yes	Yes	No	No	No	Yes	No	Yes	No	Yes	Yes	2	158	278	3.8	?	Yes
	Alive	72	Male	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	1	115	52	3.4	50	Yes
	Dead	38	Male	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.4	243	49	3.8	90	Yes
	Alive	25	Male	Yes	Yes	No	Yes	Yes	No	No	No	No	No	No	1.3	181	181	4.5	57	Yes
	Alive	51	Male	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	Yes	Yes	0.8	?	33	4.5	?	Yes
	Alive	38	Male	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	No	1.6	130	140	3.5	56	Yes
	Dead	47	Male	Yes	Yes	No	No	Yes	Yes	No	Yes	No	No	No	1	166	30	2.6	31	Yes
	Alive	45	Male	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.3	85	44	4.2	85	Yes
	Alive	36	Male	No	Yes	No	No	No	No	No	Yes	No	Yes	No	1.7	295	60	2.7	?	Yes
	Dead	54	Male	No	Yes	No	No	Yes	?	?	No	Yes	No	Yes	3.9	120	28	3.5	43	Yes
	Alive	51	Male	Yes	Yes	No	Yes	Yes	Yes	No	No	No	Yes	No	1	?	20	3	63	Yes
	Dead	49	Male	No	Yes	No	No	Yes	Yes	Yes	No	No	Yes	Yes	1.4	85	70	3.5	35	Yes
	Dead	45	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	No	Yes	1.9	?	114	2.4	?	Yes
	Alive	31	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.2	75	173	4.2	54	Yes
	Dead	41	Male	Yes	Yes	No	Yes	Yes	Yes	No	No	No	Yes	No	4.2	65	120	3.4	?	Yes
	Dead	70	Male	No	Yes	No	No	No	?	?	?	?	?	?	1.7	109	528	2.8	35	Yes
	Alive	20	Male	No	Yes	Yes	Yes	Yes	Yes	?	Yes	Yes	Yes	Yes	0.9	89	152	4	?	Yes
	Alive	36	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.6	120	30	4	?	Yes
	Dead	46	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	No	No	7.6	?	242	3.3	50	Yes
	Alive	44	Male	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.9	126	142	4.3	?	Yes
	Alive	61	Male	No	Yes	No	No	Yes	No	No	Yes	No	Yes	Yes	0.8	75	20	4.1	?	Yes
	Alive	53	Female	No	Yes	No	Yes	Yes	Yes	Yes	No	No	Yes	No	1.5	81	19	4.1	48	Yes
	Dead	43	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	No	No	No	Yes	1.2	100	19	3.1	42	Yes
&C&"Helvetica Neue,Regular"&12&P
Question_1
	Question 1:
	1.a We can calculate the occurrence of male person being dead by formula =COUNTIFS(A3:A157,"Dead",C3:C157,"Male")
	Total number of male person being dead=32
	probability of male personbeing dead=32/155=0.20645
	1.b   Anorexia person with value "Yes"
	We can find this with function  =COUNTIF(H3:H157,"Yes")
	Total occurrence=122
	Anorexia person with Value "No"
	We can find this with formula =COUNTIF(H3:H157,"No")
	Total Occurrence=32
	So occurrence of "Yes "is more likely So we can replace with "?" with "Yes"
	1.c
	First Replace "?" in steroid column with "Yes"
	WE can find the total occurrence of person in age group(10-50) use steroid with function =COUNTIFS(B3:B157,">=10",B3:B157,"20",A3:A157,"Dead")
	Total occurrence=9
	So probability =9/155=0.05806
	For age group 40-60
	We can find the total occurrence of age group 40-60 being dead with formulae   =COUNTIFS(B3:B157,"40",A3:A157,"Dead")
	Total occurrence=20
	So probability=20/155=0.12903
	For age group 40-60
	We can find the total occurrence of age group 60-80 being dead with formulae   =COUNTIFS(B3:B157,"60",A3:A157,"Dead")
	Total occurrence=3
	So probability=3/155=0.01935
	So Age group  40-60 more likely  to be dead
	1f.
	Yes age attribute is normally distributed because it histogram is normally distributed.
Question_1
	7
	12.91666667
	18.83333333
	24.75
	30.66666667
	36.58333333
	42.5
	48.41666667
	54.33333333
	60.25
	66.16666667
	72.08333333
	More
Frequency
Bin
Frequency
Histogram
1
0
0
11
21
28
30
18
24
9
8
4
1
1a
	hepatitis(3)
	Class	Age	Sex	STEROID	ANTIVIRALS	FATIGUE	MALAISE	ANOREXIA	LIVER BIG	LIVER FIRM	SPLEEN PALPABLE	SPIDERS	ASCITES	VARICES	BILIRUBIN	ALK PHOSPHATE	SGOT	ALBUMIN	PROTIME	HISTOLOGY
	Alive	30	Female	No	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	1	85	18	4	?	No			Total occurrence of male being dead	32
	Alive	50	Male	No	Yes	No	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	0.9	135	42	3.5	?	No			Probability	0.2064516129
	Alive	78	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	96	32	4	?	No
	Alive	31	Male	?	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	46	52	4	80	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	200	4	?	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	95	28	4	75	No
	Dead	51	Male	No	Yes	No	Yes	No	Yes	Yes	No	No	Yes	Yes	?	?	?	?	?	No
	Alive	23	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	?	?	?	No
	Alive	39	Male	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.7	?	48	4.4	?	No
	Alive	30	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	?	120	3.9	?	No
	Alive	39	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1.3	78	30	4.4	85	No
	Alive	32	Male	Yes	No	No	Yes	Yes	Yes	No	Yes	No	Yes	Yes	1	59	249	3.7	54	No
	Alive	41	Male	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.9	81	60	3.9	52	No
	Alive	30	Male	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	2.2	57	144	4.9	78	No
	Alive	47	Male	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	60	?	?	No
	Alive	38	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	No	Yes	2	72	89	2.9	46	No
	Alive	66	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.2	102	53	4.3	?	No
	Alive	40	Male	No	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.6	62	166	4	63	No
	Alive	38	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	53	42	4.1	85	Yes
	Alive	38	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	0.7	70	28	4.2	62	No
	Alive	22	Female	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	48	20	4.2	64	No
	Alive	27	Male	Yes	Yes	No	No	No	No	No	No	No	Yes	Yes	1.2	133	98	4.1	39	No
	Alive	31	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	20	4	100	No
	Alive	42	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	60	63	4.7	47	No
	Alive	25	Female	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.4	45	18	4.3	70	No
	Alive	27	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	95	46	3.8	100	No
	Alive	49	Male	No	No	No	No	No	Yes	No	Yes	No	Yes	Yes	0.6	85	48	3.7	?	No
	Alive	58	Female	Yes	Yes	No	Yes	Yes	Yes	No	Yes	No	Yes	Yes	1.4	175	55	2.7	36	No
	Alive	61	Male	No	Yes	No	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1.3	78	25	3.8	100	No
	Alive	51	Male	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	78	58	4.6	52	No
	Dead	39	Male	No	No	No	No	Yes	Yes	No	Yes	Yes	Yes	Yes	2.3	280	98	3.8	40	No
	Dead	62	Male	No	Yes	No	No	Yes	?	?	Yes	Yes	Yes	Yes	1	?	60	?	?	No
	Alive	41	Female	Yes	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.7	81	53	5	74	No
	Alive	26	Female	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.5	135	29	3.8	60	No
	Alive	35	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	58	92	4.3	73	No
	Dead	37	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	0.6	67	28	4.2	?	No
	Alive	23	Male	Yes	Yes	No	No	No	Yes	Yes	No	Yes	Yes	Yes	1.3	194	150	4.1	90	No
	Alive	20	Female	No	Yes	No	No	No	No	No	No	No	Yes	Yes	2.3	150	68	3.9	?	No
	Alive	42	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	14	4	100	No
	Alive	65	Male	Yes	Yes	No	No	Yes	Yes	No	No	No	No	Yes	0.3	180	53	2.9	74	Yes
	Alive	52	Male	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	75	55	4	21	No
	Alive	23	Male	Yes	Yes	Yes	Yes	Yes	?	?	?	?	?	?	4.6	56	16	4.6	?	No
	Alive	33	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	46	90	4.4	60	No
	Alive	56	Male	No	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	71	18	4.4	100	No
	Alive	34	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	86	?	?	No
	Alive	28	Male	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	74	110	4.4	?	No
	Alive	37	Male	No	Yes	Yes	Yes	Yes	Yes	No	Yes	No	Yes	Yes	0.6	80	80	3.8	?	No
	Alive	28	Female	Yes	Yes	No	No	Yes	Yes	No	Yes	Yes	Yes	Yes	1.8	191	420	3.3	46	No
	Alive	36	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	0.8	85	44	4.2	85	No
	Alive	38	Male	Yes	No	No	No	No	Yes	Yes	Yes	No	Yes	Yes	0.7	125	65	4.2	77	No
	Alive	39	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.9	85	60	4	?	No
	Alive	39	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	85	20	4	?	No
	Alive	44	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.6	110	145	4.4	70	No
	Alive	40	Male	Yes	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	1.2	85	31	4	100	No
	Alive	30	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	50	78	4.2	74	No
	Alive	37	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.8	92	59	?	?	No
	Alive	34	Male	No	Yes	?	?	?	?	?	?	?	?	?	?	?	?	?	?	No
	Alive	30	Male	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	52	38	3.9	52	No
	Alive	64	Male	Yes	No	No	No	Yes	No	No	Yes	Yes	Yes	Yes	1	80	38	4.3	74	No
	Alive	45	Female	No	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	1	85	75	?	?	No
	Alive	37	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	26	58	4.5	100	No
	Alive	32	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	102	64	4	90	No
	Alive	32	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	Yes	No	3.5	215	54	3.4	29	No
	Alive	36	Male	No	Yes	Yes	Yes	Yes	No	No	No	Yes	Yes	Yes	0.7	164	44	3.1	41	No
	Alive	49	Male	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	103	43	3.5	66	No
	Alive	27	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	?	38	4.2	?	No
	Alive	56	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	62	33	3	?	No
	Dead	57	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	No	No	Yes	4.1	?	48	2.6	73	No
	Alive	39	Male	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	34	15	4	54	No
	Alive	44	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.6	68	68	3.7	?	No
	Alive	24	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.8	82	39	4.3	?	No
	Dead	34	Male	No	Yes	No	No	Yes	No	No	Yes	No	Yes	Yes	2.8	127	182	?	?	No
	Alive	51	Male	Yes	Yes	No	No	No	?	?	?	?	?	?	0.9	76	271	4.4	?	No
	Alive	36	Male	No	Yes	No	No	No	Yes	No	Yes	Yes	Yes	Yes	1	?	45	4	57	No
	Alive	50	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.5	100	100	5.3	?	No
	Alive	32	Male	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1	55	45	4.1	56	No
	Dead	58	Male	Yes	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	2	167	242	3.3	?	No
	Alive	34	Female	No	No	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	0.6	30	24	4	76	No
	Alive	34	Male	No	Yes	No	Yes	Yes	No	No	Yes	No	Yes	Yes	1	72	46	4.4	57	No
	Alive	28	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	85	31	4.9	?	No
	Alive	23	Male	Yes	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	0.8	?	14	4.8	?	No
	Alive	36	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	62	224	4.2	100	No
	Alive	30	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	100	31	4	100	No
	Alive	67	Female	No	Yes	No	No	Yes	Yes	Yes	?	?	?	?	1.5	179	69	2.9	?	No
	Alive	62	Female	Yes	Yes	No	No	Yes	Yes	No	Yes	No	Yes	Yes	1.3	141	156	3.9	58	No
	Alive	28	Male	No	Yes	No	No	No	Yes	No	Yes	Yes	Yes	Yes	1.6	44	123	4	46	No
	Dead	44	Male	No	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	No	0.9	135	55	?	41	Yes
	Dead	30	Male	Yes	Yes	No	No	No	Yes	No	Yes	No	No	No	2.5	165	64	2.8	?	Yes
	Dead	38	Male	No	Yes	No	No	No	Yes	No	Yes	No	No	No	1.2	118	16	2.8	?	Yes
	Alive	38	Male	No	Yes	No	No	No	No	No	Yes	Yes	Yes	Yes	0.6	76	18	4.4	84	Yes
	Alive	50	Female	No	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	0.9	230	117	3.4	41	Yes
	Dead	42	Male	No	Yes	No	No	No	Yes	Yes	No	No	Yes	No	4.6	?	55	3.3	?	Yes
	Alive	33	Male	Yes	Yes	Yes	Yes	Yes	?	?	Yes	Yes	Yes	Yes	1	?	60	4	?	Yes
	Alive	52	Male	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	1.5	?	69	2.9	?	Yes
	Dead	59	Male	No	Yes	No	No	Yes	Yes	No	No	No	Yes	Yes	1.5	107	157	3.6	38	Yes
	Alive	40	Male	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	0.6	40	69	4.2	67	Yes
	Alive	30	Male	No	Yes	No	No	Yes	Yes	No	Yes	No	Yes	Yes	0.8	147	128	3.9	100	Yes
	Alive	44	Male	No	Yes	No	No	Yes	No	No	Yes	No	Yes	Yes	3	114	65	3.5	?	Yes
	Dead	47	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	No	2	84	23	4.2	66	Yes
	Alive	60	Male	No	Yes	No	Yes	Yes	No	No	No	No	Yes	Yes	?	?	40	?	?	Yes
	Dead	48	Male	No	Yes	No	No	Yes	Yes	No	Yes	No	No	No	4.8	123	157	2.7	31	Yes
	Alive	22	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.7	?	24	?	?	Yes
	Alive	27	Male	No	Yes	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	2.4	168	227	3	66	Yes
	Alive	51	Male	No	Yes	No	No	No	Yes	No	No	No	Yes	No	4.6	215	269	3.9	51	Yes
	Dead	47	Male	Yes	Yes	No	No	Yes	Yes	No	Yes	Yes	No	No	1.7	86	20	2.1	46	Yes
	Alive	25	Male	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	0.6	?	34	6.4	?	Yes
	Dead	35	Male	No	Yes	No	Yes	Yes	?	?	No	No	No	Yes	1.5	138	58	2.6	?	Yes
	Alive	45	Male	No	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	2.3	?	648	?	?	Yes
	Alive	54	Male	No	No	Yes	Yes	Yes	No	No	Yes	Yes	Yes	Yes	1	155	225	3.6	67	Yes
	Dead	33	Male	No	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	Yes	0.

nstruction: This homework needs to solved using both excel and python. Please submit one individual file for each question – use naming convention, ques_studentname. Attached is thedataset.Download...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

nstruction: This homework needs to solved using both excel and python. Please submit one individual file for each question – use naming convention, ques*_studentname. *Attached is thedataset.Download...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

nstruction: This homework needs to solved using both excel and python. Please submit one individual file for each question – use naming convention, ques_studentname. Attached is thedataset.Download...