Assignment 1 additoonal doc
akrofi
assignment_1.xlsx
Option 1-solutions
| Option#1 |
Qd |
Constant |
P |
A |
Px |
I |
M |
Solution |
| Est.Coeff. |
| -5,200 |
-42 |
0.20 |
20 |
5.20 |
0.25 |
| Var.Values |
|
| 500 |
10,000 |
600 |
5,500 |
5,000 |
|
| Qd= |
-5,200 |
-21,000 |
2,000 |
12,000 |
28,600 |
1,250 |
17,650 |
|
| Qd= |
-5,200 |
-42P |
|
|
|
| 43,850 |
| Demand Function |
Qd= |
38,650 |
-42P |
| Price Values= |
| 38,650 |
-42 |
100 |
200 |
300 |
400 |
500 |
600 |
|
| Qd= |
17,650 |
| 34,450 |
30,250 |
26,050 |
21,850 |
17,650 |
13,450 |
|
| Ed= |
| -1.1898016997 |
|
| Ea= |
|
| 0.1133 |
|
| Epx= |
|
|
| 0.6799 |
|
| Ei= |
|
|
|
| 1.6204 |
|
| Em= |
|
|
|
|
| 0.0708 |
|
| Qs= |
5200 |
45P |
= Qd = |
38650 |
-42P |
| Equilibrium= |
|
| 87P = |
33450 |
|
|
|
| P = |
384.48 |
cents |
|
| Qs = |
5200 + |
45P = |
22502 |
|
| Qd = |
38650 |
-42P = |
22502 |
|
| Qeq = |
22502 |
Peq= |
$ 3.8448 |
or |
384.48cents |
|
|
| units |
|
|
| per unit |
| Price Values= |
|
|
| 100 |
200 |
300 |
400 |
500 |
600 |
|
| Qd= |
|
| 34,450 |
30,250 |
26,050 |
21,850 |
17,650 |
13,450 |
|
| Qd= |
38,650 |
-42 |
|
| Qs= |
5200 |
45 |
|
| Qs= |
|
| 9,700 |
14,200 |
18,700 |
23,200 |
27,700 |
32,200 |
Sheet1
| Option#1 |
Qd |
Constant |
P |
A |
Px |
I |
M |
Solution |
| Est.Coeff. |
| -5,200 |
-42 |
0.20 |
20 |
5.20 |
0.25 |
| Var.Values |
|
| 5 |
10,000 |
6 |
5,500 |
5,000 |
|
| Qd= |
-5,200 |
-210 |
2,000 |
120 |
28,600 |
1,250 |
26,560 |
|
| Qd= |
-5,200 |
-42P |
|
|
|
| 31,970 |
| Demand Function |
Qd= |
26,770 |
-42P |
| Price Values= |
| 38,650 |
-42 |
1 |
2 |
3 |
4 |
5 |
6 |
|
| Qd= |
38,440 |
| 38,608 |
38,566 |
38,524 |
38,482 |
38,440 |
38,398 |
|
| Ed= |
| -0.0054630593 |
|
| Ea= |
|
| 0.0520 |
|
| Epx= |
|
|
| 0.0031 |
|
| Ei= |
|
|
|
| 0.7440 |
|
| Em= |
|
|
|
|
| 0.0325 |
|
| Qs= |
5200 |
45P |
= Qd = |
38650 |
-42P |
| Equilibrium= |
|
| 87P = |
33450 |
|
|
|
| P = |
384.48 |
cents |
|
| Qs = |
5200 + |
45P = |
22502 |
|
| Qd = |
38650 |
-42P = |
22502 |
|
| Qeq = |
22502 |
Peq= |
$ 3.8448 |
or |
384.48cents |
|
|
| units |
|
|
| per unit |
| Price Values= |
|
|
| 100 |
200 |
300 |
400 |
500 |
600 |
|
| Qd= |
|
| 34,450 |
30,250 |
26,050 |
21,850 |
17,650 |
13,450 |
|
| Qd= |
38,650 |
-42 |
|
| Qs= |
5200 |
45 |
|
| Qs= |
|
| 9,700 |
14,200 |
18,700 |
23,200 |
27,700 |
32,200 |