I have several data sets that need to be analyzed, ANOVA, t-test, etc. It is open to whatever stat software is desired and needs to be analyzed and ranked, usually by yield, for plant breeding experiments.

Here is the assignment. I mainly need someone to analyze the data and provide the output - whatever is appropriate - ANOVA, t-test, or other.

Dataset 1:

The 2017 B-PH1 data for advancement.xlsx is from a preliminary phase 1 hybrid trial grown in two locations with two replications in a randomized complete block design.The trial is the first look at new hybrid combinations and is designed to eliminate 40-60% of the lines being tested.

Use statistical analysis software of your choice, complete the analysis of the data in the file and make decisions on what lines you will keep and which will be eliminated from further consideration.At a minimum, must eliminate at least 40% of the experimental.At a maximum, you may eliminate up to 60% of the experimental lines.Explain how you completed your analysis and why you eliminated the lines that you did.

The above data set would need to be analyzed for yield, yield x location, entry x location, and within reps - I could hand

DataSet 2:

2017 Summary Stats Specialty Grain.xlsx. 2017

Specialty Grain Meta Analysis (Mixed Models).docx

These files contains analyzed hybrid yield trial data evaluating 50 grain sorghum hybrid combinations that have a specialty grain characteristic (which is listed in Column Y of the excel file and color coordinated as well).For reference, in the black, tannin category the check hybrid is Onyx.In the red, tannin category, the check hybrid is NK8830.In the popping category, RIL065 is the check cultivar.There are no check hybrids for yellow or yellow tannin and the white hybrids are checks for the whole trial with regard to general productivity and agronomic phenotype.

Using this data, complete the following:

1.Within in each specialty categories listed below, make a decision on which hybrids should be kept and which should be dropped from further consideration.You need to consider the agronomic parameters (yield, height and maturity) in all categories.Specific parameters for the categories are also important (higher numbers more valuable)

2.Black, Tannin (DOA, phenols and tannins)

3.Red, Tannin (phenols and tannins)

4.Popping (popping efficiency and expansion ratio)

5.Yellow, Tannin (phenols and tannins)

6.Yellow (no other traits)

1. 7.Using the analysis above (as well as any other traits), identify the BEST hybrid in the black tannin category