Diana_Cuevas_Newborn_Problem_Workbook

30.4 29.8 33.0 32.0 34.1 33.2 30.1 31.3 35.2 28.7 27.3 32.5 32.5 30.1 28.1 32.4 31.4 27.2 31.3 29.6 31.5 32.2 29.9 30.8 32.5 32.7 29.0 31.0 26.4 33.0 32.9 28.5 34.4 31.2 31.6 31.0 29.5 34.9 30.8 31.4 30.4 28.4 31.8 29.6 body temperature (°C) The data in this sheet will be used for assignm Use the Excel sheets (tabs) labeled " Question all calculations, modeling, and graphing.

ment questions 3-4. n 3 " and " Question 4 " for

Immune cells (per microliter) 8625 7345 7217 6414 5236 10636 7021 4717 6562 9041 6624 4240 6515 8177 9268 8163 5751 3984 5341 4884 6809 5269 5965 7615 10736 9145 6837 8672 3908 4545 7721 7039 3573 7931 6196 6796 8173 6834 6507 6769 6234 7011 7923 4774 The data in this sheet will be used for Use the Excel sheets (tabs) labeled " Q all calculations, modeling, and graphi

r assignment questions 3 and 14. Question 3 " and " Question 14 " for ing.

5610 9306 4472 7991 6480 8467 5511 7720 7220 3948 4941

Sick frogcats Healthy frogcats 30.3 26.4 average 32.2 31.3 31.2 27.0 stdev 1.6 2.1 31.4 27.2 n prob dist 31.9 27.3 34.0 27.9 BIN VALUES FREQUENCY 34.2 28.1 0 28.1 26 26-28 5 28.4 28 28-30 23 28.5 30 30-32 35 28.7 32 32-34 25 28.7 34 34-36 11 28.8 36 36-38 1 28.8 38 38-40 0 28.9 29.0 Temperature Frequency 29.0 26-28 5 29.2 28-30 23 29.2 30-32 35 29.3 32-34 25 29.3 34-36 11 29.4 36-38 1 29.5 38-40 0 29.6 29.6 29.7 29.8 29.8 29.9 30.0 30.1 30.1 30.1 30.2 30.4 30.4 30.4 30.5 30.5 30.5 30.6 30.6 30.7 30.7 30.8 sick body temperature (°C healthy body temperature (°C) 26-28 28-30 30-32 0 5 10 15 20 25 30 35 40 Frequency distribution of bo healthy frogcat Body temp Frequency

For question 4, refer to the sheets (tabs) in this Excel workbo “ DATA- Sick body temps ” and “ DATA- Healthy body temps .” contain body temperatures of sick frogcats (N = 6) and body temperatures of healthy frogcats (N = 100), respectively. Use this Excel sheet for calculations, modeling, and graphing calculated values to the nearest tenth of a decimal place. Fo if you calculate the value as 3.8218, round to 3.8. Refer to the lab packet document for specific Excel formattin instructions. 32-34 34-36 36-38 38-40 ody temperature (°C) of a perature (°C)

ook labeled ” These y g. Round all or example, ng

Immune cells (sick)Immune cells (healthy) 4166 2717 BINS VALUES FREQ 5512 3062 4000 2700-4000 8 5981 3330 5300 4000-5300 12 6229 3448 6600 5300-6600 30 7282 3573 7900 6600-7900 28 7466 3908 9200 7900-9200 14 3948 10500 9200-10500 5 3984 11000 10500-11000 3 4089 4240 4371 average 6630 4472 stdev 1717 4545 4646 4717 4774 4884 4941 5236 5269 5341 5499 5511 5522 5541 5610 5641 5742 5746 5751 5965 6012 6023 6066 6084 6164 6190 6196 6234 6284 6346 6360 1 31.4 48.1% 6373 2 34.2 8.4% 6414 3 31.9 38.8% 2700- 4000 4000- 5300 5300- 6600 0 5 10 15 20 25 30 35 Frequency distribution of imm microliter) of a healthy frogca Immune cell concen Frequency

6480 4 30.3 68.3% 6480 5 31.2 51.9% 6481 6 34 9.9% 6507 6515 1 5981 64.7% 6562 2 7466 31.3% 6624 3 7282 35.2% 6693 4 4166 92.4% 6725 5 5512 74.3% 6746 6 6229 59.2% 6769 6772 6796 6809 6834 6837 6887 6991 7011 7021 7039 7123 7196 7217 7220 7289 7315 7345 7516 7615 7720 7721 7769 7875 7923 7931 7987 7991 8163 8173 8177 8467 8625 8672

8733 8877 9041 9145 9216 9268 9306 9584 10079 10636 10736 10955

For question 14, refer to the sheets (tabs) in this Excel workbook labeled “ DATA- Sick immune cells ” and “ DATA- Healthy immune cel These contain immune cell concentrations of sick frogcats (N = 6) an immune cell concentrations of healthy frogcats (N = 100), respective Use this Excel sheet for calculations, modeling, and graphing. Round calculated values to the nearest whole number. For example, if you calculate the value as 213.8218, round to 214. Refer to the lab packet document for specific Excel formatting instructions. 6600- 7900 7900- 9200 9200- 10500 10500- 11000 mune cell concentration (per at ntration (per microliter)

lls .” nd ely. d all