Charts and Graphs Data Set Provided

ED572_Assignment_3_Data_Sets2.xlsx

Directions

	Unit 3 Assignment 2: 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 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.
Student	Gender	Female	Male
1	Female	17	9
2	Female
3	Female
4	Female
5	Female
6	Female
7	Female
8	Female
9	Female
10	Female
11	Female
12	Female
13	Female
14	Female
15	Female
16	Female
17	Female
18	Male
19	Male
20	Male
21	Male
22	Male
23	Male
24	Male
25	Male
26	Male

	Directions 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.
	IQ	GPA
	118	2.32
	112	2.34
	103	2.8
	108	3.53
	123	3.84
	110	1.84
	110	3.7
	110	3.9
	103	2.03
	99	2.28
	100	1.91
	108	2.66
	124	3.9
	120	2.56
	102	2.92
	125	3.9
	131	3.28
	105	2.02
	121	1.18
	124	2.84
	110	1.66
	97	2.38
	108	2.8
	105	1.61
	114	1.77
	119	3.98
	115	3.49
	117	2.09
	124	2.38
	102	2.34
	121	3.17
	128	3.35
	97	1.24
	122	2.56
	125	3.9
	124	3.13
	135	4
	121	2.31
	125	3.49
	95	1.14
	132	3.42
	101	1.77
	113	2.57
	114	2.27
	121	2.43
	123	2.56
	113	2.84
	132	2.22
	111	2.11

	Directions Use the Total Points below to create a Histogram of the total points. Use a Bin width of 10 with the first class 51 – 60.
	Total Points
	97
	108
	81
	115
	75
	108
	78
	114
	120
	97
	109
	96
	123
	95
	108
	118
	120
	97
	80
	112
	92
	96
	98
	105
	92
	103
	124
	90
	84
	96
	113
	107
	88
	87
	113
	106
	117
	93
	118
	65
	124
	92
	97
	111
	106
	92
	100
	99
	77
	98
	122
	84
	109
	103
	92
	103
	88
	98
	121
	109
	51
	108
	122
	90
	99
	109
	98
	111
	90
	101
	106
	93
	107
	109
	107
	96
	123
	118
	111
	79
	88
	98
	106
	118
	123
	84
	105
	104
	122
	116
	109
	107
	97
	70
	120
	94
	98
	99
	104
	98
	66
	52
	108
	70
	113

	Directions Use the Total Points by Gender data to create numerical descriptive statistics for the females and the males.
	Males	Females
	80	98
	96	103
	112	108
	123	122
	118	120
	111	124
	79	97
	92	84
	88	94
	98	78
	106	114
	65	98
	118	109
	96	90
	98	108
	123	120
	124	81
	52	97
	75	103
	92	109

ED572 Unit 3: Descriptive Statistics and Presentation of Data
Directions: Your instructor will review your Excel spreadsheet with the assumption that you have earned the full 150 points. If there are any deductions from that score, a comment will be provided to let you know what you did and what you should do better or to correct any errors. You are urged to use this rubric as a guide when you are completing your Unit 3 Assignment.
Criteria	Expectation		Possible Points
Use of Excel	• The correct Excel procedure was used to describe the data. • The correct graph was produced or the correct numerical description was produced.		100
Presentation of Descriptive Statistic	• Graphs are labeled appropriately. • Graphs are clear and present the data accurately		50
Instructor Comments:
		Total	150	Points