Question: Use Excels capability (()) to create a frequency distribution using 5 bins. $320 $2,950 $562 $288 $495 $1,250 $585 $930 $475 $192 $428 $1,575 $443
Use Excels capability (()) to create a frequency distribution using 5 bins.
| $320 | $2,950 | $562 | $288 | $495 |
| $1,250 | $585 | $930 | $475 | |
| $192 | $428 | $1,575 | $443 | |
| $721 | $563 | $406 | $675 | |
| $320 | $451 | $673 | $449 | |
| $700 | $560 | $780 | $1,550 | |
| $420 | $956 | $405 | $945 | |
| $440 | $333 | $444 | $785 | |
| $368 | $536 | $961 | $913 | |
| $918 | $625 | $570 | $879 |
Problem 3 is worth 30%:
5% - used (), and () correctly
5% - created the correct Bin size
10% - created the correct numbers for each bin
10% - correctly used () as array function
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
