Cumulative percentage polygon and histogram in excel


The manufacturing company as well manufactures electric insulators. If insulators break when in use, a short circuit is likely to take place. To test the strength of insulators, destructive testing in high powered labs iscarried out to find out how much force is needed to break the insulators. Force is measured by observing how many pounds should be applied to insulator before it breaks. The strengths of 30 insulators are as follows:

1870

1728

1656

1610

1634

1784

1522

1696

1592

1662

1866

1764

1734

1662

1734

1774

1550

1756

1762

1866

1820

1744

1788

1688

1810

1752

1680

1810

1652

1736

a. Develop a frequency distribution and percentage distribution.

b. Develop histogram and percentage polygon.

c. Plot cumulative percentage polygon.

d. What can you conclude about strength of insulators if the company needs a force measurement of at least 1500 pounds before breaking.

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Cumulative percentage polygon and histogram in excel
Reference No:- TGS018205

Expected delivery within 24 Hours