Homework answers / question archive / Directions: complete each of the steps below

Directions: complete each of the steps below

MS Excel

Share With

---

Directions: complete each of the steps below. Report all requested information/graphs in Word document. Also include your answer to question in step 8. Questions and data included in file
 

Backg round: the Connecticut Department of Environmental Conservation initiated a program Ip ae :

' 2016 with the goal of increasing the size of brook trout, Salvelinus fontinalis, found in the. a

__ State’s brooks, stream, and rivers. To achieve this goal, brook trout raised in fish hatcheries: «2am

_ were kept in less crowded tanks, fed an enhanced protein diet, and given an additional6 – aa months maturation time before being introduced into the wild. oe

Steps: the data file you have been provided for this project represents recorded lengths, in : Be

inches, of a large number of brook trout Caught (and released) throughout the state in 2021. a

1. Check the data for any obvious entry errors (there may be none). a

y ry 7 eee

a. Record and report each entry you believe is an error; state why the entryisan_ - =!

error. a

b. Remove all errors from the set of observations. ae

2. Compute and report the 5-number summary for the remaining data (min, Q1, median, S

Q3, max). “8

3. Create and report a boxplot of the remaining data. 4

a. There are several online apps for doing this. Using the app below, you can copy “Ss and paste your data into the data panel, generate the boxplot, and then copy the os resulting image for pasting into your report: z

https://www.statskingdom.com/advanced-boxplot-maker.html oe

4. Use the IQR test to determine whether your data has any outliers: “or 8

a. An observation x is an outlier if x < Q1— 1.5*IQR or x > Q3+1.5"IQ 310 ae

fs b. An observation x is an extreme outlier of x < Q1—3"IQR or eon outlier oras ee

4 - c. Record and report each observation you have classified as e = ~

d 1" oe an extreme outlier. « of observations , a

joe ve all outliers from the set of obs ie

Hit d. Remo he mean and sample standard deviation for the remaining... agai

| I" ‘| \°5. Compute and report the me <—

“| 6. Create and report a frequency he nearest integer. aS She uiaim

A |) a. Use the min value from step 2 rounded down to the neare rn

et be oe

oe I. i | PPP eg be ty URNS Os US i

waned ee pope tlhe pe fe I sg tg Bp me oy

b. Use the max value from step 2 rounded up to the nearest integer as the last

 

upper-class limit. a

 

c. Create 10 classes with class width = (value from (b) — value from (a)) / 10. Al

 

d. Use the COUNTIFS command (see Chapter 2 Resources) to determine the a

 

, frequency for each class from (c). e

 

7. Create and report a histogram based on your frequency table from step 6. a

 

8. In 2016, a similar study was completed before the program was started. A total of 165 i

 

. brook trout were caught and released after measurement. The study found a mean oe fe length of 8.12 inches with a sample standard deviation of 2.91 inches. =

 

iii Has the state’s initiative worked? Why, or why not? Answer this question ina wel:

 

ih j _written paragraph. Be sure to cite specific results from your analysis. | 23 a