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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!