Rest of the questions:6. What is the degrees of freedom of SSE?7. Determine the F value of this test: Ho: B1 = 0, H1: B1?0. Use the ANOVA approach (Text p. 314). Make the ANOVA table first and calculate the F-value.

Let us consider these four data points and the regression line from Excel. We consider this simple near model: Y: Bo+B1X1+8- (Problems 1-?) magi-__- Y vibration level Y (vibration level) 170 _ . . 1 ....,...,._...._.. l .. ._. 120 '_..-... 11C.l 20 2 2 2d 26 28 30 32 3-! 3i (water pressure] Note: Excel menu path I Scatter plot on Excel: Insert > Charts 0 Regression: (Select data area) > Data > Data Analysis > Regression 0 Adding regression line to scatter plot: (Double click the scatter plot) > Add Chart Element > Trendline > Linear 1. Determine the slope of the line, Le, (31 of the regression model. 2. Determine the upper bound of 95% CI of B1 (Hint: we first need to calculate se((31). The df of the t distribution is n-2=2.) 3. Determine the upper bound of 95% CI of II when x=30. 4. Determine R2 of the regression. 5. Determine the sum of square of regression, 55.; to be used in ANOVA