Statistics - Descriptive Statistics Projects

Actual project Part I (ungrouped data—Sheet # 1) Health project ---- What do your blood pressure numbers

Actual project Part I ( ungrouped data—Sheet # 1)

Health project ---- What do your blood pressure numbers mean?

Blood pressure is measured in millimeters of mercury (mm Hg) and is written as follows: "systolic" over "diastolic." For instance, if your blood pressure is 140/90 mm Hg: The top number of 140 (systolic) measures the pressure in your blood vessels when the heart beats. The bottom number of 90 (diastolic) measures the pressure in your blood vessels when the heart rests between beats.

The Tables below show diastolic blood pressure s for 11 male students and 11 female students at RCC during a heath survey .

	Male students		Female students
Students	Blood pressures in mm Hg	Students	Blood pressures in mm Hg
James	88	Jessica	88
David	83	Lynn	91
Jason	91	Juanita	73
London	98	Jamita	80
Kevin	79	Carolina	82
Steven	84	Mary	72
Gilbert	87	Jeanette	80
John	90	Rachel	77
Donavan	78	Antoinette	78
Paul	92	Paula	78
Peter	90	Michelle	83

Use Excel to Find the mean, median, mode, range, Lower quartile, Upper quartile v ariance, standa rd deviation and coefficient of variation for the above data for both sexes an explain all results in the context of the survey.
Construct a bar graph for both sexes showing the names versus their corresponding diastolic data on the same sheet. Label your graph. The names along with their corresponding data must be displayed on the graph s .
Write a paragraph essay analyzing the result of the mean and coefficient of variance. You analysis should focus on comparing the mean and coefficient of variation for both sexes. Please state which diastolic blood pressures are more consistent, males / females?

Part II ---sheet # 2 (correlation and regression analysis)

The table below shows the final exam scores of 10 randomly selected students and the number of hours they studied prior to the exam.

Hours ( x)	3	5	2	3	8	2	4	10	9	5
Grades	60	85	50	61	91	53	69	100	94	83

Find the y intercept, the slope and coefficient of correlation
Find the equation of the regression line
Construct a scatter plot of the data and draw a line (all on the same graphs)
Predict the grades for someone who study for 6 , 7 hours prior to an exam.
State whether or not there is a correlation between studying and higher grades

(Explain you work and your findings)

Part II I --Grouped data—sheet # 3 )

The table below shows the reading scores of two second-grade classes given individualized instruction and traditional instruction in the same school

Individualized instruction	# of students	Traditional instruction
Scores	# of students	Scores # of students
50 - 59	2	50 - 59	5
60 - 69	4	60 – 69	8
70 - 79	7	70 - 79	8
80 - 89	9	80 - 89 7
90 - 99	8	90 - 99 6

Determ i ne the percentage frequency distribution, mean, variance, standard deviation and coefficient of variation for both Types of instruction .
Construct a pie chart and a histogram of the percentage frequency distribution for both types of instructions.
Use the mean, standard deviation to state which method of instruction is more effective, individualized/traditional, why?