data
x | y |
758 | 1001 |
777 | 1037 |
794 | 1106 |
808 | 1153 |
836 | 1200 |
876 | 1249 |
935 | 1265 |
943 | 1305 |
Using Excel
data -> data analysis -> regression
result
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.9470 | ||||
R Square | 0.8967 | ||||
Adjusted R Square | 0.8795 | ||||
Standard Error | 38.1983 | ||||
Observations | 8 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 76029.3564 | 76029.3564 | 52.1068 | 0.0004 |
Residual | 6 | 8754.6436 | 1459.1073 | ||
Total | 7 | 84784.0000 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | -78.8740 | 172.7768 | -0.4565 | 0.6641 | -501.6438 |
x | 1.4787 | 0.2048 | 7.2185 | 0.0004 | 0.9774 |
a)
r^2 = 0.897
federal
state
R^2
1- R^2
b)
Se = 38.2
federal government
specific
state government
Please rate
The table shows the avrage wookly wages (n dollars) for state govemment eplnyeesand deral govemment employees for 8 yeans. The equation of the regression line is y 1.479x-78 874 Complete pa...
The table shows the average weekly wages (in dollars) for state government employees and federal government employees for 8 years. The equation of the regression line is y = 1.402x-12.106. Complete parts (a) and (b) below. 766 Average Weekly Wages (state), x Average Weekly Wages (federal), y 745 995 794 1111 802 1140 842 1207 887 1244 932 1276 951 1303 1048 (a) Find the coefficient of determination and interpret the result. 2 = 0.944 (Round to three decimal places...
The table shows the number of goals allowed and the total points earned (2 points for a win, and 1 point for an overtime or shoc season. The equation of the regression line is y = -0.600x + 225.826. Use the data to answer the following questions. (a) Find the coefficient of determination, and interpret the result. (b) Find the standard error of the estimate, se, and interpret the result. Goals 212 210 219 223 259 258 273 200 217...
The number of initial public offerings of stock issued in a 10-year period and the total proceeds of these offerings (in millions) are shown in the table. The equation of the regression line is ý = 48.175x + 17,814.00. Complete parts a and b. Issues, x 403 472 690 481 485 380 69 64 200 1729 Proceeds, 19,751 28,036 42,872 31,73065,013 65,928 20,212 11,135 30,347 27,681 (a) Find the coefficient of determination and interpret the result. (Round to three decimal...
Find the standard error of estimate Se and interpret the result. The number of initial public offer ngs o stock issued in a 10-year penod and the total proceeds o these offerings (in milions are shown in the able The equation of the regress on line is y = 47.871 + 18.224.89 Complete parts a and b 414 | 461 | 688 | 483 | 490 | 391 | 68 | 74 | 190 | 152 Proceeds, 19,111 28,676 42,627...
The money raised and spent (both in millions of dollars) by all congressional campaigns for 8 recent 2-year periods are shown in the table. The equation of the regression line is ModifyingAbove y with caret = 0.964x+11.568. Find the coefficient of determination and interpret the result. Money raised, x 469.8 666.6 746.9 789.1 797.9 1025.5 952.7 1207.7 Money spent, y 449.6 698.3 738.4 757.8 743.3 1000.6 949.8 1170.7 Find the coefficient of determination and interpret the result. r2 = _________...
The money raised and spent (both in millions of dollars) by all congressional campaigns for 8 recent 2-year periods are shown in the table. The equation of the regression line is y = 0.942x + 31.252. Find the coefficient of determination and interpret the result. Money raised, x 451.8 T 657.4 T726.1 1 789.5 789.5 1787.6 787.6 T 1036. 6 1036. 6 9 56.5 9 56.5 1213.4 1213.4 Money spent, y 4382 675.9 747.5 768.2 726.6 L 1018.2 949.5 1158.5...
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 90% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $879. The equation of the regression line is ModifyingAbove y with caret equals 1.369 x plus 32.849 . The table below shows the average weekly wages (in dollars) for state government employees and...
& 9.3.11-T Question Help The number of initial public offerings of stock issued in a 10-year period and the total proceeds of these offerings (in milions) are shown in the table. The equation of the regression line is 46.320x 18,843.16. Complete parts a and b , 406 461 688 499 498 377 57 69192 153 Proceeds, 17,893 28,654 42,827 31,617 67.306 65,407 21,402 11,244 31,691 27,878 The coefficient of determination is the fraction of the variation in proceeds that is...
Question Help The table shows the number of goals allowed and the total points camed 12 points for a win, and 1 point for an overtime or shootout loss by ice hockey is over the course of a son The gason of the regression line 3216-317 Use the the following questions (a) Find the coefficient determination, and interpret the rest Find the standard error of the estimate and interpret the rest Goals Allowed 210 210 214 22 201204 202 203...
The ANOVA summary table to the right is for a multiple regression model with nine independent variables. Complete parts (a) through (e) Degrees of Source Freedom Squares Sum of Regression Error Total 260 180 440 19 28 5909 (Round to four decimal places as needed.) Interpret the meaning of the coefficient of multiple determination The coefficient of multiple determination indicates that 59.09% of the variation in the dependent variable can be explained by the variation in the independent variables e....