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

Data description: This data measures the protein content of soybean samples. Each measurement is the percent protein content from a bulk sample of soybeans, from 0.1 m2 sample plots selected at random from within a quarter section growers' field. With this being the growers first time planting soybean in this parcel of land, they wanted to ensure the resulting seed quality met their expectations based on the averages reported for Manitoba (38.6%, based on 2016 Canadian Grain Commission data).

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. Your expected population mean 3. The mean, standard deviation and sample size for the sample data 4. A histogram of the sample data 5. A boxplot of the sample data 6. A normal Q-Q plot of the sample data 5 7. A statement on whether or not the sample data meets the assumptions, and why you drew this conclusion 8. (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

percent_protein

40.4

42.4

37.4

40.7

42.7

41.6

39.8

38.7

38.4

39

40.7

37.7

42.4

40.5

40.7