The Student Room Group

Statistics on Excel Help..

Using, http://wps.aw.com/wps/media/objects/3254/3332253/datasets2e/datasets/CPS04.xls,

Run a regression of average hourly earnings (AHE) on age.. (not a problem, its this bit that doesnt work for me..)

a) Is the estimated regression slope coefficient statistically significant? That is, can you reject the null hypothesis Ho:B1=0 versus a two sided alternative at 10%, 5% or 1% sig. level? What is the p-value associated with coefficients t-statistic?

To do this question your going to have to have Excel, the problem i had is i cant seem to even perform a t-test.. i used the formula that was provided with the Help function.. and even then i just kept getting zero..

Any help would be much appreciated, thanks!....
Reply 1
Anyone?..
Hmm I'm not too equipped with statistics on Excel.. I use Autograph for my coursework really. I'll keep you updated if I find anything out.
Reply 3
ok matey, cheerio!
Reply 4
I actually tried it.. and kept getting zero.. i wonder why?.. anyone have any input to help the OP?

Latest