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.