Question: Using VBA Sub program to calculate the standard deviation of M&Ms in each bag. Red Green Blue Orange Brown Yellow Others 5 7 4 3
Using VBA Sub program to calculate the standard deviation of M&Ms in each bag.
| Red | Green | Blue | Orange | Brown | Yellow | Others |
| 5 | 7 | 4 | 3 | 1 | 1 | 0 |
| 4 | 8 | 3 | 2 | 1 | 3 | 0 |
| 2 | 6 | 4 | 1 | 6 | 3 | 0 |
| 1 | 4 | 3 | 6 | 3 | 4 | 0 |
| 1 | 4 | 1 | 4 | 7 | 5 | 0 |
| 2 | 6 | 1 | 3 | 4 | 4 | 0 |
| 2 | 6 | 2 | 5 | 5 | 1 | 0 |
| 2 | 4 | 4 | 3 | 2 | 5 | 0 |
| 3 | 8 | 6 | 4 | 1 | 1 | 0 |
| 3 | 4 | 5 | 7 | 2 | 1 | 0 |
| 2 | 5 | 1 | 2 | 4 | 6 | 0 |
| 3 | 5 | 5 | 4 | 3 | 2 | 0 |
| 1 | 4 | 2 | 5 | 6 | 5 | 0 |
| 3 | 6 | 3 | 0 | 7 | 2 | 0 |
| 3 | 8 | 1 | 3 | 1 | 5 | 0 |
| 1 | 5 | 6 | 6 | 3 | 1 | 0 |
| 2 | 5 | 2 | 4 | 3 | 6 | 0 |
| 3 | 4 | 5 | 5 | 1 | 4 | 0 |
| 8 | 5 | 3 | 3 | 1 | 1 | 0 |
| 0 | 5 | 1 | 8 | 5 | 2 | 0 |
(1 row = 1 bag)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help