# Excel 95 % confidence interval

#### statlearner123

##### New Member
Hello everybody,
I am learning about data science at the moment. I want to calculate the 95% confidence interval for the amount of Long-Term Debt that I could expect to have with Long Term Assets of $50,000,000. I calculated a regression analysis for the impact of long-term assets on long-term debt below. I had to two ideas to come up with the confidence interval. I would appreciate your help which one is correct! Version 1: Lower 95% interval: Y= 0.57*50-20.52 = 8.056965152 Upper 95% interval: Y= 1.05*50 +4.84 = 57.47532624 Version 2: =CONFIDENCE.NORM(0.05, 4.283516535, 12) 4.283516535 is the Standard Error from the Regression Statistics table. Lower confidence:$30.34
Mean: $32.77 Upper confidence:$35.19