Use excel

A consumer agency ran a test on different brands of concrete to determine which brand of concrete is the strongest and most dependable. The different brands of concrete were used to make 10 solid cylinders each. A concrete compression machine determined the amount of force in pounds that the cylinders could hold. Record a macro that gives the average, minimum, and maximum values for each brand of concrete, then makes a bar graph that includes the average, min, and max for each brand of concrete, and labels the legend appropriately. Concrete A 500 539 520 600 586 610 548 504 577 487 Concrete B 549 570 538 557 562 554 573 564 556 563 Concrete C 539 603 578 639 613 624 607 655 523 567 Concrete D 502 610 603 608 612 597 605 598 609 604 Concrete E 540 542 539 541 538 539 543 541 539 542