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

Thank you for your help!