Question: d. For each question, we'll have the worksheet calculated the standard deviation. i) In cell A6, type 'Standard Deviation.' ii) The standard deviation of a

 d. For each question, we'll have the worksheet calculated the standard

d. For each question, we'll have the worksheet calculated the standard deviation. i) In cell A6, type 'Standard Deviation.' ii) The standard deviation of a binomial can be calculated using this formula: JR?! [1 It] In B6, use cell references, arithmetic operations, and a function to have Excel calculate the standard deviation. The answer rounded to four decimals is 0.8485, but Excel will display the value with as many decimals as you want. Record the answer rounded to 5 decimals. e. Change the values in B2 and B3 to n= 10 and TIS=O.40. Ifyou are doing this correctly, you should only be changing the values in B2 and B3. The answers in B5 and B6 should update automatically. Rounded to one decimal, the mean is 4.0 and the standard deviation is 1.5. Record the new mean and standard deviation rounded to 5 decimals

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!