Excel

 

Flag this Question

Question 21 pts

Suppose cell H1 contains the variance of random variable Z.  What formula would you type in cell H2 to compute the standard deviation from the variance?

	=STDEV(H1)
	=SQRT(H1)

	=H1^2
	=H1*2

 

Flag this Question

Question 31 pts

Assuming cell A1 contains the probability that an event A is to take place, what formula should be typed in cell A2 order to find the probability that the complement ofA is to take place?

	=1/A1
	=A1-1

	=1-A1
	=A1+1

 

Flag this Question

Question 41 pts

Suppose the probability of a coin toss resulting in "heads" is 0.3.  What formula should be typed to compute the probability of having exactly 20 heads in 30 coin tosses?

	=BINOM.DIST(20,30,0.7,TRUE)
	=BINOM.DIST(30,20,0.7, TRUE)

	=BINOM.DIST(20,30,0.3,FALSE)
	=BINOM.INV(20,30,0.3,FALSE)

 

Flag this Question

Question 51 pts

Suppose the probability of selecting RED is 0.8.  What formula could be used to find the probability of selecting 5 or fewer REDs out of 12 trials?

	=BINOM.DIST(5,12,0.8,FALSE)
	=BINOM.DIST(12,5,0.2,TRUE)

	=BINOM.DIST(5,12,0.8,TRUE)
	=BINOM.DIST(5,12,0.2,FALSE)

 

Flag this Question

Question 61 pts Skip to question text.

Given the above values how would one compute the mean of a binomial distribution in Excel?

	=B1+B2
	=B2/B1

	=B1*B2
	=B2^B1

 

Flag this Question

Question 71 pts Skip to question text.

Given the above values, how would one compute the standard deviation of a binomial distribution in Excel?

	=B1*B2
	=SQRT(B1*B2)

	=SQRT(B1*B2*(1-B2))
	=B1*B2*(1-B2)

 

Flag this Question

Question 81 pts

Given the above values, how could one compute the probability of having more than 4 successes in Excel?

	=BINOM.DIST(B3,B1,B2,1)
	=1-BINOM.DIST(B3,B1,B2,1)

	=1-BINOM.DIST(B1,B3,B2,1)
	BINOM.DIST(B1,B3,B2,1)

Given the above image, how could one make use of those three quanities to find a z-score in Excel?

	=B1*B3-B2
	B1-B2/B3

	B2*B3-B1
	=(B1-B2)/B3

 

Flag this Question

Question 21 pts

Which built-in Excel function could be used to find a z-score from a raw-score (i.e., an x-value), mean, and standard deviation?

	STANDARDIZE
	ZSCORE

	Z
	NORMALIZE

 

Flag this Question

Question 31 pts Skip to question text.

Suppose Xis normally distributed with mean μ=11.2 and standard deviation σ=2.1.  Which Excel function should be used to find ?

	=NORM.S.DIST(9,TRUE)
	=NORM.S.INV(9)

	=NORM.INV(9,11,2.1)
	=NORM.DIST(9,11.2,2.1,TRUE)

 

Flag this Question

Question 41 pts Skip to question text.

Suppose X is normally distributed with mean 11 and standard deviation 1.  Which of the following gives the probability that 9.5≤X≤12.2?

	=(NORM.DIST(12.2, 11, 1, TRUE) - NORM.DIST(9.5, 11, 1, TRUE)) -1
	=NORM.DIST(12.2, 11, 1, TRUE) - NORM.DIST(9.5, 11, 1, TRUE)

	=NORM.DIST(9.5, 11, 1, TRUE) - NORM.DIST(12.2, 11, 1, TRUE)
	=1- (NORM.DIST(12.2, 11, 1, TRUE) - NORM.DIST(9.5, 11, 1, TRUE))

 

Flag this Question

Question 51 pts

How would one find the z-score that cuts-off the upper 10% of the standard normal distribution in Excel?

	=NORM.S.INV(0.1)
	=1-NORM.INV(0.1)

	=NORM.S.INV(0.9)
	=NORM.DIST(0.1)

 

Flag this Question

Question 61 pts

How could one compute the probability between 1.5 standard deviations above and below the mean in Excel?

	=1-(NORM.S.DIST(1.5, TRUE)-NORM.DIST(-1.5, TRUE))
	=NORM.S.DIST(1.5, TRUE)-NORM.S.DIST(-1.5,TRUE)

	=1-NORM.S.DIST(1.5, TRUE)+NORM.S.DIST(-1.5,TRUE)
	=ABS(NORM.S.DIST(1.5, TRUE))

Question 11 pts

When using the =RAND() command, Excel will generate new random numbers in each cell every time you sort cells, or edit any cell.

	True
	False

 

Flag this Question

Question 21 pts

In order to "freeze" the values produced by the =RAND() command, we should...

	give =RAND() the value "TRUE" as a argument.
	use the CHANGETOTEXT command.

	copy the cells and use "Paste Special" to paste as a value not a function.
	format the cells to show only four decimal places.

 

Flag this Question

Question 31 pts

When using the Random Number Generator tool in Analysis Toolpak to assign random numbers for the purposes of selecting a simple random sample, we should set the "Distribution" parameter to be...

	Discrete
	Uniform

	Any of the choices is fine.
	Normal

Binomial

 

Flag this Question

Question 41 pts

The Random Number Generator in the Analysis Toolpak can be configured to give random numbers between 3 and 5.

	True
	False

 

Flag this Question

Question 51 pts Skip to question text.

What needs to be changed in the screenshot shown below so that the numbers generated upon clicking "OK" would be like those generated by using the =RAND() command?

	The "Random Seed" field needs to be filled in.
	The numbers in the top two fields need to be switched.

	The -1 should be changed to a zero.
	Change "Uniform" to "Normal" in the drop down menu next to "Distribution"

It's impossible to do this.

 

Flag this Question

Question 61 pts

Generating random numbers with the Analysis Toolpak instead of using the =RAND() command has the advantage that the entries are values (not functions) and so they will not change after they are created.

	True
	False