Chandrasekaran ,Ramasubramanian-Exam1

# Chandrasekaran ,Ramasubramanian-Exam1 - Problem 1 2 3 4 5...

This preview shows pages 1–8. Sign up to view the full content.

Problem Value Earned 1 20 20 2 20 17 3 20 20 4 20 20 5 20 20 Total 100 97 1) There are 30 employees from which you wish to select five for a committee. You wish to make the selection randomly. In the space below, construct such a random sample. Remember to "fix" your random numbers so that they do not keep changing before taking your sample. Show and annotate all your work. Answer: Employee Values random fix values 1 0.8 0.54 use the rand fn to generate the r 2 0.9 0.98 copy and paste special to get th 3 0.84 0.24 4 0.16 0.54 5 0.51 0.14 6 0.56 0.26 7 0.25 0.97 8 0.43 0.06 9 0.08 0.55 10 0.39 0.2 11 0.43 0.86 12 0.6 0.07 13 0.26 0.82 14 0.35 0.07 15 0.19 0.65 16 0.14 0.88 17 0.94 0.37 18 0.27 0.48 19 0.56 0.16 20 0.5 0.78 21 0.55 0.28 22 0.12 0.58 23 0.75 0.54 24 0.33 0.84 25 0.7 0.75 26 0.48 0.71 27 0.45 0.74 28 0.1 0.77 29 0.95 1 30 0.17 0.69 generate random nos for the 30 employees using the rand fn Step 2: now multiply by the size to get the random nos Employee random fix valvalue

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
1 0.54 16.26 2 0.98 29.46 3 0.24 7.1 4 0.54 16.29 5 0.14 4.09 6 0.26 7.78 7 0.97 29.23 8 0.06 1.73 9 0.55 16.51 10 0.2 6.1 11 0.86 25.73 12 0.07 2.16 13 0.82 24.54 14 0.07 2.17 15 0.65 19.52 16 0.88 26.53 17 0.37 11 18 0.48 14.25 19 0.16 4.72 20 0.78 23.34 21 0.28 8.39 22 0.58 17.5 23 0.54 16.17 24 0.84 25.27 25 0.75 22.57 26 0.71 21.15 27 0.74 22.26 28 0.77 23.24 29 1 29.86 30 0.69 20.75 Step 3: now using the round fn round the nos to integers Employee random valuesvalue rounded values 1 0.54 16.26 16 2 0.98 29.46 29 3 0.24 7.1 7 4 0.54 16.29 16 5 0.14 4.09 4 6 0.26 7.78 8 7 0.97 29.23 29 8 0.06 1.73 2 9 0.55 16.51 17 10 0.2 6.1 6 11 0.86 25.73 26 12 0.07 2.16 2 13 0.82 24.54 25 14 0.07 2.17 2 15 0.65 19.52 20 16 0.88 26.53 27 17 0.37 11 11 18 0.48 14.25 14
19 0.16 4.72 5 20 0.78 23.34 23 21 0.28 8.39 8 22 0.58 17.5 17 23 0.54 16.17 16 24 0.84 25.27 25 25 0.75 22.57 23 26 0.71 21.15 21 27 0.74 22.26 22 28 0.77 23.24 23 29 1 29.86 30 30 0.69 20.75 21 Step 4: now arrange the values according to rounded values in column f and omit the Employee random valuesvalue rounded values 8 0.06 1.73 2 12 0.07 2.16 2 <=omit the highlig 14 0.07 2.17 2 <=omit 5 0.14 4.09 4 19 0.16 4.72 5 Unnecessa 10 0.2 6.1 6 3 0.24 7.1 7 6 0.26 7.78 8 21 0.28 8.39 8 17 0.37 11 11 18 0.48 14.25 14 1 0.54 16.26 16 4 0.54 16.29 16 23 0.54 16.17 16 9 0.55 16.51 17 22 0.58 17.5 17 15 0.65 19.52 20 26 0.71 21.15 21 30 0.69 20.75 21 27 0.74 22.26 22 20 0.78 23.34 23 25 0.75 22.57 23 28 0.77 23.24 23 13 0.82 24.54 25 24 0.84 25.27 25 11 0.86 25.73 26 16 0.88 26.53 27 2 0.98 29.46 29 7 0.97 29.23 29 29 1 29.86 30 Step 5: Hence we get the 5 committee members as the following 8 5 19 10 3

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
random nos he fix values

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
repetitive values ghted values are omitted ary. Just take first five values in Column C. No deduct
2) The following data represents a random sample of the daily "annualized" rates of (The "anualized rate" is the rate that would occur in a one year period if the daily rate for an entire year). 5.62

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 23

Chandrasekaran ,Ramasubramanian-Exam1 - Problem 1 2 3 4 5...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online