{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Workshop 23

# Workshop 23 - CHEN 3010 Applied Data Analysis Fall 2004...

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

CHEN 3010 Applied Data Analysis Fall 2004 Names: __________________________ __________________________ __________________________ __________________________ Workshop #23 Polynomial Linear Regression Objective Algebraic polynomial models are the most common used to represent engineering and scientific phenomena. In addition to fitting a polynomial model to the data, other issues need 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 polynomial In this workshop, you will deal with the first of these and learn how to fit polynomial models with Excel via two methods: ¾ vector/matrix calculations using Excel’s array operations ¾ the Analysis Toolbox (Data Analysis) Regression feature. Procedure 1. Log onto one of the lab plaza computers and download the Workshop23.xls file from the course web site. Launch Excel and open this workbook file. Enter your names for those present 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 heat capacity values and name this range y . Create an X-Y (Scatter) chart of the data on a separate chart sheet, displaying only markers. Add your group number to the title of the chart. 3. You will now carry out the regression calculations for a 4 th -order polynomial using Excel’s array operations. The formula to be implemented is ˆ β = [ ] X X X y T T 1 First, enter labels in cells F5 through J5, as shown below: Then, enter the following in cells F6 through J6 :

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

View Full Document