Submitted by: Submitted by Mabruk
Views: 412
Words: 415
Pages: 2
Category: Other Topics
Date Submitted: 11/05/2012 08:21 AM
Assignment answer-1
Year | Code(y) | sales(x) (with ID added) | sales(x) |
1997 | 1 | 50,723 | 50,600 |
1998 | 2 | 67,423 | 67,300 |
1999 | 3 | 80,923 | 80,800 |
2000 | 4 | 98,223 | 98,100 |
2001 | 5 | 124,523 | 124,400 |
2002 | 6 | 156,823 | 156,700 |
2003 | 7 | 201,523 | 201,400 |
2004 | 8 | 227,423 | 227,300 |
2005 | 9 | 256,423 | 256,300 |
2006 | 10 | 281,023 | 280,900 |
Interpretation:
a=5489
b=27093
y’= 5489+27093t
Now,
1. 5489 is the point where trend line intersects the y axis. So, 5489 point is the y intersects.
2. If, the time is increased by one year, sales will be increased by an amount of 27093
Here, t=14
Y’= 5489+27093(14)
= 3847941
So, the sales for 2010 would be $ 384791.
Interpretation:
From the graph, we can see that sales are gradually increasing. Here, blue dot is the original data and pink dot is the predicted data. So, this graph shows a trend line equation where sales are gradually increasing.
Assignment answer-2
Year | Imports of Carbon Block (thousands of tons) | Imports of Carbon Block (thousands of tons) Id added | Code(Y) | Log of Imports of Carbon Block (thousands of tons) Id added |
1990 | 124 | 247 | 1 | 2.392696953 |
1991 | 175 | 298 | 2 | 2.474216264 |
1992 | 306 | 429 | 3 | 2.632457292 |
1993 | 524 | 647 | 4 | 2.810904281 |
1994 | 714 | 837 | 5 | 2.922725458 |
1995 | 1052 | 1175 | 6 | 3.070037867 |
1996 | 1638 | 1761 | 7 | 3.245759356 |
1997 | 2463 | 2586 | 8 | 3.412628521 |
1998 | 3358 | 3481 | 9 | 3.541704023 |
1999 | 4181 | 4304 | 10 | 3.633872263 |
2000 | 5388 | 5511 | 11 | 3.741230411 |
2001 | 8027 | 8150 | 12 | 3.911157609 |
2002 | 10587 | 10710 | 13 | 4.029789471 |
2003 | 13537 | 13660 | 14 | 4.135450699 |
Interpretation:
Here
Log a= 2.245
Log b= 0.138
Log Y’=2.245+0.138t
b= Antilog 0.138
= 1.370882
Sales increases annually by= b-1
= 1.370882-1 = 0.370882 or 37.0882%
So, sales is increased by 37.0882% annually
Here, t=17
Log Y’=...