Hello, I need your help with this statistics assignment. I'm not sure how to answer. Please check my answers, complete them, and explain them. I was able to find the first three answers, but now I need help with the remaining questions. Thank you very much!

Instructions:

Descriptive Statistics Assignment 1 CDC HNANES Database Survey Example

Please read the database survey information and review the Excel dataset from NHANES 2017-2018.

"The National Health and Nutrition Examination Survey (NHANES) is a program of studies designed to assess the health and nutritional status of adults and children in the United States. The survey is unique in that it combines interviews and physical examinations. NHANES is a major program of the National Center for Health Statistics (NCHS). NCHS is part of the Centers for Disease Control and Prevention (CDC) and has the responsibility for producing vital and health statistics for the Nation.

The NHANES interview includes demographic, socioeconomic, dietary, and health-related questions. Examination component consists of medical, dental, physiological measurements, and laboratory tests.

Findings from this survey will be used to determine the prevalence and risk factors for diseases. Information will be used to assess nutritional status and its association with health promotion and disease prevention. NHANES findings are also the basis for national standards for measurements as height, weight, and blood pressure. Data used in epidemiological studies and health sciences research, which help develop public health policy, direct and design health programs, and services, and expand health knowledge for the Nation."

https://www.cdc.gov/nchs/nhanes/about_nhanes.htm

The attached Excel file is a partial dataset from the NHANES 2017-2018 survey and contains the following variables: gender, systolic and diastolic blood pressure, BMI, general health question, BMI, hypertension.

Coding chart

Gender - 1=female, 2=male

General Health question - "How would you rate your health on a scale of 1 to 5, with 1 indicating excellent health and 5 indicating poor health?"

3. Using the table below. indicate the Levels of Measurement for each of the variables.

4. Using the table below, indicate whether the variables are continuous or categorical.

Levels of Measurement Category
Variable	Nominal	Ordinal	Interval	Ratio	Continuous	Categorical
Patient ID	unique identifiers without a meaningful order or numerical value. .					Patient ID is categorial
Gender	This divides patients into groups (such as male and female) with no order.					Gender is a categorial without a meaningful order.
BMI				BMI is a continuous variable with a true zero point, and the differences between values are meaningful	BMI is a continuous variable
Systolic BP (Blood Pressure)			Systolic blood pressure is a continuous variable with a true zero point.		Systolic BP is continuous
Diastolic BP (Blood Pressure)			Diastolic blood pressure is also a continuous variable with a true zero point.
General Health		General health is often measured on a scale (e.g., poor, fair, good, excellent) that has a meaningful order but not equal intervals.				General health is categorial
BMI Group		BMI groups (ex. underweight, normal weight, overweight, obese) have a meaningful order but not equal intervals.				BMI group is categorial
Hypertension	Hypertension is a categorical variable indicating the presence or absence of the condition.					Hypertension is categorial

5. Provide the sample (n), frequency, percentage, and cumulative percentage for the following variables. (Patients 1-100)

Variable	n	frequency	percentage	cumulative percentage
Gender
Female (1)	100	48	48%	48%
Male (2)	100	52	52%	100%
BMI
< 21	100	4	4	4
21-30.9	100	65	65	65
31-40.9	100	29	29%	98
>40.9	100	2	2	100
General Health
1	100	6	6%	6%
2	100	24	24%	30%
3	100	42	42%	72%
4	100	17	17%	89%
5	100	4	4%	93%
missing data	100	7	7%	100%
BMI Group
1. Normal	100	32	32%	32%
2. Overweight	100	30	30%	62%
3. Obese	100	38	38%	100%
Hypertension
yes	100	21	21%	21%
no	100	79	79%	100%

6. What does the data in this table regarding general health tell you?

7. In patients that have hypertension, calculate the frequency, percentage, and cumulative percentage of BMI category (Patients 1-100):

Variable n frequency percentage cumulative percentage
BMI
normal	10	10	47.6	47.6
overweight				47.6 + overweight percentage
obese				100

8. In one sentence, what does this tell you about the relationship between weight and hypertension?

9. In one or two sentences, please explain the main purpose of descriptive statistics.

Here is the Data

Patient	Gender	BMI	Systolic bp	Diastolic bp	General health	BMI Group	Hypertension
1	2	31.7			3	3. Obese	no
2	1	21.5	112	74	2	1. Normal	no
3	2	23.7			3	1. Normal	no
4	2	38.9	120	66		3. Obese	no
5	1	21.3	108	68	2	1. Normal	no
6	1	19.7	112	68	3	1. Normal	no
7	1	23.5	104	70	2	1. Normal	no
8	2	39.9			3	3. Obese	no
9	1	22.5	112	60	4	1. Normal	no
10	1	30.7	120	72	2	3. Obese	no
11	1	24.5	116	62	2	1. Normal	no
12	1	22	128	88	3	1. Normal	no
13	2	35.9	132	68	3	3. Obese	no
14	2	23.8	116	68	3	2. Normal	no
15	1	22.4	124	72	2	1. Normal	no
16	2	31.3	140	52	2	3. Obese	yes
17	1	23.9			1	1. Normal	no
18	1	33.4	122	74	3	3. Obese	no
19	1	27.6	130	86	4	2. Overweight	no
20	1	28.6	134	74		2. Overweight	no
21	1	27.6	114	54	2	2. Overweight	no
22	1	21.3	132	76	3	1. Normal	no
23	1	35.1	154	74		3. Obese	yes
24	1	33.7	120	82	3	3. Obese	no
25	1	30.6	178	78	5	3. Obese	yes
26	1	33.9	166	90	4	3. Obese	yes
27	1	22.5	152	86	2	1. Normal	yes
28	2	24.8	106	64	2	1. Normal	no
29	2	25.5	126	60	3	2. Overweight	no
30	1	33.4			3	3. Obese	no
31	2	29.4	106	76	2	2. Overweight	no
32	2	29.2	160	76		2. Overweight	yes
33	1	34.9			3	3. Obese	no
34	2	30.8	154	74	4	3. Obese	yes
35	1	29.1	118	64	3	2. Overweight	no
36	2	37.7	132	66	5	3. Obese	no
37	1	29	132	90	3	2. Overweight	yes
38	2	27.1	132	60	3	2. Overweight	no
39	1	25.5	120	84	3	2. Overweight	no
40	1	21.9				1. Normal	no
41	2	27.1	148	106	4	2. Overweight	no
42	1	31.9	122	64	4	3. Obese	yes
43	1	25.7	116	72	3	2. Overweight	no
44	1	26	130	56	4	2. Overweight	no
45	2	30.7	120	62	4	3. Obese	no
46	1	24.1	122	80	3	1. Normal	no
47	2	25.9	118	72		2. Overweight	no
48	2	25.9	108	76	2	2. Overweight	no
49	2	22.2	118	76	1	1. Normal	no
50	2	27.4	102	70	3	2. Overweight	no
51	2	33.5	128	90	3	3. Obese	yes
52	1	25.4			4	2. Overweight	no
53	2	24	92	56	3	1. Normal	no
54	2	24.3	104	66	3	1. Normal	no
55	2	30.7	166		2	3. Obese	yes
56	2	39.3	124	56	2	3. Obese	no
57	2	23.6	108	56	2	1. Normal	no
58	1	36.9	134	100	4	3. Obese	yes
59	2	18.9			2	1. Normal	no
60	2	23.9	132	80	3	1. Normal	no
61	1	31.2	128	62		3. Obese	no
62	2	32	114	76	2	3. Obese	no
63	2	28.5	142	66	3	2. Overweight	yes
64	1	22.8	100	58	3	1. Normal	no
65	2	22.7	154		2	1. Normal	yes
66	1	24.7	114	76	2	1. Normal	no
67	2	33.9	132	76	3	3. Obese	no
68	1	28.4	100	74	4	2. Overweight	no
69	1	29.5	106	76	3	2. Overweight	no
70	1	31.1	140	100	3	3. Obese	yes
71	2	43.2	136	94	4	3. Obese	yes
72	2	27.8	102	76	1	2. Overweight	no
73	2	28			4	2. Overweight	no
74	1	24.3	126	90	1	1. Normal	yes
75	2	27.9	126	74	3	2. Overweight	no
76	2	33.4	138	72	3	3. Obese	no
77	2	28.4	106	64	4	2. Overweight	no
78	1	30.5	154	76	3	3. Obese	yes
79	2	20	154	72	3	1. Normal	yes
80	2	31.7			3	3. Obese	no
81	1	32.2			3	3. Obese	no
82	1	25.3	144	76	4	2. Overweight	yes
83	1	27	130	52	1	2. Overweight	no
84	2	36.5	136	76	5	3. Obese	no
85	2	39.1	118	72	3	3. Obese	no
86	2	30.1	138	86	2	3. Obese	no
87	1	24	114	86	3	1. Normal	no
88	2	32.8	112	80	2	3. Obese	no
89	2	21	92	54	1	1. Normal	no
90	2	24.8	110	86	4	1. Normal	no
91	2	19.8	104	54	2	1. Normal	no
92	2	40.9	108	62	5	3. Obese	no
93	1	29	126	82	2	2. Overweight	no
94	2	22.7	108	70	2	1. Normal	no
95	2	27	144	66	3	2. Overweight	yes
96	2	31.2	130	56	3	3. Obese	no
97	2	27.2	128	70	4	2. Overweight	no
98	1	26	102	72	3	2. Overweight	no
99	1	35.6	130	68	3	3. Obese	no
100	1	42.8	128	70	3	3. Obese	no

OR the original