Use the Excel Data Analysis Toolpack to fit a straight line to the following data. Determine the

Question:

Use the Excel Data Analysis Toolpack to fit a straight line to the following data. Determine the 90% confidence interval for the intercept. If it encompasses zero, redo the regression, but with the intercept forced to be zero (this is an option on the Regression dialoguebox).

10 12 14 6.5 25.8 26.9 7. 17.8 13 19
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Numerical Methods For Engineers

ISBN: 9780071244299

5th Edition

Authors: Steven C. Chapra, Raymond P. Canale

Question Posted: