Here is a dataset containing plant growth measurements of plants grown in solutions of commonly-found chemicals in roadway runoff. 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
-
Here is a dataset containing plant growth measurements of plants grown in solutions of commonly-found chemicals in roadway runoff.
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
