Use the MS Excel in constructing the graphs. 41-50. The following table gives the 2002 median annual salaries of various categories of scientists in the United States holding PhDs. Construct a bar graph for these data with " Annual Salary" on the y-axis and "Category of Scientist" on the x-axis. Category of Annual Scientist Salary ($) Biological and Health 70,100 Sciences Chemistry 79,100 Computer and Math 75,000 Sciences Psychology 66,700 Sociology and 63,100 Anthropology51-60. Construct a histogram of the frequency distribution in the given sets of data. Title: Statistics Exam Scores of 2nd Year Nursing Students Class Frequency Interval 95-99 4 90-94 6 85-89 7 80-84 10 75-79 16 70-74 9 65-69 7 60-64 4 55-59 4 50-54 2 45-49 16170. An article appeared in the business section of a newspaper discussing the rate of increases of Puget Power & Light Company. The company was in poor nancial condition and had proposed still another rate increase in 1984 to try to help it get out of the trouble. The issue was particularly sensitive because rate increases had plagued the region recently to pay for huge losses in nuclear p0wer plant construction. Construct an appropriate graph to present the Puget Power rates for 14 years. Year cents per kilowatt hour 1970 1.2. _ 1972 ' 1.26 3 ] I 1974 . 1.44 1976 * 1.624 1978 51.84 _ p 1980 2.4 t r V 1981 29 1982 3.16 , 1983 3.8 1984 4,9