Question

On excel, how to a find out a question like:
"We are 95% confident that the true population parameter for FBshare resides between ______ and ______. Where do I look do I run a PH stat or a regression table? i'm not sure.

Answer 1

PH stat test will not provide you with the confidence interval levels whereas regression table always gives you a confidence interval for the variable.

So, its better to complete a regression table using the excel data analysis tool.

In regression, you can enter your desired level of significance level to find the required confidence interval

For 95% confidence interval, enter 0.05 in the significance level option in regression analysis.

Therefore, you can use a regression to find the required confidence interval limits.