The manufacturing company in Problem 2.44 also produces electric insulators. If the insulators break when in use, a short circuit is likely to occur. To test the strength of the insulators, destructive testing in high-powered labs is carried out to determine how much force is required to break the insulators. Force is measured by observing how many pounds must be applied to the insulator before it breaks. The force measurements, collected from a sample of 30 insulators, are stored in Force .

Force

1522

1550

1592

1610

1634

1652

1656

1662

1662

1680

1688

1696

1728

1734

1734

1736

1744

1752

1756

1762

1764

1774

1784

1788

1810

1810

1820

1866

1866

1870

a. Construct a percentage histogram and a percentage polygon.

b. Construct a cumulative percentage polygon.

c. What can you conclude about the strengths of the insulators if the company requires a force measurement of at least 1,500 pounds before the insulator breaks?

PLEASE CONSTRUCT THE HISTOGRAM YOURSELF OR SHOW ME THE STEPS I'M NOT FAMILIAR WITH EXCEL SO HELP IS REQUIRED ILL PAY AND REWARD FULL CREDIT PROMISE.