Theory the mean of the sampling distribution of means

Assignment Help Mathematics
Reference no: EM13505277

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 ,

Reference no: EM13505277

Questions Cloud

Find the average speed of the blood : Blood circulating from the heart to the hands and back to the heart travels a distance of about 1.9 m in 42 s. Find the average speed of the blood
Find the total distance traveled and the average speed : During 5 successive 0.93 min intervals, a runner moves at the following constant speeds: 0.424 km/min, 0.224 km/min, 0.160 km/min, 0.160 km/min
Is there an advantage to either method of filing : Is there an advantage to either method of filing? If they postpone their wedding until the January date and file as single persons, will they reduce their tax bill for 2004?
What is tax freedom day : When was Tax Freedom Day in 2002 and 2003? What is Tax Freedom Day?
Theory the mean of the sampling distribution of means : Theory the mean of the sampling distribution of means
Compute the molality of solution that is prepared by mixing : Calculate the molality of a solution that is prepared by mixing 25.5 mL of CH3OH (d= 0.792 g/mL) and 387 mL of CH3CH2CH2OH (d= 0.811 g/mL).
What is the rate of heat loss through the slab : A 10-m-by-14-m house is built on a 12-cm-thick slab of concrete. What is the rate of heat loss through the slab
Impact of variance on unit cost : How much of the 0.40 excess unit cost and how much of the 0.40 excess unit cost is traceable to apprerent inefficient use of labor time
Should the company outsource and why : When the variable cost of outsourcing is $4 per unit, what is the break-even quantity in this case? Please provide the formula, at least one step of calculation, and the correct answer for full credit.

Reviews

Write a Review

Mathematics Questions & Answers

  Find the midpoint of the midsegment of the trapezoid

The vertices of the trapezoid are the origin along with A(4p, 4q), B(4r, 4q), and C(4s, 0). Find the midpoint of the midsegment of the trapezoid.

  Ratio and proportion-elk and fuel efficiency

Park rangers catch, tag, and then release 140 elk back into a national park. One month later, they select a sample of 130 elk, 91 of which are tagged. Assuming the ratio of tagged elk in the sample holds for all elk in the park, approximately how ..

  Find the measure of all three angles of the triangle

In isosceles , B is the vertex. The measure of B can be represented as (8x+2). The measure of A can be represented as (9x-2). Find the measure of all three angles of the triangle. Be sure to name the angle with it's measurement (ex: angle A= ).

  Linear equation in two variables

For each point in the table below, decide whether it is on Line 1, Line 2, both, or neither.

  What is the probability that rene will make the tee

If Mark makes the tee time, then there is a 0.8 chance that Rene will then make the tee time. What is the probability that Rene will make the tee time but Mark will not?

  Analysis the mapping of open intervals

Examine the mapping of open [respectively, closed] intervals under the functions g(x) := 1/(x^2 + 1) and h(x) := x^3 for x in R

  Find the rating probability between 230 and 260

Find the probability that they will have a rating between 230 and 260

  Find the absolute max and min

Find the absolute max and min.

  Thirty-five fourth-grade students were asked traditional

thirty-five fourth-grade students were asked the traditional question what do you want to be when you grow up?nbsp the

  Can a linear equation and a linear inequality be solved

Can a linear equation and a linear inequality be solved in the same way? Explain why? What makes them different?

  How many tennis rackets of each type should csd manufacture

How many tennis rackets of each type should CSD manufacture over the next two weeks to maximize the total profit contribution? Assume that because of the unique nature of their products, CSD can sell as many rackets as they can produce.

  For how many miles did he drive the truck

Sung rented a truck for one day. There was a base fee of $16.95 , and there was an additional charge of 89 cents for each mile driven. Sung had to pay $151.34 when he returned the truck. For how many miles did he drive the truck?

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd