Assignment : Descriptive Statistics and Presentation of Data

As you create your descriptive statistics you may place your output on a separate sheet in this spreadsheet.

1. Use the Student Gender tab create a Pie Chart and a Bar Chart to show the numbers of males and females in the class.

2. Use the IQ-GPA tab to create a Scatter Plot. Edit the X axis to have a minimum of 80 rather than 0. Insert the Trendline and Regression Equation.

3. Use the Total Points tab to create a Histogram of the total points. Use a Bin width of 10 with the first class 51 - 60.

4. Use the Total Points by Gender tab to create numerical descriptive statistics for the females and the males.

5. Check the grading rubric often as you complete each tab.

6. Save your work often while completing the Assignment.

Directions

1. Use the Student Gender data below to create a Pie Chart and a Bar Chart to show the numbers of males and females in the class.

2. Use the IQ-GPA data to create a Scatter Plot. Edit the X axis to have a minimum of 80 rather than 0. Insert the Trendline and Regression Equation.

3. Use the Total Points by Gender data to create numerical descriptive statistics for the females and the males.

Attachment:- Assignment-Data Sets.rar