Question

In: Statistics and Probability

Working with a “real” sample The attached file Bill_length.csv lists a sample of bill size ratios...


Working with a “real” sample
The attached file Bill_length.csv lists a sample of bill size ratios of bird species (data retrieved
from a Seattle Central College data repository) Consider it a simple random sample of size 410
(please, do not try to key in data by hand!)
Compute the following for the sample:
• Sample Mean
• Sample Variance
• Sample Standard Deviation
• Median
• 1st and 3rd quartiles
• Have your spreadsheet draw a histogram
If you would like to compare your spreadsheet results with “simple calculator” calculations, here
are the summaries:
• count 410
• sum 476.09
• sum of squares 562.9371

Bill-Size Ratios of Bird Species (n=410)
Schoener, T. W. (1965)

species bill ratio (large to small culmen)
C. caribaea 1.00
T. rujus 1.00
Dendrocincla anabatina 1.00
P. ater 1.00
Thryothorus modestus 1.00
T. zeledoni 1.00
D. trigonostigma 1.00
Dendroica tigrina 1.00
D. fusca 1.00
B. tristriatus 1.00
T. minura 1.00
T. nigrocincta 1.00
Amphispiza bilineate 1.00
S. pinus 1.00
Spinus psaltria 1.00
A. botteri 1.00
B. lagopus 1.01
R. longirostris 1.01
G. lawrenci 1.01
A. rutila 1.01
A. amabilis 1.01
T. violaceus 1.01
T. violaceus 1.01
Myrmotherula axillaris 1.01
Tyrannus dominicensis 1.01
Myiarchus nuttingi 1.01
S. castanca 1.01
C. guttatus 1.01
C. mexicanus 1.01
C. frantzi 1.01
Sialis sialis 1.01
Turdus assimilis 1.01
D. australe 1.01
D. virens 1.01
T. icterocephala 1.01
Pipilo fuscus 1.01
B. jamaicensis 1.02
B. nitidus 1.02
B. jamaicensis 1.02
Odontophorus leucolaemus 1.02
A. tzacatl 1.02
Trogan collaris 1.02
T. collaris 1.02
D. stricklandi 1.02
Myrmeciza longipes 1.02
Thamnophilus punctatus 1.02
Grallaria fulviventris 1.02
Aphelocoma ultramarina 1.02
T. atrogularis 1.02
T. lecontei 1.02
Catharus minimus 1.02
C. fuscater 1.02
Myadestes obscurus 1.02
T. lavinia 1.02
Ramphocelus passerini 1.02
Lonchura leucogastra 1.02
Tiaris bicolor 1.02
A. mystacalis 1.02
P. ocai 1.02
O. choliba 1.03
Columba subvinacea 1.03
A. ambigua 1.03
Lophornis helenae 1.03
A. yucatanensis 1.03
T. aurantiiventris 1.03
Halcyon winchelli 1.03
Lepidocolaptes affins 1.03
Elaenia frantzi 1.03
C. ochraceus 1.03
Myiodynastes hemichrysus 1.03
P. hudsonicus 1.03
T. fasciato-ventris 1.03
T. migratorius 1.03
Microligea palustris 1.03
Tanagra affinis 1.03
T. gyrola 1.03
Spizella passerina 1.03
Melospiza lincolni 1.03
Saltator maximus 1.03
Hesperiphona abeillei 1.03
Spizactus tyrannus 1.04
O. guatemalae 1.04
Ptilinopus occipitalis 1.04
A. collaria 1.04
Anthracothorax viridis 1.04
T. massena 1.04
Ceyx melanurus 1.04
Tityra semifasciata 1.04
Pipra mentalis 1.04
T. musculus 1.04
T. rufalbus 1.04
Campylorhynchus rufinucha 1.04
T. grayi 1.04
Phylloscopus horealis 1.04
Myioborus torquatus 1.04
Basileuterus delatri 1.04
Agelaius tricolor 1.04
I. chrysater 1.04
Habia fuscicauda 1.04
A. quinquestriata 1.04
Dendrortyx barbatus 1.05
E. fuscicollis 1.05
Leptotila plumbeiceps 1.05
Tanygnathus sumatranus 1.05
S. flammula 1.05
A. tzacatl 1.05
Heliomaster constanti 1.05
Sphyrapicus thyroides 1.05
Empidonax flaviventris 1.05
Tolmomyias assimilis 1.05
Pitta sordida 1.05
A. unicolor 1.05
Parus atricapillus 1.05
T. plebejus 1.05
V. gilvus 1.05
Vermivora peregrina 1.05
Dacnis cayana 1.05
S. schistacea 1.05
S. notatus 1.05
Aimophila notosticta 1.05
A. ruficauda 1.05
A. brunnei-nucha 1.05
B. lineatus 1.06
A. flammeus 1.06
Columba leucocephala 1.06
C. inornata 1.06
C. squamosa 1.06
Caccyzus minor 1.06
Chaetura rinerciventris 1.06
Calypte anna 1.06
A. virifrons 1.06
T. malnurus 1.06
C. pucherani 1.06
Xenops minutus 1.06
Myiobius sulphureipygius 1.06
Myiozetetes similis 1.06
Cisticola juncidis 1.06
H. coclestsis 1.06
V. gilvus 1.06
V. solitarius 1.06
V. chrysoptera 1.06
T. lauta 1.06
Loxia curvirostra 1.06
S. aurita 1.06
Campylopterus rulus 1.07
Xiphorhynchus lachrymosus 1.07
E. trailli 1.07
Contopus cinereus 1.07
Orthotomus atrogularis 1.07
D. pharetra 1.07
D. petechia 1.07
D. petechia 1.07
I. wagleri 1.07
T. luteiacapilla 1.07
T. anneae 1.07
T. chrysophyrs 1.07
Thraupis palmarum 1.07
R. icteronatus 1.07
Cyanerpes lucidus 1.07
C. cassini 1.07
A. brunnei-nucha 1.07
P. albicollis 1.07
Claravis pretrosa 1.08
L. verrcauxi 1.08
C. hemilcucurus 1.08
D. arizonae 1.08
X. guttatus 1.08
Pachyramphus cinnamomeus 1.08
T. vociferans 1.08
C. cucullata 1.08
T. semibadius 1.08
T. dorsale 1.08
T. curvirostre 1.08
C. fuscescens 1.08
Seiurus motacilla 1.08
B. melanogenys 1.08
I. pectoralis 1.08
Tachyphonus delatri 1.08
B. harlan 1.09
G. caniceps 1.09
G. violacea 1.09
Ducula aenea 1.09
Sclerurus mexicanus 1.09
Cercomacra nigricans 1.09
T. cinercum 1.09
I. wagleri 1.09
T. olivacea 1.09
Acanthus flammea 1.09
B. regalis 1.10
Chordeiles minor 1.10
C. rutilus 1.10
C. esculenta 1.10
Lampornis demenciae 1.10
Dendrocolaptes picumnus 1.10
M. fulviventris 1.10
Dicaeum pygmaeum 1.10
V. flavifrons 1.10
V. leucophyrs 1.10
D. castanea 1.10
Icterus galbula 1.10
Sporophila nigricollis 1.10
Spinus atriceps 1.10
Passerina leclancheri 1.10
Melozone leucotis 1.10
Zenaida aurita 1.11
Columbigallina talpacoti 1.11
P. guy 1.11
T. elegans 1.11
Todirostrum sylvia 1.11
Hylophilus ochraceiceps 1.11
A. ruficauda 1.11
F. rusticolus 1.12
Fulica americana 1.12
Laterallus albigularis 1.12
Amauronis olivacea 1.12
C. speciosa 1.12
D. villosus 1.12
Phloeoceastes haematogaster 1.12
Pycnontus goiavier 1.12
T. ocellatum 1.12
V. olivaceus 1.12
I. mesomelas 1.12
P. flava 1.12
M. melodia 1.12
B. albicaudatus 1.13
O. asio 1.13
A. ochrecephala 1.13
A. farinosa 1.13
C. inda 1.13
Todus subulatus 1.13
Formicarius nigricapillus 1.13
Polioptila caerula 1.13
Icterus Cucullatus 1.13
Carpodacus pupureus 1.13
B. albicaudatus 1.14
A. rutila 1.14
T. massena 1.14
Colaptes cafer 1.14
Centurus chyrsogenys 1.14
S. himalayensis 1.14
Hypothymis azurca 1.14
I. graduacauda 1.14
Zonotrichia atricapilla 1.14
Aimophila ruficeps 1.14
B. jamaicensis 1.15
D. villosus 1.15
D. villosus 1.15
P. steeri 1.15
S. europea 1.15
Troglodytes aedon 1.15
Regulus calendula 1.15
Piranga rubra 1.15
Pipilo fuscus 1.15
B. albicaudatus 1.16
E. canutus 1.16
Amazilia violiceps 1.16
T. citreolus 1.16
Lepidocolaptes leucogaster 1.16
Xiphorhynchus flavigaster 1.16
Myiarchus stolidus 1.16
M. maculatus 1.16
Turdus fumigatus 1.16
Selasphorus terridus 1.17
T. massena 1.17
Celeus castaneus 1.17
M. fcrox 1.17
D. hypoleucum 1.17
Dendroica petechis 1.17
Arremonops conirostris 1.17
B. jamaicensis 1.18
Aegolius funcreus 1.18
Calothrax lucifer 1.18
T. citreolus 1.18
M. validus 1.18
Corvus macrorhynchus 1.18
B. lineatus 1.19
Otus trichopsis 1.19
Ciccaba nigrolineata 1.19
P. palustris 1.19
C. cayennensis 1.20
Amazona imperialis 1.20
A. finschi 1.20
A. chloroptera 1.20
Crotophaga ani 1.20
Corvus leucognaphalus 1.20
T. castaneus 1.20
Rhipidura javanica 1.20
B. nitidus 1.21
E. mauri 1.21
A. cyanocaphala 1.21
C. brachyrhynchos 1.21
Nectarinia jugularis 1.21
Wilsonia canadensis 1.21
A. rufescens 1.21
G. costaricensis 1.22
Centropus viridis 1.22
P. atricristatus 1.22
P. inornatus 1.22
Hypsipetes everetti 1.22
V. altiloquus h 1.22
I. gularis 1.22
A. tzacatl 1.23
Picoides arcticus 1.23
Piculus rubiginosus 1.23
Tyrannus crassirostris 1.23
P. major 1.23
S. tephronota 1.23
Arachnothera clarae 1.23
D. villosus 1.24
Megalurus palustris 1.24
Asio stygius 1.25
E. melanotos 1.25
E. alpina 1.25
G. versicolor 1.25
H. smyrnensis 1.25
C. aurifrons 1.25
Synallaxis brachyura 1.25
V. altiloquus h? 1.25
Ninox scutulata 1.26
T. clathratus 1.26
Elaenia flavogaster 1.26
T. cubensis 1.26
T. rufus 1.26
Atlapetes albinucha 1.26
Dendrocopos scalaris 1.27
C. nasicus 1.27
Cyanolyoa cucullata 1.27
Stachyrus nigrocapitata 1.27
T. aurantius 1.27
Erolia bairdi 1.28
Collocalia inexpectata 1.28
Eupherusa eximia 1.28
C. thalassinus 1.28
Mimus gundlachi 1.28
S. airiceps 1.28
O. guatemalae 1.29
Acthopyga pulcherrima 1.29
P. rositae 1.29
A. gentilis 1.30
G. chrysia 1.30
C. amazona 1.30
Ramphastos swainsoni 1.30
Caclcus cela 1.30
Piranga bidentata 1.30
A. rufescens 1.30
Z. asiatica 1.31
T. viridis 1.31
C. pertinax 1.31
C. corax 1.31
T. redivivum 1.31
V. flavoviridis 1.31
Sitta carolinensis 1.32
Toxostoma curvirostre 1.32
Agelaius phoeniceus 1.32
A. ochrecephala 1.33
C. melanops 1.33
D. major 1.33
Cassidix mexianus 1.33
T. massena 1.34
N. macrorhynchos 1.35
Tyrannus dominicensis 1.35
S. carolinesnsis 1.35
S. carolinesnsis 1.36
Oryzoborus nuttingi 1.36
B. jamaicensis 1.37
Tyrannus dominicensis 1.37
M. tyrannulus 1.37
A. bicolar 1.39
C. cryptoleucus 1.39
Buteo jamaicensis 1.40
F. femoralis 1.40
Coracina striata 1.40
A. cooperi 1.41
Leucopternis albicollis 1.41
Pheucticus chrysopeplus 1.41
C. major 1.42
C. amierican 1.42
P. bicolor 1.43
V. altiloquus 1.43
O. trichopsis 1.44
Geotrygon mrystacea 1.44
Dendrocopos medius 1.44
Rallus elegans 1.45
Aratinga finschi 1.45
Chloroceryle american 1.45
Notharchus pectoralis 1.45
C. amazona 1.46
Vireo osburni 1.46
Aramides cajanea 1.47
G. guatimalensis 1.47
Micrastur semitorquatus 1.48
Geotrygon chrysia 1.48
C. aurifrons 1.48
F. deiroleucus 1.49
Totanus melanoleucus 1.50
Phapitreron amethystina 1.50
A. holochlora 1.51
Nyctibius grandis 1.52
C. corax 1.53
Margarops fuscatus 1.56
F. peregrinas 1.57
C. aurifrons 1.64
Ara macao 1.66
V. altiloquus 1.69
Cyanocompsa cyanoides 1.70
Dendrocopos villosus 1.72
D. albolarvatus 1.73
Pharthornis superciliosus 1.75
Accipiter gundlachi 1.80
Falco peregrinas 1.87

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

Related Solutions

PYTHON...... Working with lists, functions, and files Objective: Work with lists Work with lists in functions...
PYTHON...... Working with lists, functions, and files Objective: Work with lists Work with lists in functions Work with files Assignment: Part 1: Write a program to create a text file which contains a sequence of test scores. Ask for scores until the user enters an empty value. This will require you to have the scores until the user enters -1. After the scores have been entered, ask the user to enter a file name. If the user doesn’t not enter...
Test the four lists attached to see if there is a difference between the means or...
Test the four lists attached to see if there is a difference between the means or not, then answer the following. Test Statistic = p-value = Decision = Use alpha = 0.05. The four lists come from normally-distributed populations. 3.289999962 3.140000105 2.99000001 3 2.950000048 2.980000019 3.059999943 2.940000057 3.150000095 3  2.809999943 3.039999962 2.809999943 3.079999924 2.920000076 3.230000019 2.99000001 3.200000048 2.880000114 3.029999971 3.00999999 3.180000067 3.029999971 2.779999971 2.970000029 2.910000086 2.75  3.089999914 3.039999962 2.799999952 3.069999933 3.079999924 2.920000076 2.900000095 3.059999943 3.099999905 3.079999924 2.869999886 2.920000076 2.829999924 3.079999924 3.119999886 3.109999895...
ASSIGNMENT: Write a program and use the attached file (babynames.txt) as input file, and create two...
ASSIGNMENT: Write a program and use the attached file (babynames.txt) as input file, and create two output tiles. One file listing out all boys names, and the other file listing out all girls name. CODE: (teacher gave some of the code below use it to find the answer please String B is the boy names String E is girl names) import java.io.File; import java.io.FileNotFoundException; import java.io.PrintWriter; import java.util.Scanner; /** This program reads a file with numbers, and writes the numbers...
ASSIGNMENT: Write a program and use the attached file (babynames.txt) as input file, and create two...
ASSIGNMENT: Write a program and use the attached file (babynames.txt) as input file, and create two output tiles. One file listing out all boys names, and the other file listing out all girls name. CODE: (teacher gave some of the code below use it to find the answer please String B is the boy names String E is girl names) import java.io.File; import java.io.FileNotFoundException; import java.io.PrintWriter; import java.util.Scanner; /** This program reads a file with numbers, and writes the numbers...
Goods that have become attached to real estate
chapter 11 Assignment #2 Place the correct term to the right of the description  Goods that have become attached to real estate An interest in personal property or fixtures that secures the performance of some obligation The person or company that holds the security interest The property subject to a security interest Contract in which the debtor gives a security interest to the secured party When the debtor fails to pay money that is due When the secured party takes the collateral because the debtor has defaulted A series...
In the attached table, you are given valuation ratios for Eli Lily & Co. as well...
In the attached table, you are given valuation ratios for Eli Lily & Co. as well as select competitors and the pharmaceutical and biotech industry. Using this data, assess whether Eli Lily & Co. is correctly valued. Explain your rationale. If, in your opinion, it is not correctly valued, explain whether it is overvalued or undervalued and the basis for your opinion and what ratios support your conclusion. Row headers in order: Price to earnings (P/E), Price to next year...
In Python. The file “essay.txt” attached to this assignment includes an essay. The essay includes a...
In Python. The file “essay.txt” attached to this assignment includes an essay. The essay includes a couple of sections that are separated by two consecutive newline characters (i.e. ‘\n’) that are shown as empty lines between the sections if you open the file in a text editor like Notepad. Each section starts with a title followed by a couple of paragraphs; the title and the paragraphs are separated by a newline character. Each paragraph includes a couple of sentences that...
Follow the UML diagram and directions on the attached file to create a RectangularPrism class and...
Follow the UML diagram and directions on the attached file to create a RectangularPrism class and a RectangularPrismDemo class. --------------------------------------------------------------------------------------------------------------------------------------- RectangularPrism            - length: double       - width: double       - height: double + RectangularPrism() + RectangularPrism(l:double,w:double, h:double) + setLength(l:double):void + setWidth(w:double):void + setHeight(h:double):void +getLength():double +getWidth():double +getHeight():double +getVolume():double +getSurfaceArea():double +toString():String --------------------------------------------------------------------------------------------------------------------- Create a RectangularPrism class in its own file based on the UML Create a separate RectangularPrismDemo Class file to demonstrate your class by doing the following: Create two prisms,...
JAVA Start with the SelectionSort class in the zip file attached to this item. Keep the...
JAVA Start with the SelectionSort class in the zip file attached to this item. Keep the name SelectionSort, and add a main method to it. Modify the selectionSort method to have two counters, one for the number of comparisons, and one for the number of data swaps. Each time two data elements are compared (regardless of whether the items are in the correct order—we're interested in that a comparison is being done at all), increment the comparison counter. Each time...
my_list = {} Dictionary holding all the lists. s_files = [] # Files with size UNDER...
my_list = {} Dictionary holding all the lists. s_files = [] # Files with size UNDER 50 KB. m_files = [] # Files with size AT LEAST 50 KB and UNDER 5 MB . l_files = [] # Files with size AT LEAST 5 MB, no upper limit. directories = [] # Directories, regardless of size. Write a program using python that loops over each file in a specified directory and checks the size of each file.Create 2-tuple with the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT