s) For the questions below, you must write out exactly what you would need to type into Excel (starting with the equal sign) in order to have Excel perform the correct calculation. Be mindful of...
For the questions below, you must write out exactly what you sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl would need to type into Excel(starting with the equal a) (4 points) What formula would need to be typed in cell B2 in order to have Excel perform the correct calculation? Your formula needs to reference cell A2 so that it could be dragged down to the entire input-output table. f(x) =...
For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. If it is appropriate to use the binomial distribution, use the formula =binom.dist(number_s,trials,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trials, trials is the total number of trials, probability is the probability for a single trial expressed as a decimal, and cumulative should be set as false. This will report the...