Assignment on Statistics Lab

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’=...