Hello All, I am attempting to run collected disease data (Area under the disease progress curve, AUDPC - by variety and pathogen) and temperature data collected for the average temperature in the room each day as the experiment was run. This is important because we have seen a bit of variation in the room where the trial was stored and due to the pathogen preferences, we are concerned that may have skewed the data. (Additional: The sets of apples were run at different times so the daily avg. the temperature will be different depending on when the trial was run. I could average it for the entire trial and just use a single value but I am also unsure of it that would be acceptable in the SAS code. Can I combine the two sheets with "date" as a factor?
I have never analyzed this and am unsure of where to start.
Here is an example of the data:
Disease Data
Variety | Treatment/Pathogen | Rep | AUDPC |
Apple 1 | 1 | 1 | 277 |
Apple 1 | 1 | 2 | 265 |
Apple 1 | 1 | 3 | 316 |
Apple 1 | 1 | 4 | 246 |
Apple 1 | 3 | 1 | 591 |
Apple 1 | 3 | 2 | 503 |
Apple 1 | 3 | 3 | 554 |
Apple 1 | 3 | 4 | 460 |
Apple 1 | 4 | 1 | 388 |
Apple 1 | 4 | 2 | 498 |
Apple 1 | 4 | 3 | 484 |
Apple 1 | 4 | 4 | 430 |
Temperature Data:
Date | Avg | High | Low |
9/23/2019 | 70.26567 | 71.8 | 69.1 |
9/24/2019 | 69.3425 | 70.4 | 68.2 |
9/25/2019 | 68.89967 | 70.4 | 67.3 |
9/26/2019 | 69.88596 | 70.3 | 69.2 |
9/27/2019 | 68.89208 | 70.1 | 67.7 |
9/28/2019 | 68.85629 | 69.7 | 68.5 |
9/29/2019 | 68.39888 | 68.5 | 68.2 |
9/30/2019 | 69.09233 | 70.8 | 68 |
10/1/2019 | 71.58325 | 72.3 | 70.9 |
10/2/2019 | 70.81654 | 71.6 | 70.48 |
10/3/2019 | 71.42663 | 73.4 | 69.7 |
10/4/2019 | 70.48013 | 71.6 | 68.9 |
Any thoughts on which test might be most appropriate to compare these two groups.
Thank you so much for your help!