MTH302 Final Term Subjective

Subject code – MTH 302 (Fall-2004)

questions:

d. You have to solve the questions on Excel sheet and don’t use more then

For X and Y data calculate the StDev of X and Y, Cov(X,Y) and correlation between X and Y. Use only basic formulas in the Worksheet.

X

Y

Q3. Annual discount rate is 12%. Initial cost of investment 1 year from today is Rs.15000. Return from first year is Rs. 4000. Return from second year is 4500.

Return from third year is Rs. 6500. What is the net present value of this investment? Use Excel function NPV.

Q4. Plot the above data as actual data as well as moving averages.

Known · y · Known · x

Q5. For the data shown below find simple averages, moving averages, actual – trend and seasonal variations.

Day Period · Data · 1 Morning · Afternoon · Evening · 2 Morning · Afternoon · Evening · 3 Morning · Afternoon · Evening

Q6. For the data given below find seasonal variations and plot the data as a line graph.

Qtr Actual

Q7.

1. There are 120 objects. The number of objects in each permutation is 4. Find the total number of permutations.
2. Probability of success is 65%. What is the probability of 8 successes out of 9? Use BINOMDIST for the