1. Suppose you are interested in estimating the mean egg length (in mm.) for the New Zealand bird population. The follow
Posted: Mon Nov 15, 2021 12:20 pm
QUESTION MUST BE SUBMITTED IN EXCEL. ANSWERS FOR THIS QUESTION IN ANOTHER FORMAT WILL NOT BE CONSIDERED. b) Determine the best point estimate of the mean of egg lengths from all New Zealand birds. c) In a previous study, it was found that the standard deviation of the lengths of eggs from all new Zealand birds was 41.2 mm. Construct a 99% confidence interval for the mean egg length of birds found in New Zealand. YOU HAVE TO DETERMINE THE C.1. USING THE EXCEL COMMANDS SHOWN IN CLASS. THE ANSWER TO THIS QUESTION MUST BE SUBMITTED IN EXCEL. ANSWERS FOR THIS QUESTION IN ANOTHER FORMAT WILL NOT BE CONSIDERED. d) If we find an egg from a New Zealand bird, and the length of the egg is 79 mm, how this length compare with the average egg length of birds from New Zealand? BASE YOUR CONCLUSION ON THE C.V. OBTAINED. EXPLAIN VERY WELL YOUR ANSWER
250 Species Name Grebes P. cristatus Grebes P. rufopectus Petrels P. gavia Petrels P. huttoni Petrels P.spelaeus Petrels P. assimilis Petrels P. urinatrix Petrels P.georgicus Petrels P. turtur Petrels P.pycrofti Petrels P.cookii Petrels G. nereis Petrels P. marina Petrels P. inexpectata Petrels P.macroptera Petrels P.griseus Petrels P. parkinsoni Petrels P. westlandica Penguins E. minor Penguins E. pachyrhynchus Penguins M. antipodes Shags P. melanoleucos Shags S. punctatus Shags P. carbo Shags P. varius Shags L. carunculatus Shags L. chalconotus Herons E. alba Herons E. sacra Herons B. poiciloptilus Herons 1. novaezelandiae Waterfowl A. superciliosa Waterfowl A. gracilis Waterfowl A. chlorotis Waterfowl M. australis Waterfowl E. finschl Waterfowl M. scarletti Extinct No No Yes Absent Absent Yes Yes No Yes Yes No Yes Yes No No No No Absent No Yes Yes Body Mass Egg Length 1100 57 250 43 300 57 350 60 55 200 54 130 38 120 39 125 44 160 49 200 50 35 31 45 36 325 61 500 67 800 77 700 69 1100 81 1100 56 4000 67 5250 77 700 48 1200 58 2200 61 2000 59 2500 65 2500 66 900 52 46 1000 51 150 46 1000 58 425 SO 500 60 900 57 800 56 800 56 No 400 No No No Yes No Yes No No No No No No Yes Yes Yes
سالاد ,TTL II 2 Tot Waterfowl H. malacorhynchos No Waterfowl A. novaeseelandiae No Waterfowl C. gracilis Yes Waterfowl C. calcitrans Absent Waterfowl C. atratus Yes Waterfowl T. varlegata No Waterfowl B. delautour Yes Falcons F. novaeseelandiae No Falcons C. eytesi Yes Falcons H. moorel Absent Gamebirds C. novaezealandiae No Rail G. philippensis No Rails G. australis No Rails P. tabuensis No Rails P. pusilla No Rails F. prisca Yes Rails C. karamu Yes Rails G. hodgenorum Yes Ralls P. hochstetteri Absent Rails P. mantelli No Shorebirds H. ostralegus No Shorebirds H. unicolor No Shorebirds H. novaezelandiae No Shorebirds C. obscurus No Shorebirds C. novaezelandiae No Shorebirds C.bicinctus No Shorebirds C. frontalis Absent Shorebirds C. barrierensis Yes Shorebirds C. South Island Absent Shorebirds C. Iredale! Absent Gulls La novaehollandiae Gulls L. bulleri No Gulls S.albostriata No Gulls S. striata No Gulls S. nerels Gulls L. dominicanus No Gulls S. caspia No Gulls C. skua No Gulls M. serrator No DUO 750 650 8000 10000 5000 1400 2000 500 2500 12000 100 170 700 45 40 1000 275 450 3000 3500 550 725 220 145 60 60 55 105 105 105 260 250 80 160 70 850 700 1950 2300 65 64 105 110 104 67 76 49 0 0 30 40 58 30 28 57 43 48 74 75 56 59 45 46 37 34 35 42 42 42 52 55 40 46 35 69 68 74 77 No 配记忆见历如阳阳的比对刀 No
TV Slow 300 650 2000 425 800 70 40 35 25 125 65 175 49 51 42 44 25 24 23 18.5 23 29 38 48 35 16 20 20 600 200 26 Pigeons H. novaeseelandiae No Parrots S. habroptilus No Parrots N. meridionalis No Parrots N. notabilis No Parrots C. novaezelandiae No Parrots C. auriceps No Parrots C. malherbi No Cuckoos C. lucidus No Cuckoos E. taitensis No Kingfishers H. sancta No Owls N. novaeseelandiae No Owls S. albifacies No Owlets A. novaezealandiae Yes Songbirds A. chloris No Songbirds X. longipes No Songbirds X. gilviventris No Songbirds P. yaldwyni Yes Songbirds T. Iyalli Yes Songbirds D. decurvirostris Absent Songbirds A. novaeseelandiae No Songbirds B. punctata No Songbirds M. albicilla No Songbirds M. achrocephala Absent Songbirds M. novaeseelandiae No Songbirds G. Igata No Songbirds R. fulginosa No Songbirds P. macrocephala Songbirds P. australis No Songbirds N. cincta No Songbirds A. melanura No Songbirds P. novaeseelandiae No Songbirds C. cinerea Absent Songbirds C. wilsoni Songbirds P. carunculatus Absent Songbirds P. rufusater No Songbirds H. acutirostris No Songbirds T. capensis Absent Songbirds T. tanagra No Songbirds C. moriorum Yes 7 16 20 50 22 40 40 35 15 25 11 No 21 23 23 19.5 20 23.5 18.5 17 16 18 25 19 23 29 40 35 29 29 45 35 35 56 No 8 11 35 30 26 90 230 230 70 70 300 130 130 950 229
Kiwis A.E.S. Island Absent Kiwis A. australis No Kiwis A. owenii No Kiwis A. haastii No Moas A. didifonnis Yes Moas M. didinus Yes Moas P. elephantopus Yes Moas P. australis Yes Moas P. mappini Yes Moas E. crassus Yes Moas E. geranoides Yes Moas E. curtus Yes Moas D. struthoides Yes Moas D. novaezealandiae Yes Moas D. giganteus Yes Gruiforms A. defossor Absent Gruiforms A. otidiformis Yes 1400 1500 1200 220 50000 20000 145000 120000 20000 50000 95000 20000 100000 150000 200000 10000 8000 bb 120 125 110 124 160 125 216 205 125 160 192 125 195 218 236 94 90
1. Suppose you are interested in estimating the mean egg length (in mm.) for the New Zealand bird population. The following link will direct you to an Excel table containing all the information collected from a simple random sample of 132 New Zealand birds: New Zealand birds.xlsx a) Find the mean and the standard deviation of the egg lengths measured in this sample. YOU HAVE TO DETERMINE THESE MEASURES USING THE EXCEL COMMANDS SHOWN IN CLASS. THE ANSWER TO THIS 250 Species Name Grebes P. cristatus Grebes P. rufopectus Petrels P. gavia Petrels P. huttoni Petrels P.spelaeus Petrels P. assimilis Petrels P. urinatrix Petrels P.georgicus Petrels P. turtur Petrels P.pycrofti Petrels P.cookii Petrels G. nereis Petrels P. marina Petrels P. inexpectata Petrels P.macroptera Petrels P.griseus Petrels P. parkinsoni Petrels P. westlandica Penguins E. minor Penguins E. pachyrhynchus Penguins M. antipodes Shags P. melanoleucos Shags S. punctatus Shags P. carbo Shags P. varius Shags L. carunculatus Shags L. chalconotus Herons E. alba Herons E. sacra Herons B. poiciloptilus Herons 1. novaezelandiae Waterfowl A. superciliosa Waterfowl A. gracilis Waterfowl A. chlorotis Waterfowl M. australis Waterfowl E. finschl Waterfowl M. scarletti Extinct No No Yes Absent Absent Yes Yes No Yes Yes No Yes Yes No No No No Absent No Yes Yes Body Mass Egg Length 1100 57 250 43 300 57 350 60 55 200 54 130 38 120 39 125 44 160 49 200 50 35 31 45 36 325 61 500 67 800 77 700 69 1100 81 1100 56 4000 67 5250 77 700 48 1200 58 2200 61 2000 59 2500 65 2500 66 900 52 46 1000 51 150 46 1000 58 425 SO 500 60 900 57 800 56 800 56 No 400 No No No Yes No Yes No No No No No No Yes Yes Yes
سالاد ,TTL II 2 Tot Waterfowl H. malacorhynchos No Waterfowl A. novaeseelandiae No Waterfowl C. gracilis Yes Waterfowl C. calcitrans Absent Waterfowl C. atratus Yes Waterfowl T. varlegata No Waterfowl B. delautour Yes Falcons F. novaeseelandiae No Falcons C. eytesi Yes Falcons H. moorel Absent Gamebirds C. novaezealandiae No Rail G. philippensis No Rails G. australis No Rails P. tabuensis No Rails P. pusilla No Rails F. prisca Yes Rails C. karamu Yes Rails G. hodgenorum Yes Ralls P. hochstetteri Absent Rails P. mantelli No Shorebirds H. ostralegus No Shorebirds H. unicolor No Shorebirds H. novaezelandiae No Shorebirds C. obscurus No Shorebirds C. novaezelandiae No Shorebirds C.bicinctus No Shorebirds C. frontalis Absent Shorebirds C. barrierensis Yes Shorebirds C. South Island Absent Shorebirds C. Iredale! Absent Gulls La novaehollandiae Gulls L. bulleri No Gulls S.albostriata No Gulls S. striata No Gulls S. nerels Gulls L. dominicanus No Gulls S. caspia No Gulls C. skua No Gulls M. serrator No DUO 750 650 8000 10000 5000 1400 2000 500 2500 12000 100 170 700 45 40 1000 275 450 3000 3500 550 725 220 145 60 60 55 105 105 105 260 250 80 160 70 850 700 1950 2300 65 64 105 110 104 67 76 49 0 0 30 40 58 30 28 57 43 48 74 75 56 59 45 46 37 34 35 42 42 42 52 55 40 46 35 69 68 74 77 No 配记忆见历如阳阳的比对刀 No
TV Slow 300 650 2000 425 800 70 40 35 25 125 65 175 49 51 42 44 25 24 23 18.5 23 29 38 48 35 16 20 20 600 200 26 Pigeons H. novaeseelandiae No Parrots S. habroptilus No Parrots N. meridionalis No Parrots N. notabilis No Parrots C. novaezelandiae No Parrots C. auriceps No Parrots C. malherbi No Cuckoos C. lucidus No Cuckoos E. taitensis No Kingfishers H. sancta No Owls N. novaeseelandiae No Owls S. albifacies No Owlets A. novaezealandiae Yes Songbirds A. chloris No Songbirds X. longipes No Songbirds X. gilviventris No Songbirds P. yaldwyni Yes Songbirds T. Iyalli Yes Songbirds D. decurvirostris Absent Songbirds A. novaeseelandiae No Songbirds B. punctata No Songbirds M. albicilla No Songbirds M. achrocephala Absent Songbirds M. novaeseelandiae No Songbirds G. Igata No Songbirds R. fulginosa No Songbirds P. macrocephala Songbirds P. australis No Songbirds N. cincta No Songbirds A. melanura No Songbirds P. novaeseelandiae No Songbirds C. cinerea Absent Songbirds C. wilsoni Songbirds P. carunculatus Absent Songbirds P. rufusater No Songbirds H. acutirostris No Songbirds T. capensis Absent Songbirds T. tanagra No Songbirds C. moriorum Yes 7 16 20 50 22 40 40 35 15 25 11 No 21 23 23 19.5 20 23.5 18.5 17 16 18 25 19 23 29 40 35 29 29 45 35 35 56 No 8 11 35 30 26 90 230 230 70 70 300 130 130 950 229
Kiwis A.E.S. Island Absent Kiwis A. australis No Kiwis A. owenii No Kiwis A. haastii No Moas A. didifonnis Yes Moas M. didinus Yes Moas P. elephantopus Yes Moas P. australis Yes Moas P. mappini Yes Moas E. crassus Yes Moas E. geranoides Yes Moas E. curtus Yes Moas D. struthoides Yes Moas D. novaezealandiae Yes Moas D. giganteus Yes Gruiforms A. defossor Absent Gruiforms A. otidiformis Yes 1400 1500 1200 220 50000 20000 145000 120000 20000 50000 95000 20000 100000 150000 200000 10000 8000 bb 120 125 110 124 160 125 216 205 125 160 192 125 195 218 236 94 90