Nursing

PrePostTestScores-StatisticsFunctions.xlsx

Sheet1

Pre-Test & Post-Test Scores for a Class
	Pre-Test x1	Post-Test x2
	80	83
	81	90
	80	84
	80	67
	82	85
	82	84
	63	80
	80	66
	83	85
	79	81
	79	84
	64	69
	81	83
	82	84
	60	66
	83	82
	84	84
	67	83
	83	95
	79	80
	79	68
	85	70
Totals	1716	1753
Use "countif" command to find # of scores less than 70%
Calculate mean scores
Calculate variance for each set of scores
Calculate standard deviation
Calculate a one-tail ttest P(T<=t) 1 tail
Calculate a two-tail ttest P(T<=t) 2 tail
Calculate correlation
Print a graph for scores of each column
Add the appropriate labels to the graph