How To Calculate Prediction Interval In Excel, The following screenshot displays the necessary calculations derived from the sample data.