Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
3. This question will use Excel to select random samples of varying sizes from a uniform distribution on the interval 1 to 10. The goal is to demonstrate the effect of sample size on the shape of the sampling distribution of the mean. This problem is similar to Example 1 page 308 of the text. A. Open the Excel and go to the DATA tab. B. Select Data Analysis on the ribbon. If Data Analysis is not available on the ribbon you must install the Analysis Toolpak add-in as described on page 42 of the text. C. You should now see the Data Analysis dialog box Select Random Number Generation and click OK. (See diagram page 525 of the text.) ? For Number of Variables enter 2 ? for Number of Random Numbers enter 50 ? for Distribution select Uniform ? for Parameters enter Between 1 and 10 ? for Output options Select New Worksheet Ply ? You will see 50 rows and 2 columns of numbers. The rows will be considered as the random samples drawn from the uniform distribution on 1-10. In this case this means that there are 50 samples each of size 2. In the first cell of the empty column (cell C1 for this case) enter a formula to find the mean of your sample in the first row. Drag the formula down to the end of the data, i.e. to row 50. The 50 means in column C1 become out first sample of means. D. Copy your means to a new worksheet. Use Excel to calculate the mean and standard deviation of this sample. Create a histogram of the distribution of the sample of means. For the histogram use boundaries 1, 2, 3 ...10. Refer to Assignment 1 for directions on histograms E. Repeat Steps C and D three more times ? The second time set the Number of Variables to any a value between 5 and 10 ? The second time set the Number of Variables to any a value between 20 and 25 ? The second time set the Number of Variables to any a value between 31 and 36 F. You have a total of 4 samples of means and a histogram of each. Arrange the histograms so they are all on one page. G. For the uniform distribution on 1 to 10 the population mean is 5.5 and the population standard deviation is 2.5981. In ,
The dimensions of a triangular lot are 160 feet by 80 feet by 120 feet. If the price of such land is $3 per square foot, how much does the land cost?
use this distribution for finding confidence intervals for the population mean when the sample size is less than 30 and
Kelly Fisher has a total of $33,000 invested in two municipal bonds that have yields of 8% and 10% interest per year, respectively. If the interest Kelly receives from the bonds in a year is $2920, how much does she have invested in each bond?
you invested $22,000 in two accounts paying 7% and 8% annual interest. If the total interest rate earned for the year was $1740, how much was invested at each rate?
the pie contained 17 raspberries, 3 pech, 28 apple, 4 pear, 89 raisin, 67 cherries and 2 plum slices. how many time will jack have to stick his thumb into the pie before he can pull two pieces of same kind of fruit.
a rock is dropped into a pond and causes a ripple, find the rate of the area of the ripple when the radius is 4.
Computing the height of the building -If, at this point, he is 12 feet from the building, what is the height of the building? Draw a picture, show all work, and find the solution. Round to the nearest hundredths.
A certain bacteria population is known to doubles every 90 minutes. Suppose that there are initially 80 bacteria.
Find the value of x & y that solve the following system of equations:
ith a square base of side z is four times higher than it is wide. Express the volume V of the box as a function of z.
How many acres should the farmer allow for each vegetable in order to maximize profit?
What is the claim? Compute the critical value for a=0.05, compute the test value. Is there sufficient evidence to support he claim?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd