Question

In: Statistics and Probability

Data set: 0, 3, 7, 8, 11, 17, 25, 42, 50, 60, 100 1)Using Excel, compute...

Data set: 0, 3, 7, 8, 11, 17, 25, 42, 50, 60, 100

1)Using Excel, compute the population mean and standard deviation.

2)How many samples of size 3 can you generate out of the population?

3)List all possible samples of size 3 and for each one compute the sample mean.

4)Using the Randbetween function on Excel, select one random sample, and report its mean and standard deviation.

5)For that one sample you have selected, build a 90% confidence interval. Does the interval contain the value of the population mean?

6)Build a 90% confidence interval for each and every sample. What is the proportion of intervals that contain the value of the population mean?

7)Build a relative frequency distribution of the sample means, and build the histogram.

8)The relative frequency distribution of the sample means is known under another name. Which one?

9)Compute the mean and standard deviation of the relative frequency distribution. What do you observe?

10)Can you relate the standard deviation of the relative frequency distribution to the population standard deviation? If so, what is the relationship?

Solutions

Expert Solution

First 5 questions have been solved.

1)Using Excel, compute the population mean and standard deviation.

2)How many samples of size 3 can you generate out of the population?

Without replacement 165 samples can be generated


3)List all possible samples of size 3 and for each one compute the sample mean.

4)Using the Randbetween function on Excel, select one random sample, and report its mean and standard deviation.

5)For that one sample you have selected, build a 90% confidence interval. Does the interval contain the value of the population mean?


Related Solutions

For the data set 1 2 3 4 7 7 7 8 11 12 12 15...
For the data set 1 2 3 4 7 7 7 8 11 12 12 15 15 16 17 17 17 18 20 20 22 24 24 25 26 26 26 26 27 30 32 32 33 34 34 36 38 39 43 44 45 46 47 47 48 51 52 52 53 54 54 54 55 56 58 58 59 61 63 65 65 67 69 70 73 75 75 76 77 77 79 80 81 82 82 (a)...
443 Consider the data set: 8 4 3 6 17 15 13 7 21 11 32...
443 Consider the data set: 8 4 3 6 17 15 13 7 21 11 32 1 1. 1.What is the percentile rank of xi = 21? 2. What is the value corresponding to the 61th percentile, P61? 3. Find outliers, if exist.
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17,...
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17, 22, 15 Group 2 : 21, 15, 16 Group 3 : 7, 8, 3, 10, 6, 4 Group 4 : 13, 6, 17, 27, 20
YEARLY cash flows (100), 25, 40, 50, 60. 17. Find the NPV for the above yearly...
YEARLY cash flows (100), 25, 40, 50, 60. 17. Find the NPV for the above yearly cash flows assuming a 14 % cost of capital. 17A. What is the profitability index for the cash flows above?
Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...
Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70 5 Draw a Histogram Draw a polygon After listening to YouTube “histogram and polygon,” explain how histogram is different and similar to polygon.
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903 Monthly Revenue Growth...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903 Monthly Revenue Growth...
X Y/1 Y/0 Years Exp Successful Unsccessful total 4 17 83 100 8 40 60 100...
X Y/1 Y/0 Years Exp Successful Unsccessful total 4 17 83 100 8 40 60 100 12 50 50 100 16 56 44 100 20 96 4 100 The data in tab #2 pertain to the years of experience of project managers and the numbers of successes and failures they have had on major projects. Use the data set given in tab #2 in the attached Excel workbook and logistic regression to find the following: The probability of success given...
Consider the following set of vectors in R6 S={[-9 7 -8 3 0 -5], [1 -7...
Consider the following set of vectors in R6 S={[-9 7 -8 3 0 -5], [1 -7 3 2 -8 -8], [-6 -14 1 9 -23 -29], [11 -21 14 1 -16 -11], [8 16 -8 8 10 1], [17 -7 13 -8 8 18] (a) (2 points) Demonstrate that S is not a basis for R6. (b) (4 points) Let H = Span S. Find a basis for H and determine its dimension. (c) (2 points) Determine whether v= [1,1,1,−1,−1,−1]...
Using the following sample data; 6, 7, 11, 6, 11, 5, 15, 11, 5; Compute the...
Using the following sample data; 6, 7, 11, 6, 11, 5, 15, 11, 5; Compute the sample standard deviation using either the computing formula or the defining formula. A. 3.6 B. 3.5 C. 3.4 D. 3.3
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT