Chandrasekaran ,Ramasubramanian-Exam1

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

This preview shows pages 1–9. 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.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

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 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 ~

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

View Full Document
g) Find the standard deviaiton using the grouped data only: 2.19 h) Comment on how the values compare.
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 10/02/2011 for the course MIS 6312 taught by Professor Wiorkowski during the Spring '11 term at University of Texas at Dallas, Richardson.

### 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
Ask a homework question - tutors are online