Q13: USING EXELL and the formulas mentioned bellow please answer all the parts to this question with correct rounding

Phragmites australis, a fast-growing non-native grass common to roadsides and disturbed wetlands of Tidewater Virginia, was grown in a greenhouse and watered with one of the following treatments:

Distilled water (control);

A weak petroleum solution (representing standard roadway runoff);

Sodium chloride solution;

Magnesium chloride solution;

De-icing brine (50% sodium chloride and 50% magnesium chloride).

Twenty grass preparations were used for each solution, and total growth (in cm) was recorded after watering every other day for 40 days.

QUESTION 1: Perform the correct statistical test to determine the p-value.

Report your answer in standard decimal notation rounded to four decimal places.

e.g. 0.0001 not 1E-4

You should use formulas, functions, and the Data Analysis ToolPak in MS Excel to avoid additive rounding errors. Here are some useful functions:

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

Produces a p-value for any type of a t-test from a data set

=chidist(x,degrees of freedom)

Produces a p-value from a calculated chi-squared statistic

ANOVA Single Factor from the data analysis tool pack

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

ANOVA 2-Factor from the data analysis tool pack

Performs an ANOVA on data with multiple treatments

Regression from the data analysis tool pack

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

Question 2: Which of the following is a correct statement of the alternate hypothesis?

A: Mean growth in the control group is no greater than mean growth in the experimental groups.

B: Mean growth in the NaCl + MgCl group is less than mean growth in the control group.

C: Mean growth in the control group is greater than mean growth in the experimental treatments.

D: Mean growth in one or more of the groups is greater than or less than one of the others.

Question 3: Based on the p-value from your Phragmites dataset analysis, select the all the options that are TRUE. (MORE THAN ONE)

A: The calculated F value was less than the critical F value.

B: The calculated F value was greater than the critical F value.

C: A post-hoc test is necessary to determine statistically-significant difference(s).

D: The p-value is less than α (0.05).

E: The p-value is greater than α (0.05).

Question 4: Which is / are (a) proper interpretation(s) of your p-value from your Phragmites data analysis? select the all the options that are TRUE. (MORE THAN ONE)

A: I would reject the null hypothesis.

B: I would fail to reject the null hypothesis.

C: There is a significant difference in growth between the five groups of Phragmites plants.

D: There is no significant difference in growth between the five groups of Phragmites plants.

E: The control plants' growth rate was greater than the contaminated plants.

DATA:

Distilled H2O Petro NaCl MgCl NaCl + MgCl

20.08 19.98 19.83 20.02 19.92

19.95 20 19.98 19.91 19.99

20.05 20.07 19.82 20.02 19.7

19.9 19.81 20.07 19.99 19.96

20.11 19.82 20.03 19.92 19.74

20.03 19.87 19.8 20.07 19.94

20.01 19.88 19.97 19.87 19.73

19.91 19.93 19.84 19.88 19.71

20.04 19.82 19.87 19.78 19.88

19.96 19.81 19.97 20.06 19.92

20.11 19.84 19.8 20.05 19.99

19.98 20 19.97 20.03 19.88

20.1 19.96 19.99 20.1 19.83

20.11 19.96 20.1 19.86 19.99

20 20.06 19.93 19.83 19.99

19.91 20.08 19.99 20.05 19.8

19.98 19.98 20.1 20 19.94

20.05 19.97 19.93 19.93 19.73

19.91 19.82 20.02 19.8 19.93

19.99 19.99 19.93 19.87 19.77