I need somebody who really know about statistics

Sheet1

MEGASTAT- DESCRIPTIVE STATISTICS					USE THE RED NOTES
	Add-Ins, Megastat, Descriptive Statistics
	Mean, Sample Variance & Standard Deviation, Minimum, Maximum, Range are default checked.
	CHECK THESE BOXES:
	Runs Plot, Standard Error of the Mean, Confidence Interval, Skewness Kurtosis & Normal Curve Goodness of Fit
				Descriptive statistics
	Solar Sells	Off the Grid			Solar Sells	Off the Grid
	17	7		count	18	18		Count. n sample size
	10	9		mean	11.28	11.83		The measure of location or central value. Average.
	15	12		sample standard deviation	4.76	5.67		The degree of variation within the sample. The squared deviation.
	11	13		sample variance	22.68	32.15		The average sample variability of scores in a distribution. Spread.
	12	4		minimum	3.0	3.0		Minimum
	8	8		maximum	20.0	20.0		Maximum
	6	18		range	17.0	17.0		The difference between the highest & lowest.
	3	15
	20	20		standard error of the mean	1.12	1.34		How much a value may vary from sample to sample.
	12	19
	19	3		confidence interval 95.% lower	9.08	9.21		95% confident the mean lies between upper, lower & half-width.
	13	17		confidence interval 95.% upper	13.48	14.45
	11	4		margin of error	2.20	2.62		Sampling error or the margin of error defined as a half-width of the confidence interval.
	4	6		z	1.96	1.96		z score
	11	14						The degree of asymmetry about the mean. > 1 suspect not normal.
	9	20		skewness	0.12	-0.06		Peakedness of a distribution Pos=Peak. Neg=Flat. 0=Normal. > 1 suspect not normal.
	15	12		kurtosis	-0.42	-1.23		Normalized measure of dispersion of a probability distribution. It is defined as the ratio
	7	12		coefficient of variation (CV)	42.23%	47.91%		of the standard deviation to the mean.
				normal curve GOF
				p-value	.6412	.2787		Outliers
				chi-square(df=2)	0.889	2.556
				E	3.600	3.600		Retain. p= .64 is larger than .05 or .01 Solar Sells is a normal distribution.
				O(-0.84)	4	5		Ho: Parametric (Normal) Distribution.
				O(-0.25)	3	2		H1: Non- Parametric distribution.
				O(+0.25)	5	4
				O(+0.84)	3	2		Retain. p= .27 is larger than .05 or .01 Off the Grid is a normal distribution.
				O(inf.)	3	5		Ho: Parametric (Normal) Distribution.
								H1: Non- Parametric distribution.
								NOTE: Megastat displays small numbers thus: 4.15E-07. Which means .451 with 7 zeros in front:
								.0000000451. When you see this it will also be highlighted in bright yellow. Always REJECT. This
								number is very much smaller than .05 or .01. See How to do a GOF Test in the Assignment
								Instructions Student Material.
Check Box Plot, Dot Plot, Stem and Leaf or Runs Plot for
the graph you want.

Runs Plot

17 10 15 11 12 8 6 3 20 12 19 13 11 4 11 9 15 7

Time

Solar Sells

Runs Plot

7 9 12 13 4 8 18 15 20 19 3 17 4 6 14 20 12 12

Time

Off the Grid

Output

Sheet2

	Solar Sells	Off the Grid
	17	7
	10	9
	15	12
	11	13
	12	4
	8	8
	6	18
	3	15
	20	20
	12	19
	19	3
	13	17
	11	4
	4	6
	11	14
	9	20
	15	12
	7	12