Statistics: Lab #3
Chapter 6: Continuous
Random Variables and Probability and Chapter 7: Sampling Distributions
You will have two files for this lab, they are separated
below as parts A and B.
Population Data
Question: Can we consider this to be a continuous random variable? Which probability distribution would you expect this random variable to represent? Explain your responses. Keep in mind our assumption of what is serving as the population for now. (2 points)
1. To investigate the shape of this distribution, create a histogram with bins 1 hour wide. Put the histogram in a separate worksheet so you can see it in all its glory. Again, see earlier labs for more details. Adjust the chart so it looks professional with appropriate titles and axes. (2 points)
Question: Describe the probability distribution of your population. Does your histogram approximate a normal distribution? If not, which continuous probability distribution does it most represent? Explain. (3 points)
Population Probability Problem
In your separate document, set up
and solve each of the following 3 probability problems, including a
diagram showing the area you wish to find. (3 points each)
1. QUESTION: What is the probability that one randomly selected Hanover student will exercise less than 12 hours? By now you probably have realized that you need the exponential function to solve.
2. Do the above problem using the Function Wizard. Insert the formula in C2 at the top of your Lab 3 worksheet. Clearly label C1 "Exercise1".
The exponential function in Excel requires a little explaining. There are three boxes to complete in the Function Wizard. The box for x is the value of the random variable. The box for lambda is actually the inverse of the population mean. For example, if mu was equal to 4, you would enter .25 for lambda. The cumulative box requires a �true� for our purposes. By entering "TRUE", you are telling Excel to compute the probability of x taking that value or less. You may need to adjust the result given in the Function Wizard to answer your specific question.
1. QUESTION: What is the probability that one randomly selected Hanover student will exercise between 10 hours and 5 hours in a typical week?
2. Do the above problem using the Function Wizard. Insert
the formula near the previous function at the top of your Lab 3 worksheet.
Clearly label an adjoining cell "Exercise2".
3. QUESTION: What is the probability that a randomly selected Hanover student would exercise more than 15 hours per week?
4. Do the above problem using the Function Wizard. Insert the formula near the previous function at the top of your Lab 3 worksheet. Clearly label an adjoining cell "Exercise3".
Save your file. Remember you only have to submit hard copies of your written solutions and responses to questions above. Show your work. The Excel file must be emailed to me as an attachment.
Sampling from a Population.
Drawing a random sample.
Draw another random sample of n=30, call it "Samp2" and place it in the next column. Repeat step 4 for your second sample, placing your formulas in F33 and F34. Repeat one more time so you have 3 samples of size n=30. (3 points for three random samples and correct formulas)
1. How many different samples of 30
could be drawn from this population? Should the values in cells E33 and E34
differ from values in F33, F34, and G33 and G34, and from your population mean
and standard deviation? Why or why not? (3 points)
2. If you sampled many times (n=30)
from this population, you would produce a sampling
distribution for the mean age for students ().
Question: Should you consider this population finite or
infinite? Explain. What is the expected value (mean) and standard error of the sampling
distribution?
For the next 3 questions, you MUST set
up and calculate the same question using Z-scores and the standard normal
table. Include these solutions, including a diagram, in your written/typed
responses. (3 points each)
3. Question: Using the expected value and standard error of the sampling distribution, calculate the probability that a random sample of n=30 will yield a sample mean that has a sampling error of less than 6 months. Again, do this problem first with Z-scores and the standard normal probability table, then with Excel and the NORMDIST formula. Put output in a cell near the top of the sheet, labeled clearly as Age1. There is an example of how to use this formula in the appendix to chapter 6.
4. Question: What is the probability that a random sample of n=30 is drawn from this population and the sample mean age is greater than 21? Again, do this problem first with Z-scores and the standard normal probability table, then with Excel and the NORMDIST formula. Put output in a cell near the top of the sheet, labeled clearly as Age2.
5. Question: How low would a sample mean need to be such that only 3% of sample means lie below it? Again, do this problem first with Z-scores and the standard normal probability table, then with Excel and the NORMINV formula. Put output in a cell near the top of the sheet, labeled clearly as Age3.
Save your file. Remember you only have to submit hard copies
of your written solutions and responses to questions above. The Excel file must
be emailed to me as an attachment.
OK, you have carefully completed both parts A and B to this lab. You have double-checked that you have all of your typed/written responses to questions. Bring responses and typed comments to class on the due date. Your emailed files must also be sent by the beginning of class on the due date. When you email your file, make sure your name is in the filename. Late assignments or those sent incorrectly will be penalized. Check the syllabus or ask for help if you are uncertain of how to do any of this.