a) Which regression model should be selected for estimating? Explain why? b) Using the model selected estimate the total cost of a 12 km, 16" pipeline with Year Index=900. ear Index Cost (TL/m)
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
![5- A pipeline contractor is developing parametric cost models to estimate cost of a new 16" pipeline project. The contractor is using data of 7
previous 16" pipeline projects given below to develop the models. The contractor is considering two (inear and bilinear) regression models.
a) Which regression model should be selected for estimating? Explain why?
b) Using the model selected estimate the total cost of a 12 km, 16" pipeline with Year Index=900.
Year Index
Cost (TL/m)
100
15.6
200
30.4
300
52.8
400
81.7
500
134.8
600
165.0
700
272.6
Hint: To developed the models use Excel regression tool, and fill the related blanks in the summary output given in below for each model in
your answer
MODEL-1 SUMMARY OUTPUT (Linear)
MODEL-2 SUMMARY OUTPUT (Bilinear)
Regression Statistics
R Square
Regression Statistics
R Square
t Stat
Coefficient
t Stat
Coefficient
P-value
P-value
Intercept
Year Index
Intercept
Year Index](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe3e2215c-9a60-41e3-b23a-be2cb78aa868%2Fe8ca0a75-2bc1-424a-ab45-e5e763af6db0%2Frqgl2mm_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)