Dear Friends.

I am currently doing my master thesis on GHGs from hydroelectric reservoirs. I have, however, run into a situation where I would very much liketo find the p-valuefor 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??

Link: https://portal.bitcasa.com/send/968d...14ea08d4f5834e

The trendline (fortropicalreservoirs 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;

CH4: 8.8779ln(x)-152.28

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>.

PLEASE HELP!

I will even buy you a song or a cheap app on itunes if you help me