Question

Directions:      

1. The Table of Data below contains the blood pressure (BP) readings for ten college students.   All systolic and diastolic       readings are in units of mmHg.

2. Enter these data into a table in an Excel spread sheet with the following columns: Subject

Systolic P (mmHg)

Diastolic P (mmHg)

Pulse P (mmHg)

    Clearly label the table with a title and the column headings, including units.

3. Using Excel, provide a histogram for each of the following data:

            a. Systolic BP

            b. Diastolic BP

            c. Pulse Pressure (PP)   Note: PP = (Systolic Pressure) – (Diastolic Pressure)

4. Using Excel, for the Systolic BP and the Diastolic BP and the Pulse Pressure, calculate the following:

            a. range

            b. mean

            c. standard deviation

            d. variance

            e. maximum

            f. minimum

Table of Data

Subject             Blood Pressure (BP)

1                    120/60

2                    126/60

3                    120/70

4                    110/70

5                    116/72

6                    110/68

7                    130/90

8                    128/86

9                    126/80

10                    130/82

Answer 1

Subject (Students)	Systolic BP(mmhg)	Diastolic BP(mmhg)	Pulse pressure
1	120	60	60
2	126	60	66
3	120	70	50
4	110	70	40
5	116	72	44
6	110	68	42
7	130	90	40
8	128	86	42
9	126	80	46
10	130	82	48

Systolic BP(mmhg)

a. Range = 130-110 = 20

b. Mean = 121.6

c. Standard deviation = 7.6478

d. Variance = 58.4889

e. Maximum = 130

f. Minimum =110

Diastolic BP(mmhg)

a. Range = 90-60 = 30

b. Mean = 73.8

c. Standard deviation = 10.3473

d. Variance = 107.067

e. Maximum = 90

f. Minimum =60

Pulse pressure

a. Range = 66-40 = 26

b. Mean = 47.8

c. Standard deviation = 8.7661

d. Variance = 76.8444

e. Maximum = 66

f. Minimum =40