Please help me. I am so lost. I have data that is days above a certain temperatures every year from 1948-2019. So basically something like:
1948 36
1949 31
1950 36
1951 34
1952 36
1953 35
and so on. To find the trend I already did a least-squares linear regression and go that done. Now I am trying to find if the trend is significant or not by using p-values.
Here is where I am stuck. I need to calculate a p-value with the null hypothesis being a coefficient equal to zero (a neutral trend). I don't know how to do this. I am using excel if that helps I just do not know how to go about this. If someone could do a sample problem with the small data given that would be great. I also don't know how to correctly go about that null hypothesis. Thank you in advance for the help!
1948 36
1949 31
1950 36
1951 34
1952 36
1953 35
and so on. To find the trend I already did a least-squares linear regression and go that done. Now I am trying to find if the trend is significant or not by using p-values.
Here is where I am stuck. I need to calculate a p-value with the null hypothesis being a coefficient equal to zero (a neutral trend). I don't know how to do this. I am using excel if that helps I just do not know how to go about this. If someone could do a sample problem with the small data given that would be great. I also don't know how to correctly go about that null hypothesis. Thank you in advance for the help!