Use the data provided to perform a paired sample t test in Excel

Data description: This data measures weed density (number of weeds per m2 ), in 10 sets of paired plots that received either fall or spring tillage with the goal of determining if tillage timing influenced summer weed densities. Paired plots were used to standardize initial weed densities within pairs since weed density was inconsistent throughout the field in which the study occurred. For each set of paired plots, the plot which received fall tillage was randomly selected, and the other plot automatically received spring tillage

In your assignment submission, you must provide the following information in a clear and organized manner: 1. Your null and alternate hypothesis stated in the context of the study (two-sided) 2. The mean, standard deviation, and sample size for the sample data 3. A plot of the paired data 4. A boxplot of the sample data 5. A normal Q-Q plot of the sample data 6. A statement on whether or not the sample data meets the assumptions, and why you drew this conclusion 7. (And if the data meets the assumptions) The t statistic, degrees of freedom, and p value (two-sided, = 0.05) obtained by the test as part of a sentence interpreting the results of the analysis 8. (And if there is a statistically significant result) An appropriate plot with an informative figure caption that you would include if writing a results section for the study

pair	fall	spring
1	26	34
2	23	33
3	35	32
4	19	36
5	15	23
6	20	28
7	19	31
8	19	30
9	37	39
10	31	26