Due date: December 5, 2018

Please submit the finished excel document

Question 1. (4 marks)

On the sheet titled “Student GPA” from the data create a bar chart. With bins of 50, 60, 70, 80, 90.

(Using either the Frequency Function, or Histogram function in data analysis toolpak.)

A. Title the chart Student GPA.

B. For a Histogram remove the gaps between the bars.

Question 2. (6 marks)

On the sheet titled “Gas Usage”, find the following descriptive statistics.

A. Mean

B. Mode

C. Median

D. Variance

E. Standard Deviation

F. Sample Size