Question

2)Perform a least squares analysis, as above, to fit data sets 3 and 4 each to a linear model and to a quadratic model (see below). Then perform an f-test

to determine if the quadratic model is warranted for each case. (Create VBA functions for these as well) Data Set 3: Linear: C0 = _______ C1 = _________ RSS=_________ Quadratic: C0= _______C1 = ________ C2 = ________. RSS =________ F =_________. Standard deviation:s =R? = Data Set 4: Linear:Co=C1 =RSS = Quadratic:Co =c1 =C2 RSSF = Standard deviation:R? =

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5

Fig: 6

Fig: 7

Fig: 8

Fig: 9

Fig: 10

Fig: 11

Fig: 12