One late Friday afternoon your obnoxious boss comes into youroffice as you are about to leave, and shows you 26 observationsthat he believes to be related. Y, he believes, is the dependentvariable and X1 is the independent variable. He also thinks thereis a 2nd order polynomial relationship in the data ( Y = B1X1+B2X12 + B0 ), and, as you casually view the data, you tend toagree. He insists that the determination of B1, B2 and B0 is farmore important than your Friday afternoon gathering ofyoung-urban-millennial-professionals (YUMPS) at a local wateringhole. So, you perform the analysis using the scatter diagram andTrendline tool in Excel. Then you quietly exit for the YUMPSgathering.

Now, it is Monday morning. You want to use the assumption of a2nd order polynomial to find the exact values of B1, B2 and B0 .(Hint: generate a new variable that fits the assumed polynomialmodel and then use the regression tool in Excel)

a) Use a regression tool in Excel to determine the exact valuesof 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