I need to have the same data as what my instructor has by reading the data she had given. (This was computed using EXCEL

[answerhappygod]

I need to have the same data as what my instructor has
by reading the data she had given. (This was computed
using EXCEL)

I Need To Have The Same Data As What My Instructor Has By Reading The Data She Had Given This Was Computed Using Excel 1 (240.95 KiB) Viewed 167 times

EXPLAIN So, let us test the hypothesis for the regression model using the same given data from the previous lesson. You may refer to this file: ANOVA TABLE for the mean daily peak load of a power plant and the maximum outdoor temperature F-critical Source of Sum of Degrees Mean value of) Squares F-test Variation Square Decision [From the Freedom f-table) Regression 17, 168,652 1 17, 168.652 Error 2093.729 8 261.716125 65.60 5.32 Reject HC 19, 262.381 9 Reject Ho if the F-test value > 5 32 Total Given Data: The mean daily peak load (y) for a power plant and the maximum outdoor temperature (x) for a sample of 10 days We will use the analysis of variance approach to test for significance of regression using the sample data Hypothesis: the null (Ho: B. = 0) and the alternative hypothesis (H... ) were stated already Level of significance: 0.05 level of significance Computations of the sources of variation Recall that $. = 6.717, Sxy = 2556 and n-10 Computing SS = -(6.717)(2556) - 17, 168.652 for the value of SS, (sum of squares of the residuals or often called error sum of squares) you may refer to the table below: 55 = E!.0-92 Residuals Observed value - Predicted value. e=y- Day Maximum Peak Power Peak Power Predicted c-y-ỷ (y- Temperature Load value, 1 95 214 218.305 4.305 18.53303 2 82 152 130.994 21.016 441.6723 3 90 156 184.72 -28.72 824.8384 4 81 129 124.267 4.733 22.40129 9 99 254 245.173 8.827 77.91593 6 100 266 251.89 14.11 199.092 7 95 210 204.871 5.129 26.30664 8 95 204 218.305 14.305 204.633 9 93 213 204.871 8.129 55.08064 10 87 150 164.569 14.569 212.2558 oy- = 2093.729 5 Note: to find the critical value for ANOVA using F-test, from the table values (F distribution) the headings for columns and rows are the degrees of freedom values, so from what we have calculated the degrees of freedom are 1 and 8. The critical value of 5.32 is an intersection between df=1 and 8. Now, do the same in this given data: On June 29, 2017, the school handled a camping activity. The campers were handed different tote bags randomly and doesn't know what's inside of it. The goal of the activity is to know each person's capability by the minutes they'll feel the heaviness of the bag on the different kilograms they are carrying, Identify the independent and dependent variable among the sample data given. Ilustrate using the scatter graph, find the equation of the regression line, and explain the coefficients. Kilograms Minutes GIVEN DATA CAMPER Joshua Matthew Chloe Iris 3 3 y = 0.2186x+0.033 R=0.9489 2.5 Luis 7 8 5 4 12 11 11 5 10 8 1 John 2 1.5 1 1.582 1.822 1.057 0.7 2.536 2.386 2.294 0.958 2.166 1.866 0.853 1.93 1.562 1.737 2.088 1.137 2.179 2.122 . Orly Von Kevin Jamaica Sharlene Karl Vincent Renz Ivan Tristan Andie Haile 05 0 2 4 6 8 30 12 14 4 8 G 6 7 9 5 9 Minutes 10