Table 1: Wing lengths of male and fermale sparrows Male Sparrow Wing Length (cm)
ID: 141795 • Letter: T
Question
Table 1: Wing lengths of male and fermale sparrows Male Sparrow Wing Length (cm) 174 16.9 15.4 18 14.9 19.1 19.6 15.9 16 8 18.3 Female Sparrow Wing Length (cm) 16.3 12 9 104 25.1 15.7 20.1 9.2 17.5 24.3 14.7 These data are fabricated for the purposes of this exercise and do not truly represent wing lengths of sparrows A Carefully read the introduction. Then, enter the data from Table 1 into a Microsoft Excel workbook Calculate the mean for the male wing lengths and then for female wing lengths using the 'average function. Functions can be accessed by clicking the fr buton or typing them directly into the cel olloving the sign For example Average(32 811) B. Determine the standard deviation for male data and then female data by using the function "stdev stdev( B2 B11) Nole you select this fx from the dropdown lat that appears when you type into the cell, it is STDEVS Your screen should look something like the figure shown below C Save this file. Bring it to class with you You will work with it again during labExplanation / Answer
By takin average of wing length of male by puting formula =average(cells containing lenth of wings) gives
average lenth of male wings i.e.17.23cm
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.