CHEN 3010Applied Data AnalysisFall 2004Names: ________________________________________________________________________________________________________Workshop #23Polynomial Linear RegressionObjectiveAlgebraic polynomial models are the most common used to represent engineering andscientific phenomena. In addition to fitting a polynomial model to the data, other issuesneed to be addressed:¾confidence intervals on the model parameters¾confidence interval on a prediction made by the fitted model¾analysis of residuals to determine model adequacy¾selection among different orders of polynomialIn this workshop, you will deal with the first of these and learn how to fit polynomial modelswith Excel via two methods:¾vector/matrix calculations using Excel’s array operations¾the Analysis Toolbox (Data Analysis) Regression feature.Procedure1.Log onto one of the lab plaza computers and download the Workshop23.xls file from thecourse web site. Launch Excel and open this workbook file. Enter your names for thosepresent at the top of the worksheet to the right of the title.2.Select all the composition values (%) and name this range Pct. Select all the heatcapacity values and name this range y. Create an X-Y (Scatter) chart of the data on aseparate chart sheet, displaying only markers. Add your group number to the title of thechart.3.You will now carry out the regression calculations for a 4th-order polynomial usingExcel’s array operations. The formula to be implemented isˆβ=⋅⋅⋅−XXXyTT1First, enter labels in cells F5 through J5, as shown below:Then, enter the following in cells F6through J6:
has intentionally blurred sections.
Sign up to view the full version.