Lab04.pdf.pdf - Adobe Reader File Edit View Open Window Help T ]' < 100% Tools * Fill & Sign Comment Sign In Checkpoint 4 Referring to the datasets downloaded in Practical 1, "Acron.xls" contains data about acorn size in Oak trees Source: Aizen and Patterson (1990), Journal of Biogeography, 17, 327-332 Fifty species of oak trees grow in the United States. Twenty-eight species of oak from the Atlantic region and eleven from the California region were studied. The size of each species' acorns was measured, expressed as a volume in cm. (Measurements of length and width were used to estimate an ellipsoidal volume.) The range of the species and the species tree height were also determined. The data are given in the Excel workbook acorn.xls. This exercise is concerned with acorn size, and whether geography (Atlantic or California) is a factor. Export PDF Create PDF Edit PDF Adobe Acrobat Pro Easily edit text and images in PDF documents Start Now Combine PDF Send Files Store Files Present your answers to the following in a one (1) page MS-word document. TOP half page Complete the below table Atlantic Califonia Five-number summary ? (which 5 numbers?) ? ? ? ? IQR (Inner) Fences Upper fence: Lower fence: Outliers (if any) Upper outliers: Lower outliers: Adjacent values (if applicable) Upper: Lower: 18:18 21-03-2023 will acorn - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW * Cut Arial 10 ' Wrap Text Copy Paste BIU - A Format Painter Clipboard Font Alignment Merge & Center General Conditional Format as Neutral .00 0 Formatting Table Number AutoSum Normal Bad Good Z Fill Calculation Check Cell Insert Delete Format Clear Sort & Find & Filter Select Styles Editing Cells A1 fx Genus A B C D E F G H K L M N 0 P Q R S T U V W Y Z AA AB AC AD AE AF 1 Genus Species 2 Quercus agrifolia Subspecies Region Range Nee. Acorn_size Tree Height California 803 2.6 23 Quercus alba 4 Quercus bicolor 5 L Atlantic 24196 1.4 27 Willd. Atlantic 7900 3.4 21 Quercus Chapmanii 6 Quercus chrysolepis Sarg Atlantic 1598 0.9 15 7 Quercus coccinea Liebm. Muenchh. California 690 17.1 15 8 Quercus Douglasii Hook. &Arn Atlantic Californial 8992 12 4 559 4.1 18 9 Quercus dumosa Nutt. Californial 433 1.6 16 6 10 Quercus Durandii Buckl. Atlantic 1745 0.8 23 11 Quercus Engelmannii Greene California 259 2 17 12 Quercus falcata Michx. Atlantic 13688 1.8 30 13 Quercus Garryana Hook. California 1061 5.5 20 14 Quercus ilicifolia Wang. Atlantic 4082 1.1 15 Quercus imbricaria Michx. Atlantic 14870 1.8 18 16 Quercus incana Bartr. Atlantic 3775 0.6 13 17 Quercus Kelloggii Newb. Californial 826 6 26 18 Quercus Laceyi Small. Atlantic 233 0.3 11 19 Quercus laevis Walt. Atlantic 3978 4.8 9 20 Quercus laurifolia Michx. Atlantic 5328 1.1 27 21 Quercus lobata Nee California 8701 5.9 30 22 Quercus lyrata 23 Quercus macrocarpa Walt. Atlantic 8982 18 24 Michx. Atlantic 23038 9.1 25 24 Quercus marilandica Muenchh. Atlantic 18480 3.6 9 25 Quercus Michauxii Nutt. Atlantic 8897 6.8 0.3 26 Quercus Muehlenbergii Engelm Atlantic 17042 2 24 27 Quercus myrtifolia Willd. Atlantic 2540 0.4 9 28 Quercus nigra Atlantic 10161 1.1 24 29 Quercus palustris Muenchh. Atlantic 8643 11 23 30 Quercus Phellos. L Atlantic 9920 3.6 27 31 Quercus prinoides 32 Quercus Prinus Willd. Atlantic 17042 16 3 L. Atlantic 7646 10.5 24 33 Quercus rubra L. Atlantic 28389 8.1 24 34 Quercus stellata 35 Quercus texana Wang. Buckl. Atlantic 19938 2.5 17 Atlantic 829 1.1 9 36 Quercus tomentella 37 Quercus vaccinifolia Engelm California 13 7.1 18 Engelm. California 223 0.4 1 38 Quercus velutina Lam. Atlantic 21067 3.6 23 39 Quercus virginiana Mill Atlantic 7985 0.9 15 40 Quercus Wislizenii A. DC. California 699 1 21 41 42 43 44 45 46 47 48 49 READY O acorn O ]' 19:18 23-03-2023 + 70%