Question

Score: 0 of 1 pt 6 of 10 (5 complete) 15.1.3-T Use the accompanying set of dependent and independent variables to complete parts a through d below. Click the icon to view the data set. a) Construct a 95% confidence interval for the dependent variable when xy = 9 and X2 = 11. The 95% confidence interval is from a lower limit of to an upper limit of (Round to two decimal places as needed.) 0 Set of dependent and independent variables Х 15 у X1 X2 10 2 11 5 15 9 10 5 20 7 2 24 11 27 16 7 32 21 4 16 10 13 8 Print Done

Answer 1

Answer Date: 31/07/2020 A 95% confidence interval for the dependent variable when xı equal 9 and x2 equal 11 is, By using Excel software, find confidence interval with the help of following steps: 1) Import the data. 2) Select the MegaStat from Add-Ins option. 3) Select the Regression Analysis from Regression. 4) Select data input. 5) Enter Predictor value from Predictor value form spreadsheet. 6) Click Ok. Predicted values for: y x1 95% Confidence Interval 95% Prediction Interval x2 Predicted lower upper lower upper 11 17.943 15.076 20.810 10.491 25.395 9 From the Excel output, a 95% confidence interval for the dependent variable when X1 equal 9 and x2 equal 11 is 15.08 to 20.81.