03-3 Using previously learned techniques load the data for Exercise 1.5 (page 16) into the CrunchIt spreadsheet environment. Click the \"Graphics\" tab and select \"Histogram\". In the \"Sample\" box select \"Rate\" Specify the histogram drawing parameters as follows: Set \"Bin Width\" to 10 and \"Start Bins At\" to 10. Leave \"Number of Bins\" blank. Click \"Calculate\" to draw the histogram of the data. Using previously learned techniques submit a copy of this histogram by either pasting the graph into the body of this assignment template or by pasting a copy into a Word document and then attaching this Word document to your submitted assignment template. Assignment 05-1 Apply the following steps to change the number of digits and decimal places that CrunchIt will display: CrunchIt Precision Setup Requirement: Select the CrunchIt tab. Next select Preferences. Change Precision: Mean (digits) values to 7 digits. Click \"OK\" Load the \"Glucose levels\" data given in Exercise 2.6 on page 47. This data corresponds to Exercise 06 from the Chapter 2 CrunchIt data sets. Use CrunchIt to generate the table that contains the mean value of this \"Glucose levels\" data. Using previously learned techniques submit a copy of this CrunchIt generated table by either pasting the table into the body of this assignment template or by pasting a copy into a Word document and then attaching this Word document to your submitted assignment template. Assignment 06-1 (a) Load the data given in Exercise 06 from the Chapter 2 CrunchIt data set into the CrunchIt spreadsheet environment and answer part (a) using this data set. Only use this Exercise 06 data set for part (a). Using previously learned techniques submit a copy of this CrunchIt generated table showing the five number summary by either pasting this table into the body of this assignment template or by pasting a copy of this table into a Word document and then attaching this Word document to your submitted assignment template. (b) Part (b) of Exercise 2.6 requires you to draw side-by-side Box Plots of the data in Exercise 06 (page 47) from Chapter 2 and Exercise 09 (page 23) of Chapter 1. CrunchIt is capable of creating side-by-side Box Plots as long as both data sets exist simultaneously in the CrunchIt! spreadsheet. However there is a problem. The \"File\" selection method cannot be used to enter two different sets of data into the CrunchIt spreadsheet environment. One of these two data sets will have to be entered manually. Remember to select both data sets in the Box Plot setup window before you click the \"Calculate\" button. After drawing side-by-side Box Plots onto a single graph submit a copy of this single graph by either pasting the graph into the body of this assignment template or by pasting a copy into a Word document and then attaching this Word document to your submitted assignment template. Assignment 03-03 Exercise 1-5 coming from page 16 Healing of skin wounds. Biologists studying the healing of skin wounds measured the rate at which new cells closed a razor cut made in the skin of an anesthetized newt. Here are the sorted datafrom18 newts, measured in micrometers (millionths of a meter) per hour: 11 12 14 18 22 22 23 23 26 27 28 29 30 33 34 35 35 40 Make a histogram of the healing rates using classes of width 5 micrometers/hour starting at 10 micrometers/hour. (Make this histogram by hand even if you have software, to be sure you understand the process. You may want to compare your histogram with your software's choice.) Assignment 05-1 page 47 Exercise 2.6 Glucose levels, continued. People with diabetes must monitor and control their blood glucose level. The goal is to maintain a \"fasting plasma glucose\" between about 90 and 130 milligrams per deciliter (mg/dl). Exercise 1.9 (page 23) provides the fasting plasma glucose levels for 18 diabeticsenrolledinadiabetescontrolclass, ve months after the end of the class. Here are the data for 16 diabetics who re ceived individual instruction instead: 128 195 188 158 227 198 163 164 159 128 283 226 223 221 220 160 (a) Calculate the ve-number summary for each of the two data sets. (b) Make side-by-side box plots comparing the two groups (as in Figure 2.1). What can you say from the graph about the differences between the two diabetes control training methods? Assignment 06-1 Take both exercise above and use the first one fro part 1 and the second one for part 2 Assignment 03-03 Exercise 1-5 coming from page 16 Healing of skin wounds. Biologists studying the healing of skin wounds measured the rate at which new cells closed a razor cut made in the skin of an anesthetized newt. Here are the sorted datafrom18 newts, measured in micrometers (millionths of a meter) per hour: 11 12 14 18 22 22 23 23 26 27 28 29 30 33 34 35 35 40 Make a histogram of the healing rates using classes of width 5 micrometers/hour starting at 10 micrometers/hour. (Make this histogram by hand even if you have software, to be sure you understand the process. You may want to compare your histogram with your software's choice.) The obtained histogram is given below, Assignment 05-1 page 47 Exercise 2.6 Glucose levels, continued. People with diabetes must monitor and control their blood glucose level. The goal is to maintain a \"fasting plasma glucose\" between about 90 and 130 milligrams per deciliter (mg/dl). Exercise 1.9 (page 23) provides the fasting plasma glucose levels for 18 diabetics enrolled in a diabetes control class, ve months after the end of the class. Here are the data for 16 diabetics who received individual instruction instead: 128 195 188 158 227 198 163 164 159 128 283 226 223 221 220 160 (a) Calculate the ve-number summary for each of the two data sets. The obtained ve-number summary for each of the two data sets is given below. Columns -- Selected Field: Individual instruction, Control Class Control_Class Statistic Result Minimum 78 Maximum 359 First Quartile 112 Third Quartile 172 Median 147.5000000 Individual_instruction Statistic Result Minimum 128 Maximum 283 First Quartile 159.5000000 Third Quartile 222 Median 191.5000000 (b) Make side-by-side box plots comparing the two groups (as in Figure 2.1). What can you say from the graph about the differences between the two diabetes control training methods? The side by side box plot is given below, The obtained chart shows that the Control class has 2 outliers where as individual instruction has none. However the fasting plasma glucose levels are much lower on an average for control class than the individual instruction. Assignment 06-1 Take both exercise above and use the first one from part 1 and the second one for part 2 The obtained 5 number summary is given below, Columns -- Selected Field: datafrom18 newts datafrom18_newts Statistic Result Minimum 11 Maximum 40 First Quartile 22 Third Quartile 33 Median 26.5000000 And the obtained histogram is given below, Assignment 03-03 Exercise 1-5 coming from page 16 Healing of skin wounds. Biologists studying the healing of skin wounds measured the rate at which new cells closed a razor cut made in the skin of an anesthetized newt. Here are the sorted datafrom18 newts, measured in micrometers (millionths of a meter) per hour: 11 12 14 18 22 22 23 23 26 27 28 29 30 33 34 35 35 40 Make a histogram of the healing rates using classes of width 5 micrometers/hour starting at 10 micrometers/hour. (Make this histogram by hand even if you have software, to be sure you understand the process. You may want to compare your histogram with your software's choice.) The obtained histogram is given below, Assignment 05-1 page 47 Exercise 2.6 Glucose levels, continued. People with diabetes must monitor and control their blood glucose level. The goal is to maintain a \"fasting plasma glucose\" between about 90 and 130 milligrams per deciliter (mg/dl). Exercise 1.9 (page 23) provides the fasting plasma glucose levels for 18 diabetics enrolled in a diabetes control class, ve months after the end of the class. Here are the data for 16 diabetics who received individual instruction instead: 128 195 188 158 227 198 163 164 159 128 283 226 223 221 220 160 (a) Calculate the ve-number summary for each of the two data sets. The obtained ve-number summary for each of the two data sets is given below. Columns -- Selected Field: Individual instruction, Control Class Control_Class Statistic Result Minimum 78 Maximum 359 First Quartile 112 Third Quartile 172 Median 147.5000000 Individual_instruction Statistic Result Minimum 128 Maximum 283 First Quartile 159.5000000 Third Quartile 222 Median 191.5000000 (b) Make side-by-side box plots comparing the two groups (as in Figure 2.1). What can you say from the graph about the differences between the two diabetes control training methods? The side by side box plot is given below, The obtained chart shows that the Control class has 2 outliers where as individual instruction has none. However the fasting plasma glucose levels are much lower on an average for control class than the individual instruction. Assignment 06-1 Take both exercise above and use the first one from part 1 and the second one for part 2 The obtained 5 number summary is given below, Columns -- Selected Field: datafrom18 newts datafrom18_newts Statistic Result Minimum 11 Maximum 40 First Quartile 22 Third Quartile 33 Median 26.5000000 And the obtained histogram is given below