Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Basic Statistics

Authors: Charles Henry Brase, Corrinne Pellillo Brase

6th Edition

978-1133525097, 1133525091, 1111827028, 978-1133110316, 1133110312, 978-1111827021

Students also viewed these Mathematics questions

Question

=+a) Which will be smoother, a 50-day or a 200-day moving average?

Answered: 1 week ago