10.) In a simple linear regression analysis on n=100 observations, the following results are produced:

SST= 500, SSE= 100

Which of the following is true?

14.) In a simple regression analysis, if the standard error of estimate is 15 and the number of observations is 10 then the sum of the residual squared must be 120.

15.) In a multiple regression problem involving 35 observations and five explanatory variables

SST= 900 and SSE is 460. The value of the F ratio for testing the significance of this model is 15.56.

Please show Excel work.

Select all that apply. In a simple linear regression analysis on n=100 observations, the following results are produced: SST=500,SSE=100 Which of the following is true? R-square=25%R-square=20%MSR=1.0204 Impossible to determine from the information given R-square =80% In a simple regression analysis, if the standard error of estimate Se=15 and the number of observations n=10, then the sum of the residuals squared must be 120 . True False In a multiple regression problem involving 35 observations and five explanatory variables, SST=900 and SSE=460. The value of the F-ratio for testing the significance of this model is 15.56. True False