USING EXELL ANSWER BOTH PARTS TO THIS QUESTION

data set collected by Dr. Hernandez. Her research team has a data set of the weight of fishes caught from both the contaminated lake and the pristine lake. Assume both of these data sets have equal variance.

PART 1: Perform the correct statistical test and determine the P value to test Dr. Hernandez's hypothesis. Report your answer for P rounded to four decimal places.

PART 2: Based on the statistic results and P value determined in the previous question, which of the following statements are FALSE? (Check all that apply)

A:The calculated statistic value would be greater than the critical value (when alpha = 0.05).

B:The calculated statistic value would be less than the critical value (when alpha = 0.05).

C:The P value is greater than alpha = 0.05.

D: The P value is less than 0.05.

Use formulas, functions, and the data analysis tool pack in Excel to avoid accruing rounding errors. Useful functions include

=t.test(array1,array2,tails,type)

to produce a P value for any type of a t test from a data set

Type can be set to 1 for paired, 2 for unpaired with equal variance, or 3 for unpaired with unequal variance

=chidist(x,degrees of freedom)

to produce a P value from a calculated chi squared statistic

ANOVA Single Factor from the data analysis tool pack

to perform a 1-way ANOVA on a data set with only one factor

Regression from the data analysis tool pack

to perform a linear regression and the corresponding t-test on the slope of the line

DATA:

70.6	79.6
42	64
75.6	79.6
89	68.3
77.3	98.6
60.9	85.6
91.1	83.3
78.9	77.3
56.8	76
38.3	76.4
92.5	79.6
83.3	66.8
67.6	98.6
83.4	92.5
91.6	56.9
90.2	89.8
88.6	95.6
78.9	66.3
85.6	86.6
78.8	99.7