Question

The following is a set of data from a sample of n=5. 8 -4 -8 8 2 Please use a statistical application (data Analysis Toolpak for Windows, StatPlus for Mac Excel, or StatCrunch) to compute the descriptive statistics in a and b. (If you don't know what I'm talking about, go to Module 1 Content - Read/View - Tutorials) a. Compute the mean, median, and mode. b. Compute the range, sample variance, and sample standard deviation c. Compute the coefficient of variation d. Compute the Z scores. Are there any outliers? e. Describe the shape of the data set 1. Submit into the Dropbox the spreadsheet that you used to compute the descriptive statistics for a and b. a. The mean is (Type an integer or a decimal. Do not round) Determine the median The median is (Type an integer or a decimal. Do not round)

Answer 1

Hi,

Below is answers :

		zscores
	8	1.0625
	-4	-0.8125
	-8	-1.4375
	8	1.0625
	2	0.125
Mean	1.20
Median	2.00
Mode	8
Range	16
Sample Variance	51.2
Standard deviation	6.4
Coefficeint of variation	533%
Zscores
shape of data set	Positive (right skewed)

Below is excel formulas for each answers. The first cell starts from A1.

	Given Data	zscores
	8	=(B2-$B$8)/STDEV.P($B$2:$B$6)
	-4	=(B3-$B$8)/STDEV.P($B$2:$B$6)
	-8	=(B4-$B$8)/STDEV.P($B$2:$B$6)
	8	=(B5-$B$8)/STDEV.P($B$2:$B$6)
	2	=(B6-$B$8)/STDEV.P($B$2:$B$6)
Mean	=AVERAGE(B2:B6)
Median	=MEDIAN(B2:B6)
Mode	=MODE(B2:B6)
Range	=MAX(B2:B6)-MIN(B2:B6)
Sample Variance	=VAR(B2:B6)
Standard deviation	=STDEVP(B2:B6)
Coefficeint of variation	=B13/B8

Below is the barchart to determine shape of data set which indicate data is positive (right skewed) since values on right side are positive from middle while left side we have one positive one negative so no proper direction left side.

Chart Title