Analyzing Real Data
Columns A and B below, give the Exam results of students in a class. The blank spaces are because some students missed an exam.						A Grade >= 85%	StatTrek
						B Grade >=75%
			Topic	Question	Answer
Exam 1	Exam 2	(Missing values calculated using Regression Equation)		Find the relevant statistic or parameter below for Exam 1 and Exam 2	Exam 1	Exam 2
75.2	69.7		Centrality	Mean
71.3	67.7			Median
62.4	83.5			Mode
73.3		63.9
63.8	61.2		Variation	Range
75.8	76.7			Variance
81.9	58.7			Standard Deviation
61.4	49.8
63.9	59.5		Distribution	Draw 2 Box-Plots to compare the scores for Exam 1 and Exam 2.
94.4	88.3			Compare the Box-Plots by speaking about measures of center and spread.
75.6	75.0
90.1	86.2		Probability	What is the probability of getting at least a C grade, where C = 70% in Exams 1 and 2
85.1	80.3
87.0	92.7		Hypothesis Test	Proportion of As is less than 10% in Exams 1 and 2.
60.2	58.5		(Test the Claim that... )	Mean score is greater than 70% in Exams 1 and 2.
71.2
45.6	26.3
56.0	49.2		Correlation & Regression	Draw a scatterplot of Exam 1 v Exam 2
42.0	59.3			Find the equation of the regression line
	32.7			Use the equation to find the missing values from the original dataset
18.8
42.4
88.0	61.5
89.3	76.0
77.8
75.5	28.9
64.5	57.2
57.9	52.3
79.6	61.1
89.2	83.0
83.0	82.7
52.7
61.8	56.7
61.7	49.1
61.8	28.0
81.2	85.7
75.0	75.0
81.7	84.1
77.2	72.8
	43.0
69.9	76.7
82.0	50.5
83.7	76.7
87.8	73.0