Question

Here is the dataset containing plant growth measurements of plants grown in solutions of commonly-found chemicals in roadway runoff.

Distilled H2O	Petro	NaCl	MgCl	NaCl + MgCl
19.93	19.81	19.97	19.87	19.88
19.99	20.07	19.8	19.95	19.82
19.95	19.8	19.83	19.82	19.89
20.14	20.01	19.96	20.02	19.98
20.09	19.87	19.98	19.96	19.89
20.12	19.89	20.09	19.97	19.88
20.06	20.03	19.8	19.97	19.9
20.07	20.08	19.97	19.86	19.75
19.9	20.07	19.89	19.84	19.98
20.07	19.92	19.84	19.91	19.98
20.01	19.88	19.94	19.8	19.93
20	19.97	20.01	20.02	19.73
19.95	20.08	20	19.92	19.82
20.1	20	20.01	20.07	19.87
19.93	20.05	19.83	19.94	19.99
20.11	19.96	19.83	19.93	19.72
20.02	19.84	19.89	20.02	19.84
19.96	20.03	19.92	19.84	19.94
19.91	19.99	20.03	19.87	19.72
19.92	19.96	19.99	19.81	19.7

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 either:
    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.

-Perform the correct statistical test to determine the p-value.
-Report your answer rounded to four decimal places.
-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

Answer 1