Question

In: Finance

X 2 3 1 1 4 Y 3 3 -1 0 6 a) calculate the slope...

X 2 3 1 1 4

Y 3 3 -1 0 6

a) calculate the slope and y-intercept for these data.

Y= ( )+ ( )X (Round to four decimal places).

b) Calculate the total sum of squares (SST)

SST= (Round to one decimal places)

c) Partition the sum of squares into the SSR and SSE

SSE= (Round to three decimal places)

SSR= (Round to three decimal places)

Solutions

Expert Solution

Note: the problem is solved thru data analysis module of Excel and please find the output below for all the details :

Equation Y = --2.2647 + 2.0294(x)

Output

Regression Statistics
Multiple R 0.953562738
R Square 0.909281895
Adjusted R Square 0.879042526
Standard Error 0.965076447
Observations 5
ANOVA
df Sum Square MS F Significance F
Regression 1 28.00588235 28.00588235 30.06947368 0.011928486
Residual 3 2.794117647 0.931372549
Total 4 30.8
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -2.264705882 0.921516477 -2.457585879 0.091062739 -5.197382591 0.667970827 -5.197382591 0.667970827
X Variable 1 2.029411765 0.370089923 5.483563958 0.011928486 0.851620456 3.207203074 0.851620456 3.207203074
RESIDUAL OUTPUT
Observation Predicted Y Residuals Standard Residuals
1 1.794117647 1.205882353 1.442821453
2 3.823529412 -0.823529412 -0.98534148
3 -0.235294118 -0.764705882 -0.914959946
4 -0.235294118 0.235294118 0.281526137
5 5.852941176 0.147058824 0.175953836

Related Solutions

Suppose f(x,y)=(1/8)(6-x-y) for 0<x<2 and 2<y<4. a. Find p(Y<3|X=1) b. Find p(Y<3|0.5<X<1)
Suppose f(x,y)=(1/8)(6-x-y) for 0<x<2 and 2<y<4. a. Find p(Y<3|X=1) b. Find p(Y<3|0.5<X<1)
Solve this differential equation y''+(-4-2-2)y'+(4+4+4+4)y=x y(0)=3-2 y'(0)=2-3 Answer it as y(x)=... and motivate all the steps...
Solve this differential equation y''+(-4-2-2)y'+(4+4+4+4)y=x y(0)=3-2 y'(0)=2-3 Answer it as y(x)=... and motivate all the steps of the calculation
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y).  Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2
Hyperbolas 4(y - 1)^2 - (x + 4)^2 - 36 =0 find the x- and y-...
Hyperbolas 4(y - 1)^2 - (x + 4)^2 - 36 =0 find the x- and y- intercepts. label on graph state the domain and range
2. Consider the following data: x= 1, 2, 3, 4, 5 y =3, 2, 4, 6,...
2. Consider the following data: x= 1, 2, 3, 4, 5 y =3, 2, 4, 6, 5 By hand, not using Matlab, and showing your work: (a) Compute the correlation coefficient. (b) Find the least-squares line. (c) Find the standard deviation around the least-squares line.
Suppose f(x,y)=(1/8)(6-x-y) for 0<x<2 and 2<y<4. If all else is the same, then why can’t x...
Suppose f(x,y)=(1/8)(6-x-y) for 0<x<2 and 2<y<4. If all else is the same, then why can’t x be defined on the range [0,3]? Find p(0.5 < X < 1, 2 < Y < 3) Find fX(x) and fY(y) Are X and Y independent? Why or why not? Find p(0.5 < X < 1) and p(2 < Y < 3) Find p(Y<3|X=1) Find p(Y<3|0.5<X<1)
x (Bins) frequency 0 0 1 0 2 0 3 2 4 5 5 8 6...
x (Bins) frequency 0 0 1 0 2 0 3 2 4 5 5 8 6 13 7 33 8 42 9 66 10 77 11 105 12 103 13 110 14 105 15 84 16 70 17 51 18 40 19 27 20 27 21 15 22 5 23 7 24 2 25 2 26 1 27 0 28 0 29 0 30 0 (7) On the Histogram worksheet, calculate all frequencies of the distribution using the table shown....
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6 1 5 6 8 2 4 6 7 3 4 5 9 10 5 8 9 4 7 9 6 7 8 6 How can I detect when 'cin' starts reading from a new line. The amount of numbers in each row is unknown. I need them in type 'int' to use the data.
Given the following dataset x   1   1   2   3   4   5 y   0   2   4   5  ...
Given the following dataset x   1   1   2   3   4   5 y   0   2   4   5   5   3 We want to test the claim that there is a correlation between xand y. The level of cretaine phosphokinase (CPK) in blood samples measures the amount of muscle damage for athletes. At Jock State University, the level of CPK was determined for each of 25 football players and 15 soccer players before and after practice. The two groups of athletes are trained...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT