Question

If the Average or Mean is 30

The Standard Deviation is 6

The Sample Size is 50

How is a bell curve created in Excel?

I have already answered the question which is: What is the sampling distribution of x if a random sample of 50 individuals who have downloaded Spontanversation is used?

Answer: 6/SQRT(50) = .848528

Answer #1

The steps to create a bell curve from given mean and SD

i) Enter In cell A5 enter 27. This value can be calculated using Mean – 3* Standard Deviation (30-3*6/sqrt(50)).

ii) In the cell below it enter 33 and create a series from 27 to
33

(where 33 is Mean + 3* Standard Deviation).

iii) In this cell B5, enter the formula: =NORM.DIST(A5,33,6/sqrt(50),FALSE)

iv) Drag form B5 cell to the below cells

v) Select the (A5 to B17) and go to Insert tab

vi) Insert the ‘Scatter with Smooth Lines’ chart.

The EXCEL output be

Question 5 `
If the standard deviation of the population is 15 and the sample
size is 10,000, the standard error will be:
0
.15
.22
.43
1
points
Question 6
If you draw a sample
of 500, you can be confident that the sampling distribution of
means will:
Have a mean of
500.
Will have a standard
error of 50.
Will be heavily
skewed.
Will be a standard
normal curve.

If x represents a random variable with mean 118 and standard
deviation 30, then the standard deviation of the sampling
distribution of the means with sample size 36 is 5.
True or False

A random sample of size 30 is selected from a known population
with a mean of 13.2 and a standard deviation of 2.1. Samples of the
same size are repeatedly collected, allowing a sampling
distribution of sample means to be drawn.
a. What is the expected shape of the resulting distribution?
b. Where is the sampling distribution of sample means
centered?
c. What is the approximate standard deviation of the sample
means?
2. The lifetimes of a certain type of...

A population has a mean of 161.2 and a standard deviation of
9.6. A sample of size 13 is taken from this population. What is the
standard deviation of the sampling distribution of the
mean? Enter your answer to 3 decimal places.
We have two random variables, A and B. A has a mean of 89.6 and
a standard deviation of 37.7. B has a mean of 23.6 and a standard
deviation of 15.1. If we create a new random variable...

1. A population has a mean of 200 and a standard deviation of
50. A simple random sample of size 100 will be taken and the sample
mean will be used to estimate the population mean.
a. What is the expected value of the sample mean?
b. What is the standard deviation of the sample mean?
c. Confirm whether the Central Limit Theorem is met and explain
it’s significance.
d. Draw the sampling distribution of the sample mean.
e. What...

Given a population
mean of 27.1 with a standard deviation of 8.4 and a sample size of
10, answer these questions:
Part
A: What is the standard deviation of the sampling
distribution of x̄? Show your work. (5 points)
Part
B: What does the sample size need to be if you want the
standard deviation of the sampling distribution of x̄ to be 2.8?
Show your work. (5 points) (10 points)

Mean= 6 Standard Deviation= 2 Sample size= 81. Jason spent $12
on his lunch today. Explain to him, in terms of the normal
distribution curve and standard deviation, why her purchase is not
very typical.

7. If I have a population of an unknown mean and unknown
standard deviation, what is the 95% confidence interval estimate of
the mean if a. A random sample of size 25 gives a mean of 50 and a
standard deviation of 12 b. A random sample of size 16 gives a mean
of 50 and a standard deviation of 12
8. The average cost per night of a hotel room in New York City
is $325. Assume this estimate...

Suppose x has a distribution with a mean of 20 and a standard
deviation of 3. Random samples of size n = 36 are drawn.
Is the sampling distribution of x normal? How do you
know?
What is the mean and the standard deviation of the sampling
distribution of x?
Find the z score corresponding to x = 19.
Find P (x < 19).
Would if be unusual for a random sample of size 36 from the x
distribution to...

Suppose that the volume in a soda can has a mean of 358
milliliters and standard deviation 6 milliliters and that the shape
of the distribution of claims in bell-shaped.
(a) A researcher takes random samples of size n = 6 and
calculates the sample mean x . Create the sampling
distribution for this sample mean x . What is the center
and the standard error of this new sampling distribution? Draw and
label the distribution and provide at least...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 9 minutes ago

asked 22 minutes ago

asked 31 minutes ago

asked 38 minutes ago

asked 52 minutes ago

asked 55 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago