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....
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
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
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.
Let f(x,y)= (3/2)(x^2+y^2 ) in 0≤x≤1, 0≤y≤1. (a) Find V(X) (b) Find V(Y)
Let f(x,y)= (3/2)(x^2+y^2 ) in 0≤x≤1, 0≤y≤1. (a) Find V(X) (b) Find V(Y)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT