ISC 191, Summer 2014, Garren

Required Excel Homework #1

due Friday, May 23, noon

(A) Select any valid data set(s), containing at least 10 observations, from the textbook to do the following for 6 out of 8 of the following: (Feel free to use the templates from Professor Scott Stevens' website.)

(1) Construct a bar chart.

(2) Construct a Pareto chart.

(3) Construct a pie chart.

(4) Construct a frequency histogram.

(5) Construct a dotplot.

(6) Construct a boxplot.

(7) Construct a scatterplot.

(8) Construct a time-series plot.

-------------------------------------------------------------------------

(B) For each graph in part (A), clearly state the data set you used; e.g., exercise number and page number from the textbook.

(C) Label each of your six graphs.

(D) In your output, use Excel to write your name.

(E) Although you are allowed to receive help from others, list the names of those who helped you and the names of those whom you helped, as well as what type of help was given. If you did not give or receive help, then write "No help."

(F) Send your homework to me using Canvas.

Return to Dr. Garren's home page.