Here are my calculations. Let me know if you agree. I'm not sure if I used the TDIST() function correctly to solve for p.
A. Var(B) = SE^2/sum(xi-xbar)^2 = 0.00012/0.001 = 0.12 B. t = (B-0)/SE(B) = -0.9/0.12^0.5 = -2.598 C. t_0.025 = tinv(.05,3) = 3.182. beta = B +- t_0.025*SE(B) = -0.9 +- 3.182*0.12^0.5 = -0.9 +- 1.102 D. p = TDIST(2.598,3,2) = 0.0805 E. Var(A) = SE^2/(n*sum(xi-xbar)^2 = .00012/.005 = 0.024 F. t = (A - 0.219)/SE(A) = (0.813-0.219)/0.024^0.5 = 3.384 G. alpha = 0.813 +- 3.182*0.024^0.5 = 0.813 +- 0.493 H. p = TDIST(3.384,3,2) = 0.043
|