fm3_chapter33

Regression slope 00890 macro regression r squared

This preview shows pages 22–34. Sign up to view the full content.

Regression slope -0.0890 #MACRO? Regression r-squared 0.8189 #MACRO? 25 35 45 55 0 2 4 6 8 10 12 14 f(x) = -0.09x + 14.33 R² = 0.82 XY Scatter Plot o A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
5 65 75 of Data F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
UN-22M a b 3 Simon 6 Howie q 7 Jack Howie ### USING THE INDEX FUNCTION A B C 1 2 3 4 5 6

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
USING LINEST FOR A SIMPLE R Observation X Y 1 35.3 10.98 2 29.7 11.13 3 30.8 12.51 4 58.8 8.4 5 61.4 9.27 6 71.3 8.73 7 74.4 6.36 8 76.7 8.5 9 70.7 7.82 10 57.5 9.14 Linest output slope intercept 0.1422 0.0000 Standard error of slope --> 0.0868 5.1412 0.8189 0.8117 F statistic --> 36.1825 8 -152.0121 181.1204 Slope 0.1422 Intercept 0.0000 0.8189 t-statistic 0.0000 Slope 0.1422 Standard error of slope 0.0868 t-statistic 1.6388 Slope (also =slope(C3:C12,B3:B12) )--> R 2 (also =Rsq(C3:C12,B3:B12) ) --> SS xy = Slope*(summed product of observations from means) --> R 2 A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
REGRESSION <-- Intercept <-- Standard error of intercept <-- Degrees of freedom <-- SSE = Residual sum of squares #MACRO? #MACRO? #MACRO? #MACRO? #MACRO? #MACRO? #MACRO? <-- Standard error of y values (also =Steyx(C3:C12,B3:B12) ) D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
UN-22T USING LINEST TO DO A MULTIPLE REGRESSION Observation Y Predicted Y 1 35.3 81.2 10.98 5.4968 ### 2 29.7 22.5 11.13 3.9548 3 30.8 77.3 12.51 4.8904 4 58.8 34.8 8.4 7.6873 5 61.4 55.1 9.27 8.3015 6 71.3 124.8 8.73 10.5293 7 74.4 18.5 6.36 9.3534 8 76.7 234.6 8.5 12.7940 9 70.7 22.5 7.82 8.9602 10 57.5 123.3 9.14 8.8226 intercept Slope --> 0.0146 0.1221 0.0000 <-- Intercept Standard error --> 0.0240 0.0413 #N/A -4.9464 4.6515 #N/A F statistic --> -3.3273 8.0000 #N/A -143.9816 173.0899 #N/A ### X 1 X 2 x 2 coeff. x 1 coeff. R 2 --> SS xy --> The regression equation is Y = 14.1705 - 0.0987*x 1 + 0.0089*x 2 The chart shows the predicted versus the actual Y. If all the predictions were exact (i.e., R2 = 100%), then the predicted points would all fall on the45-degree line (the dark line). 5 6 7 8 9 10 11 12 13 6 7 8 9 10 11 12 Actual Y Predicted Y A B C D E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
THE IF FUNCTION Initial number 2 If statement 15 #MACRO? Initial number 2 If statement Less than or equal to 3 #MACRO? A B C 1 2 3 4 5 6

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
UN-22U VLOOKUP FUNCTION Income 0 0% 8,000 15% 14,000 25% 25,000 38% Income 15,000 Tax rate 25% #MACRO? Tax rate A B C 1 2 3 4 5 6 7 8 9
Data 10.98 11.13 12.51 8.40 9.27 8.73 6.36 8.50 7.82 9.14 Ranking, k 3 K-th largest 10.98 #MACRO? Specific number 9.27 Rank from top 4 #MACRO? Rank from bottom 7 #MACRO? Percentile rank 0.8 Percentile 11.01 #MACRO? Specific number 9.27 Percentile ranking 0.67 #MACRO? LARGE, RANK, PERCENTILE, PERCENT RANK A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
COUNT, COUNTA, COUNTIF 3 #MACRO? 1 6 #MACRO? 3 five Count : Count only numerical values CountA : count all non-blank cells A B C D E 1 2 3 4
two 4 six F 1 2 3 4

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Number of returns 52 #MACRO? Returns over 2% 13 #MACRO? Cutoff 5% Returns over cutoff 2 #MACRO? Date Return 3-Jan-06 31.82 9-Jan-06 32.15 1.03% #MACRO? 17-Jan-06 31.94 -0.66% 23-Jan-06 33.33 4.26% 30-Jan-06 33.04 -0.87% 6-Feb-06 32.96 -0.24% 13-Feb-06 34.63 4.94% 21-Feb-06 33.72 -2.66% 27-Feb-06 33.81 0.27% 6-Mar-06 33.76 -0.15% 13-Mar-06 34.61 2.49% 20-Mar-06 35.01 1.15% 27-Mar-06 34.22 -2.28% 3-Apr-06 33.48 -2.19% 10-Apr-06 32.96 -1.57% 17-Apr-06 33.74 2.34% 24-Apr-06 33.43 -0.92% 1-May-06 33.49 0.18% 8-May-06 33.3 -0.57% 15-May-06 33.43 0.39% 22-May-06 33.57 0.42% 30-May-06 33.36 -0.63% 5-Jun-06 33.22 -0.42% 12-Jun-06 33.81 1.76% 19-Jun-06 34.33 1.53% 26-Jun-06 35.79 4.16% 3-Jul-06 36.32 1.47% 10-Jul-06 35.52 -2.23% 17-Jul-06 36.71 3.30% 24-Jul-06 40.4 9.58% 31-Jul-06 40.63 0.57% 7-Aug-06 39.89 -1.84% 14-Aug-06 38.83 -2.69% 21-Aug-06 39.73 2.29% 28-Aug-06 40.62 2.22% 5-Sep-06 40.72 0.25% 11-Sep-06 40.76 0.10% 18-Sep-06 41.69 2.26% 25-Sep-06 41.55 -0.34% 2-Oct-06 41.51 -0.10%
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern