Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started