Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored 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