We are using a different data set this time (attached). This is the hint that I

We are using a different data set this time (attached). This is the hint that I got from the student.
For Homework 3A and 3B, first, we need to get the columns of the variables he wants in a separate Excel sheet. Then for Homework 3A, after finding the values from his paper you can proceed with the instructions, he gave us. To get rid of -9999, go to DATA -> SORT -> Sort by: PPFD_IN -> Okay. To install Solver in your Excel, go to File -> Options -> Add-ins -> Solver Add-in -> Go -> Ok .
For Homework 3B, you need to convert the temperature to Kelvin by adding 273.15, before doing 1/T for the x variable. To find Ea for a season, graph 1/T vs lnRe, add a linear trendline, and then multiply the slope by the -8.314. To find T for a season, take the average of the temperature (Kelvin) column. To find Q10, graph T vs Re, add an exponential trendline, and then use the coefficient in front of x, to find Q10 for a season use the equation Q10 = e^10B. Lastly, to find Re of a season, use the equation R = Ae^BT where A is the coefficient before e in the exponential trendline equation of T vs Re. For the figures he wants in questions 2-4, use the values from the table in question 1 to make scatterplots.
I hope this helps!