Answer Happy

3. Using the California Department of Education's API 2000 dataset with sample size be 45. This data file contains a measure of school academic performance as well as other attributes of the elementary schools, such as, class size, enrollment, poverty, etc. Let's dive right in and perform a regression analysis using the variables apico, acs_k3, meals and full. Fit the regression model and get the following SAS output. The following are the outputs from SAS. Analysis of Variance Sum of Squares Mean Square Source DF F Value Pr > F 3 f g g Model Error Corrected Total с 1271 e 875 d d a b Parameter Estimates Parameter Estimate Standard Error Variable Label DF t Value Pr > It! Intercept acs_k3 meals full Intercept avg class size k-3 pet free meals pot full credential 1 1 1 1 1 875.05923 -2.50651 -3.31802 0.12031 31.03465 1.59469 0.23408 0.12072 32.08 -1.92 -24.04 1.20 <.0001 0.0553 <.0001 0.2321 Answer the question using the SAS output. (a) Please write down the estimated linear model for this data. (b) Above is a partial ANOVA Table from fitting this model. Find the missing values a, b, c, d, e, f and g. (c) State the null and alternative hypothesis of the overall F test. (d) Based on the output, please draw conclusion for the above test. (e) Calculate R^2 based on the ANOVA table.