I am currently doing my master thesis on GHGs from hydroelectric reservoirs. I have, however, run into a situation where I would very much like to find the p-value for one of the trendlines Excel have generated for me. (I know p will be far off, but still). I have tried to look through toturials at youtube and google, but I have not had the luck to find anything useful. Will anyone please help me calculate a p-value for me if I provide the data in .xlsx format??
The trendline (for tropical reservoirs only!) is based on a graph made from a number of samples in which y is the amount of GHG's over the reservoir (in mg/day) and x is the age of the reservoir (in days). The trendline equation for
CO2 is: 1173.3ln(x)-13117, and for;
I have no idea how to find the p-values based on this information. The graphs are found on the tab named "overall". the data is found on the tab named "reservoir-list",, CO2 is column <I> and CH4 is column <J>, days are found in column <S>., again I am only interested in tropical reservoirs in this matter.. "biome" is found in column <K>.
I will even buy you a song or a cheap app on itunes if you help me