Please could you help me with this questions.

Data Collection Form

Evaluation of Exercise Performance among Coronary Artery Disease (CAD)

Name of Patient: Ronald Date:08-11-2022

Age: 46 yrs Subject: Healthy

Smoking History: Yes No History of Hypertension: Yes No

Pre-Treadmill Test in Seconds: 1014

Post-Treadmill Test in Seconds:1120(After 1 month)

Sl.No	Name	Subject	Time-Sec-Pre	Age yrs	HTN Hx	SMK Hx	Time Sec-Post
1	XYZ01	Healthy	1014	46	Yes	Yes	1020
2	XYZ02	Patient	864	45	Yes	Yes	952
3	XYZ03	Healthy	1006	40	No	No	1015
4	XYZ04	Healthy	810	42	Yes	No	810
5	XYZ05	Healthy	990	49	No	Yes	1000
6	XYZ06	Patient	636	43	Yes	No	780
7	XYZ07	Patient	638	42	Yes	No	900
8	XYZ08	Healthy	840	47	No	Yes	890
9	XYZ09	Patient	708	48	Yes	Yes	900
10	XYZ10	Healthy	978	49	No	Yes	990
11	XYZ11	Patient	600	46	Yes	Yes	850
12	XYZ12	Healthy	1002	41	Yes	No	1010
13	XYZ13	Patient	594	42	Yes	No	850
14	XYZ14	Patient	750	41	Yes	Yes	980
15	XYZ15	Healthy	1110	47	No	No	1120
16	XYZ16	Patient	750	44	Yes	Yes	950
17	XYZ17	Patient	630	50	Yes	Yes	870

1. Number of subjects who are healthy and the number of CAD patients.
2. What is the average age and treadmill time of all subjects?
3. Plot a pie-chart for age distribution and treadmill time of all subjects.
4. What is the average age and standard deviation of Healthy and CAD patients?
5. How many in each group were having hypertension and history of smoking?
6. What is the average treadmill time in each group?
7. Plot a bar diagram showing average time in seconds after treatment in CAD patients.
8. What is the average improvement in treadmill time after 1 month treatment in CAD patients?
9. Is the improvement in treadmill time statistically significant?
10. Compare the median between pre and post treadmill time.