Engineering 103 –UMass Boston

CW 4

(In-Class-Work 4)

(a) Save CW3 into a new file, then in Sheet #1 modify it to produce a linear and a cubic model for the same data set, insert snapshots of these worksheets into your Word file. Make a table like the one below for the “s” values for the linear, quadratic, and cubic models, along with the coefficients obtained for each model. Indicate which is the best model (linear, quadratic, or cubic) for our set of data, and the reason.

Model	Coefficients	S parameter
Linear	A= B= C= D=
Quadratic	A= B= C= D=
Cubic	A= B= C= D=

(b) Download this data set, repeat the table above for this new data set: (i) In Sheet#2 using all terms in each model (ii) In Sheet #3 using only the highest order term in each model

Model (all terms)	Coefficients	S parameter
Linear	A= B= C= D=
Quadratic	A= B= C= D=
Cubic	A= B= C= D=

Model (only leading terms)	Coefficients	S parameter
Linear	A= B= C= D=
Quadratic	A= B= C= D=
Cubic	A= B= C= D=

By alphabetical order of the last names, the first two students in each team will submit Excel file cw4_XX_a.html and folder cw4_XX_a_files, the next two students will submit Excel file cw4_XX_b.html and folder cw4_XX_b_files, to the files folder in the server. These files need to be uploaded to the server today to receive credit. Submit hard copies of the Word file containing your name and date and the three tables mentioned above.

*Remember that this is an individual work (turn it in, as instructed, with your name and date). Home-works and class-works count 20% toward the course grade. Class-works are done in class.