math lab

MATH225_W6_ConfidenceIntrvals.xlsx

EMPIRICAL RULE

Empirical Rule using standard error for CONFIDENCE INTERVAL
Enter the data in the blue highlighted area and the results will show in the yellow highlighted area.
				ANSWER		Note: standard error- Standard deviation of sample means or the standard deviation of sample proportions
			Empirical Rule	68-95-99.7		Note: standard error is not standard deviation.
	mean	0.43		Lower number	Upper number
			68%	0.39	0.47
	Standard error	0.04	95%	0.35	0.51
			99.70%	0.31	0.55

Enter the data in the blue highlighted area and the results will show in the yellow highlighted area.
Enter values starting from B5 cell
	Data
	18.4	Mean	17.3185
	16.1	Sample Standard Deviation	3.4029
	19.5
	16.5
	12.5
	17.2
	13.8
	17.9
	19.1
	9.8
	23.8
	18.7
	19.1
	15
	19.2
	17
	11.5
	15.7
	22.5
	23.7
	19.9
	17.6
	15
	17.8
	20.7
	14.2
	15.4

Enter the data in the blue highlighted area and the results will show in the yellow highlighted area.
t or z Confidence Interval for µ				Confidence Interval for p Proportions
	Confidence Level	0.950	Enter decimal		Confidence Level	0.950	Enter decimal
	n	100			n	100
	Mean	3.9600			Number of Successes	23
	StDev	4.7500
	pop stdev	yes	Enter yes if population stdev known
			Enter No if population stdev is unknown
	SE	0.475000			Sample Proportion	0.230000
	z	1.960			SE	0.042083
	Margin of Error	0.931000			z	1.960
	Lower Limit	3.029000			Margin of Error	0.082483
	Upper Limit	4.891000			Lower Limit	0.147517
					Upper Limit	0.312483

Enter the data in the blue highlighted area and the results will show in the yellow highlighted area.
Minimum Sample Size μ for population mean				Minimum Sample Size p for Proportion
	Confidence Level	0.950	Enter decimal		Confidence Level	0.900	Enter decimal
	StDev	10			Sample Proportion	0.63	If sample proportion unknown enter 0.5
	Error	3			Error	0.01	Write percentage as decimal
	z-Value	1.960			z-Value	1.645
	Minimum Sample Size	43			Minimum Sample Size	6308