A separate database on Small Scale Units in csv format is provided for the assignment.There are 62,000 records in the database.The "Code Book" describes the variables as well as value coding in detail.The second row of the worksheet has the names of the variables.There are 65 Fields (variables) including the Sl. No. (record number)

Select a simple random sample of size 6,000 from the given data base.

Procedure to select simple random sample

Generate 6000 random numbers using the function "RANDBETWEEN(1,62000) in any empty column, say Column EG.Copy these values into range BQ3 to BQ6002 as "values" (area shaded for your convenience).Your sample is generated automatically in the range BR3:EC6002.You can copy this into a separate Excel file and save.

Please notice that there are number of blank (empty) cells.

The data refers to the performance of small scale units in the undivided Andhra Pradesh.These units are divided into SSI (Small Scale Industries) and SSSBE (Small Scale Service Business Enterprises)

Based on your sample, carryout the following analysis.Your analysis and the interpretation should be submitted by the due date.Please note that there is no penalty for early submissions!

1.Calculate a 95 percent confidence interval for the "Gross output - Year 3 (Rs)"

2.Calculate a 95 percent confidence interval for the "Net worth of the unit - Year 3 (Rs)"

3.Define two different measures that you consider most appropriate for measuring the performance of the units.This definition is up to you.These can be the variables that are already in the data or new variables defined based on the existing variables (for example you may calculate the gross output per employee as the performance measure or growth rate of Gross Output between Year 1 and Year 3 ).Please explain in one paragraph why you have selected these two measures. Remaining analysis is to be carried based on these definitions.

4.Calculate the average of the first performance measure that you had defined in question 3 above.If the firm's performance is above this average, it is considered GOOD. If it is below average, it is considered BAD.Repeat the same with respect to the second performance measure.

5.Answer the questions below based on each of the two performance measures defined by you earlier:

a.What is the probability that a firm selected at random is a SSSBE unit?

b.What is the probability that a firm selected at random is GOOD in performance? What is the probability that a firm selected is a SSSBE Unit and ALSO GOOD in performance?

c.What is the probability that a firm selected at random is GOOD, given that it is a SSSBE Unit.

d.What can you say about the performance of the SSSBE units in terms of GOOD or BAD based on the above?

6.Calculate a 95% confidence interval for the proportion of GOOD units, based on the first performance measure defined by you.

7.Calculate a 95% confidence interval for the proportion of GOOD units, based on the second performance measure defined by you.

Save your sample.You will be using the same sample for SA 2 assignment.