Skip to content
Dawn Wright, Ph.D.
Dawn Wright, Ph.D.

Statistics, Analytics & Data-Driven Decision Making

  • About Dawn
  • Excel Calculators
  • BUS 233/503 Video Matrix
  • Doc’s Blog
  • Search

Confidence Intervals & Prediction Intervals for Linear Regression

Put your data in the blue cells. If there is existing data in the blue range, delete it first and then enter your x and y values. Be careful to put the x-values in the x column. The yellow answer cells will update automatically.

Or, you can download a copy here: https://www.drdawnwright.com/wp-content/uploads/2018/02/CI-PI-Calculator-for-Regression.xlsx

Search this website

Top Posts & Pages

  • No Standard Deviation? How do I get the standardized test statistic?
  • How to State the Conclusion about a Hypothesis Test
  • What are d-bar and s sub d?
  • Tail of the Test: Interpreting Excel Data Analysis t-test output
  • Use Excel to Calculate MAD, MSE, RMSE & MAPE
  • "Easy" Excel Inverse Triangular Distribution for Monte Carlo Simulations Redux
  • Empirical Rule and z-score Probability
  • Why is the Standard Error Equal to Sigma Divided by the Square Root of n?
  • Minimum Sample Size Calculator for Population Proportion Confidence Interval
  • Playing Card Probability

Creative Commons

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright © 2021 Dawn Wright, Ph.D. | Powered by Dr. Dawn