Solve problem (P4.2) from the textbook using the following data instead of the data given in the textbook. Solve only requirements under a, b and c. Show your assumptions and consequent calculations on how you catered for the fact that 1997 means first half of the year and 1997.5 means in the second half of the year; without such initial, your solution will not be considered as your own. (Hint: you may use Excel or any software to conduct linear regression/linear curve fitting. Note also that condition should be related to age and not the date).

Show the details of your software analysis and calculations.

Date	Condition
1985	1
1985.5	1
1996.5	2
1997	2
1997.5	2
1998	2
1998.5	2
1999	2
1999.5	3
2000	3
2000.5	3
2001	4
2001.5	4
2002	4
2002.5	4
2003	4

This is the book Q :

Appearing below is a series of roof inspection condition summaries, where 1 is excellent and 5 is poor. Note that an inspection 1997.5 occurred in the second six months of 1997, whereas 1997 occurred in the first six months of 1997. The roof was replaced in 1985. Answer the questions below. You might use software aids, such as EXCEL or MATLAB, for this problem. 65 a. Estimate an ordinary least squares regression deterioration model of the form: Condition = a + b(age) where age is the age of the roof in years. Report your parameter estimates, standard errors, t-statistics and R^2 values. Note that there is a gap in the data from 1985 to 1996! b. Suppose I have a comparable roof that is 12 years old. What would your regression model in (a) predict for its condition? What would it predict for age 18? At what age is condition expected to become 5? c. Plot the data and your regression line.

course: Infrastructure managment