# Excel and math

If I enter **=SUMPRODUCT(E1:F1, E2:F2)** in cell G3, the result of the computation will be…

[removed] |
60 |

[removed] |
147 |

[removed] |
41 |

[removed] |
31 |

[removed] |
An error, #NUM! |

Flag this Question

**Question 2****1 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?**

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?

[removed] |
=H1*2 |

[removed] |
=H1^2 |

[removed] |
=STDEV(H1) |

[removed] |
=SQRT(H1) |

Flag this Question

**Question 3****1 pts****Assuming cell A1 contains the probability that an event <em>A</em> is to take place, what formula should be typed in cell A2 order to find the probability that the complement of <em>A</em> is to take place?<em><br></em>**

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 of*A* is to take place?

[removed] |
=1-A1 |

[removed] |
=A1+1 |

[removed] |
=A1-1 |

[removed] |
=1/A1 |

Flag this Question

**Question 4****1 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?**

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?

[removed] |
=BINOM.DIST(20,30,0.7,TRUE) |

[removed] |
=BINOM.DIST(30,20,0.7, TRUE) |

[removed] |
=BINOM.DIST(20,30,0.3,FALSE) |

[removed] |
=BINOM.INV(20,30,0.3,FALSE) |

Flag this Question

**Question 5****1 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?**

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?

[removed] |
=BINOM.DIST(5,12,0.8,FALSE) |

[removed] |
=BINOM.DIST(5,12,0.8,TRUE) |

[removed] |
=BINOM.DIST(5,12,0.2,FALSE) |

[removed] |
=BINOM.DIST(12,5,0.2,TRUE) |

Flag this Question

**Question 6****1 pts****Skip to question text.**

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

[removed] |
=B1*B2 |

[removed] |
=B2/B1 |

[removed] |
=B1+B2 |

[removed] |
=B2^B1 |

Flag this Question

**Question 7****1 pts****Skip to question text.**

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

[removed] |
=B1*B2 |

[removed] |
=B1*B2*(1-B2) |

[removed] |
=SQRT(B1*B2) |

[removed] |
=SQRT(B1*B2*(1-B2)) |

Flag this Question

**Question 8****1 pts****<p><img src=”/assessment_questions/61059018/files/47847197/download?verifier=c24OZTrAbhdEye4lWFIeNVhOLCFHA8YoFVIfNxPt” alt=”3.jpg”></p> <p>Given the above values, how would one compute the probability of having more than 4 successes in Excel?</p>**

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

[removed] |
=BINOM.DIST(B3,B1,B2,1) |

[removed] |
=1-BINOM.DIST(B3,B1,B2,1) |

[removed] |
=1-BINOM.DIST(B1,B3,B2,1) |

[removed] |
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?

[removed] |
=B1*B3-B2 |

[removed] |
B1-B2/B3 |

[removed] |
B2*B3-B1 |

[removed] |
=(B1-B2)/B3 |

Flag this Question

**Question 2****1 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?**

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?

[removed] |
STANDARDIZE |

[removed] |
Z |

[removed] |
ZSCORE |

[removed] |
NORMALIZE |

Flag this Question

**Question 3****1 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 ?

[removed] |
=NORM.INV(9,11,2.1) |

[removed] |
=NORM.S.DIST(9,TRUE) |

[removed] |
=NORM.DIST(9,11.2,2.1,TRUE) |

[removed] |
=NORM.S.INV(9) |

Flag this Question

**Question 4****1 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?

[removed] |
=NORM.DIST(12.2, 11, 1, TRUE) – NORM.DIST(9.5, 11, 1, TRUE) |

[removed] |
=(NORM.DIST(12.2, 11, 1, TRUE) – NORM.DIST(9.5, 11, 1, TRUE)) -1 |

[removed] |
=1- (NORM.DIST(12.2, 11, 1, TRUE) – NORM.DIST(9.5, 11, 1, TRUE)) |

[removed] |
=NORM.DIST(9.5, 11, 1, TRUE) – NORM.DIST(12.2, 11, 1, TRUE) |

Flag this Question

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

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

[removed] |
=NORM.S.INV(0.1) |

[removed] |
=1-NORM.INV(0.1) |

[removed] |
=NORM.S.INV(0.9) |

[removed] |
=NORM.DIST(0.1) |

Flag this Question

**Question 6****1 pts****How could one compute the probability between 1.5 standard deviations above and below the mean in Excel?**

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

[removed] |
=NORM.S.DIST(1.5, TRUE)-NORM.S.DIST(-1.5,TRUE) |

[removed] |
=1-NORM.S.DIST(1.5, TRUE)+NORM.S.DIST(-1.5,TRUE) |

[removed] |
=ABS(NORM.S.DIST(1.5, TRUE)) |

[removed] |
=1-(NORM.S.DIST(1.5, TRUE)-NORM.DIST(-1.5, TRUE)) |