CIEandPIforSLR - For other data sets that have a sample...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Site Selection Analysis Data X Value 4 Confidence Level 95% Intermediate Calculations Sample Size 14 Degrees of Freedom 12 t Value 2.1788 Sample Mean 2.9214 Sum of Squared Difference 37.9236 Standard Error of the Estimate 0.9664 h Statistic 0.1021 Predicted Y (YHat) 7.6439 For Average Y Interval Half Width 0.6728 Confidence Interval Lower Limit 6.9711 Confidence Interval Upper Limit 8.3167 For Individual Response Y Interval Half Width 2.2104 Prediction Interval Lower Limit 5.4335 Prediction Interval Upper Limit 9.8544
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Square Feet Annual Sales (X-XBar)^2 1.7 3.7 1.49189 Sample Size 14 1.6 3.9 1.74617 Sample Mean 2.92143 2.8 6.7 0.01474 Sum of Squared Difference 37.92357 5.6 9.5 7.17474 Predicted Y (YHat) 7.64392 1.3 3.4 2.62903 2.2 5.6 0.52046 1.3 3.7 2.62903 1.1 2.7 3.31760 3.2 5.5 0.07760 1.5 2.9 2.02046 5.2 10.7 5.19189 4.6 7.6 2.81760 5.8 11.8 8.28617 3 4.1 0.00617
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: For other data sets that have a sample size other than 14: Select row 6. Right-click the row and then click Insert or Delete to insert or delete a row. Repeat the row insertion or deletion until the number of rows in the body of the table equals the sample size. As a doublecheck, spot check the formulas in column F to verify that they contain the proper ranges. quare Fe nnual SalX-XBar)^2 1.7 3.7 1.49189 Sample Size 14 1.6 3.9 1.74617 Sample Mean 2.92143 2.8 6.7 0.01474 Sum of Squared 37.92357 5.6 9.5 7.17474 Predicted Y (YH 7.64392 1.3 3.4 2.62903 2.2 5.6 0.52046 1.3 3.7 2.62903 1.1 2.7 3.31760 3.2 5.5 0.07760 1.5 2.9 2.02046 5.2 10.7 5.19189 4.6 7.6 2.81760 5.8 11.8 8.28617 3 4.1 0.00617...
View Full Document

{[ snackBarMessage ]}

Page1 / 3

CIEandPIforSLR - For other data sets that have a sample...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online