HW13data

HW13data - Example: Y variable=Ford, X var DATE IBM...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Example: Y variable= DATE IBM Ford 19600129 -0.05 -0.13 -0.07 19600229 0.01 -0.01 0.01 19600331 0.05 -0.1 -0.01 19600429 0.03 -0.05 -0.02 19600531 0.12 0.01 0.03 19600630 0.04 0 0.02 19600729 0 0 -0.02 19600831 0.02 0.01 0.03 19600930 -0.04 -0.03 -0.06 19601031 -0.01 0.01 0 19601130 0.09 -0.01 0.04 19601230 0.06 0.01 0.05 19610131 0.07 0.1 0.06 19610228 0.06 0.07 0.03 19610330 0.03 0.07 0.03 Covar(Ford, S&P) 0 19610428 0.03 0.03 0 Variance(S&P) 0 19610531 0.03 0.04 0.02 b 1.25 19610630 -0.03 -0.04 -0.03 a 0 19610731 0.02 0.12 0.03 19610831 0.07 0.06 0.02 AVERAGE(C3:C602)-H19*AVE 19610929 0.04 0.1 -0.02 REGRESSION IN EXCEL 19611031 0.09 -0.01 0.03 19611130 -0.01 0.11 0.04 Coefficients 19611229 0 -0.02 0 Intercept 0.005 19620131 -0.06 -0.05 -0.04 X Variable 1 1.251 19620228 -0.01 -0.02 0.02 19620330 -0.01 -0.1 -0.01 19620430 -0.15 0.01 -0.06 19620531 -0.13 -0.09 -0.09 19620629 -0.14 -0.1 -0.08 19620731 0.14 0.13 0.06 19620831 0.03 0.03 0.02 19620928 -0.11 -0.07 -0.05 19621031 -0.02 0.01 0 19621130 0.15 0.1 0.1 19621231 -0.02 -0.01 0.01 19630131 0.09 -0.02 0.05 19630228 -0.05 -0.04 -0.03 19630329 0.05 0.1 0.04 19630430 0.1 0.06 0.05 19630531 0.03 0.07 0.01 19630628 -0.09 0 -0.02 19630731 0 -0.02 0 19630830 0.03 0.06 0.05 19630930 0.02 0 -0.01 19631031 0.09 -0.02 0.03 19631129 -0.02 0 -0.01 19631231 0.04 -0.04 0.02 0 0.5 1 1.5 f(x) = 1.25x + 0 urn on Ford -0.25 -0.2 -0.3 -0.2 -0.1 0 0.1 0.2 0.3 0.4
Background image of page 1

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

View Full DocumentRight Arrow Icon
19640131 0.07 0.01 0.03 19640228 0.05 0.09 0.01 19640331 0.04 -0.01 0.02 19640430 -0.04 0.03 0.01 19640528 0.05 -0.04 0.01 19640630 -0.01 -0.01 0.02 19640731 -0.03 0 0.02 19640831 -0.04 0 -0.02 19640930 -0.01 0.12 0.03 19641030 -0.04 0.02 0.01 19641130 -0.01 -0.06 -0.01 19641231 -0.01 -0.02 0 19650129 0.1 0.03 0.03 19650226 0.02 -0.03 0 19650331 0 0.03 -0.01 19650430 0.07 0.11 0.03 19650528 -0.01 -0.07 -0.01 19650630 -0.04 -0.08 -0.05 19650730 0.05 0.02 0.01 19650831 0.04 0 0.02 19650930 0.03 0.04 0.03 19651029 0.04 0.1 0.03 19651130 -0.01 -0.08 -0.01 19651231 -0.05 -0.03 0.01 19660131 -0.01 -0.01 0 19660228 0.04 -0.01 -0.02 19660331 0 -0.04 -0.02 19660429 0.08 -0.01 0.02 19660531 -0.02 -0.04 -0.05 19660630 -0.03 -0.04 -0.02 19660729 -0.03 0.01 -0.01 19660831 -0.06 -0.05 -0.08 19660930 -0.01 -0.02 -0.01 19661031 0.05 0.02 0.05 19661130 0.14 -0.06 0 19661230 -0.01 -0.03 0 19670131 0.08 0.2 0.08 19670228 0.08 0 0 19670331 0.05 0.12 0.04 19670428 0.1 0.08 0.04 19670531 -0.04 -0.08 -0.05 19670630 0.07 0.02 0.02 19670731 0.02 0.03 0.05 19670831 -0.01 -0.02 -0.01 19670929 0.1 0.05 0.03 19671031 0.08 -0.04 -0.03 19671130 0.03 0.04 0 19671229 0.02 0.02 0.03 19680131 -0.05 -0.04 -0.04 19680229 -0.02 -0.02 -0.03 19680329 0.06 -0.03 0.01 -0.3 -0.25 -0.2 -1 -0.5 Retur
Background image of page 2
19680430 0.11 0.2 0.08 19680531 0.06 -0.02 0.01 19680628 -0.01 -0.07 0.01 19680730 -0.04 -0.01 -0.02 19680830 -0.01 0 0.01 19680930 0 0.11 0.04 19681031 -0.08 0.06 0.01 19681129 0.09 -0.08 0.05 19681231 -0.06 -0.04 -0.04 19690131 -0.06 -0.04 -0.01 19690228 -0.01 -0.01 -0.05 19690328 0.07 0.02 0.03 19690430 0.04 0.03 0.02 19690529 -0.03 -0.04 0 19690630 0.06 -0.06 -0.06 19690731 -0.04 -0.07 -0.06 19690829 0.07 0.1 0.04 19690930 0 -0.09 -0.03 19691031 0.04 0.04 0.04 19691128 -0.01 -0.04 -0.04 19691231 0.02 -0.03 -0.02 19700130 -0.08
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/17/2011 for the course BUS M 410 taught by Professor Brianboyer during the Fall '10 term at BYU.

Page1 / 36

HW13data - Example: Y variable=Ford, X var DATE IBM...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online