Econ Hw Excel

profilealmisfer
excel_homeworkassignment_student-2.xlsx
Home>Business & Finance homework help>Economics homework help>Econ Hw Excel

Financial Formulae

ECON 220
Homework #8 (Part A)
Your Name:
Compound Interest Simple Interest
Formula: FV=PV(1+r/m)^mt Formula: FV = PV(1+rt)
Present Value 2000 1000 10000 2000 4000 Present Value 2000 5000 6000 8000 100
rate 12.6% 5.0% 6.0% 1.3% 2.4% rate 1.3% 8.0% 4.7% 2.2% 5.0%
months 12 12 12 4 4 t (years) 6 4 5 15 1
t (years) 2.5 5 5 6 8
n
Future Value Future Value

Regression Line

=INTERCEPT(known_Y, Known_X)
=SLOPE(known_Y, Known_X)
=correl("x's","Y's")
T ("X") GDP ("Y") Year Barrel Oil $ ("X) Continental Net Income ($ million) ("Y")
0 9 2005 56 -70
2 9 2006 63 370
4 10 2007 67 430
6 11 2008 92 -590
8 11 2009 54 -280
10 12 2010 71 150
12 13 SUM
14 13
SUM n=
n=
(a) Obtain a regression line showing continental's net income as a function of the price of oil (4 points) - Use the long method
Slope (m)= =
Y = intercept = Slope (m)= =
y = _____X + ____
Y-intercept =
Using Excel Slope y = _____X + ____
Intercept
correl
b. Obtain the coefficient of r (3 points)- Using the long method
c. Obtain m, b and the coefficient of correlation, r using excel functions (3 points)
Using Excel Slope
Intercept
correl