Chandrasekaran ,Ramasubramanian-Exam1

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

Info iconThis preview shows pages 1–9. 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.61 0.54 use the rand fn to generate the r 2 0.79 0.98 copy and paste special to get th 3 0.5 0.24 4 0.01 0.54 5 0.09 0.14 6 0.16 0.26 7 0.83 0.97 8 0.9 0.06 9 0.23 0.55 10 0.29 0.2 11 0.72 0.86 12 0.72 0.07 13 0.73 0.82 14 0.79 0.07 15 0.36 0.65 16 0.68 0.88 17 0.86 0.37 18 0.65 0.48 19 0.83 0.16 20 0.88 0.78 21 0.43 0.28 22 0.05 0.58 23 0.96 0.54 24 0.1 0.84 25 0.82 0.75 26 0.67 0.71 27 0.04 0.74 28 0.6 0.77 29 0.13 1 30 0.35 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 DocumentRight 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 DocumentRight 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 DocumentRight 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 8.80 4.75 9.40 6.25 4.86 6.48 7.83 7.49 4.60 2.55 8.74 8.36 7.62 7.25 8.12 6.61 3.27 5.67 4.75 8.95 9.78 7.37 9.28 7.72 4.47 9.27 5.10 5.50 3.85 3.27 9.34 4.75 5.45 4.56 7.76 6.49 5.80 8.01 7.42 8.36 1.02 5.03 7.47 6.77 7.99 2.85 4.99 5.78 5.21 3.73 5.11 7.28 6.59 5.19 6.91 4.16 10.71 8.23 4.43 7.17 7.54 10.80 7.60 4.48 1.81 3.60 11.02 10.72 4.32 3.21 7.14 6.67 8.98 4.45 5.61 11.62 6.42 7.76 8.53 a) Find the arithmetic mean of this data: 6.37 b) Find the median of this data: 6.06 c) Find the standard deviation of this data: 2.18 d) Construct a Histogram of this Data using intervals starting at 1 and increasing by 1 u bins F Low High Midpoint 1 0.00 1.00 2.00 1.50 2 2.00 2.00 3.00 2.50 3 Bin Frequency 5.00 3.00 4.00 3.50 4 1 0 13.00 4.00 5.00 4.50 5 2 2 27.00 5.00 6.00 5.50 6 3 3 50.00 6.00 7.00 6.50 7 4 8 61.00 7.00 8.00 7.50 8 5 14 78.00 8.00 9.00 8.50 9 6 23 88.00 9.00 10.00 9.50 10 7 11 94 10 11 10.5 11 8 17 98 11 12 11.5 12 9 10 100 10 6 11 4 12 2 More 0 e) Find the arithmetic mean using the grouped data only: 6.34 (I.e. pretend you don't have the raw data, just the histogram) f) Find the median using the grouped data only: 9.41 = x = med x ~ = s = x = med x ~
Background image of page 7

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

View Full DocumentRight Arrow Icon
g) Find the standard deviaiton using the grouped data only: 2.19 h) Comment on how the values compare.
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 51

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online