Search for question
Question

You chose one of the following topics of your interest

▪ Systolic Blood Pressure (BP) measurements of patients before and after medication treatment

Fasting blood sugar measurements of patients before and after medication treatment

College students' Heart rate per min before and after 30 min aerobic workout

Statistics Exam 1 grades of 2 classes taught by the same professor

Annual income of family/cases under Department of Child Services (DCS) in two local DCS offices

I

I

I

Patients' Length of stay after heart bypass surgery in two hospitals

Patients' Length of stay after hip replacement surgery in two hospitals

Participants' body weight before and after 3 months' of two different exercise programs

Ages of nurses in a critical access hospital and an acute care hospital

Make up 30 data/values for each group/n▪ Set up 4 categories and determine 4 bins needed for each category to do your frequency and relative frequency

calculation. If you can justify (special benchmarks used in your professional field such as blood pressure

(normal, pre-hypertension, hypertension), 3 categories will work for this assignment as well.

Use EXCEL functions:

Calculate Frequency and Relative frequency for each group

Use column chart to present the data.

You need to place both groups' data in one chart. You can refer to the YuJa class for detail instruction.

▪ Write a paragraph to describe your data. Is there any difference in the data distribution between these

two groups? You need to use the Relative frequencies you calculated in your description. Insert a

textbox next to your chart for the summary writing.

Submit your EXCEL file and answer to Blackboard via EXCEL Assignment & Submission folder link in the

Weekly Modules

Name your file as E1_Classtime_Your last name. For example, the E1 Assignment file submit by Ferng at

5:30 pm class will be E1_530_ferng; the E1 Assignment file submit by Ferng at web class will be

E1_w_ferng.

Fig: 1

Fig: 2