Chandrasekaran ,Ramasubramanian-Exam1

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
random nos he fix values
Background image of page 4
Background image of page 5

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

View Full Document Right Arrow Icon
repetitive values ghted values are omitted ary. Just take first five values in Column C. No deduct
Background image of page 6
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
Background image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
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 Right Arrow Icon
Ask a homework question - tutors are online