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!