Results 1 to 4 of 4

Math Help - Will anyone please calculate P-value for me! - or show me how to?

  1. #1
    Newbie
    Joined
    Jan 2013
    From
    Denmark
    Posts
    2

    Will anyone please calculate P-value for me! - or show me how to?

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

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

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

    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    4,026
    Thanks
    741

    Re: Will anyone please calculate P-value for me! - or show me how to?

    Hey TTrold.

    To find a p-value you need to have a distribution and some parameters. In this case it will be a t-distribution.

    In Excel do you have a command to find the standard errors of the parameter estimates? This will give you answer you require.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Jan 2013
    From
    Denmark
    Posts
    2

    Re: Will anyone please calculate P-value for me! - or show me how to?

    Unfortunately data analysis tools are not included in Excel for Mac, which is partly the reason why I have given up on this :S I hoped it would be easy for someone just to plug the data in - damn!
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    4,026
    Thanks
    741

    Re: Will anyone please calculate P-value for me! - or show me how to?

    You should be able to calculate the standard errors in Excel if you can get the parameter estimates for the regression (which you have got).
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Calculate .....
    Posted in the Trigonometry Forum
    Replies: 0
    Last Post: July 13th 2012, 11:58 AM
  2. Calculate : x/y
    Posted in the Algebra Forum
    Replies: 5
    Last Post: December 16th 2009, 08:07 AM
  3. Calculate : f'(0)
    Posted in the Calculus Forum
    Replies: 5
    Last Post: December 14th 2009, 02:08 PM
  4. How to calculate ((a+b)!/a!b!) mod p
    Posted in the Discrete Math Forum
    Replies: 2
    Last Post: May 5th 2009, 12:57 AM
  5. how to show show this proof using MAX
    Posted in the Calculus Forum
    Replies: 2
    Last Post: January 14th 2009, 01:05 PM

Search Tags


/mathhelpforum @mathhelpforum