One late friday afternoon your obnoxious boss comes into your office as you are about to leave, and shows you 26 observations that he believes to be related. y, he believes, is the dependent variable and x1 is the independent variable. he also thinks there is a 2nd order polynomial relationship in the data ( y = b1x1 +b2x12 + b0 ), and, as you casually view the data, you tend to agree. he insists that the determination of b1, b2 and b0 is far more important than your friday afternoon gathering of young-urban-millennial-professional s (yumps) at a local watering hole. so, you perform the analysis using the scatter diagram and trendline tool in excel. then you quietly exit for the yumps gathering.

now, it is monday morning. you want to use the assumption of a 2nd order polynomial to find the exact values of b1, b2 and b0 . (hint: generate a new variable that fits the assumed polynomial model and then use the regression tool in excel)

a) use a regression tool in excel to determine the exact values of b1, b2 and b0 .

b) is the regression model significant? use alpha 0.05.

data:

x1 x2 y
68,067 4,633,116,489 1,598,278,294
70,103 4,914,430,609 1,695,432,796
76,370 5,832,376,900 2,011,698,722
86,686 7,514,462,596 2,592,259,645
86,759 7,527,124,081 2,597,646,596
91,805 8,428,158,025 2,907,666,308
92,306 8,520,397,636 2,940,058,192
93,731 8,785,500,361 3,030,806,599
100,913 10,183,433,569 3,512,923,429
102,199 10,444,635,601 3,603,809,834
109,399 11,968,141,201 4,129,345,241
113,430 12,866,364,900 4,439,623,027
118,133 13,955,405,689 4,814,663,900
122,820 15,084,752,400 5,203,806,895
123,417 15,231,755,889 5,255,000,229
123,054 15,142,286,916 5,224,742,756
127,860 16,348,179,600 5,640,704,277
132,868 17,653,905,424 6,091,148,092
131,160 17,202,945,600 5,935,115,092
132,132 17,458,865,424 6,022,925,591
132,583 17,578,251,889 6,064,201,852
136,859 18,730,385,881 6,462,049,499
140,562 19,757,675,844 6,816,147,332
144,594 20,907,424,836 7,212,915,055
141,493 20,020,269,049 6,906,705,120
139,465 19,450,486,225 6,710,038,170