qnt/561

Sheet2

Column1		Column2
Mean	45	Mean	641.375
Standard Error	8.6602540378	Standard Error	179.9774725487
Median	45	Median	580
Mode	ERROR:#N/A	Mode	ERROR:#N/A
Standard Deviation	24.4948974278	Standard Deviation	509.0531651999
Sample Variance	600	Sample Variance	259135.125
Kurtosis	-1.2	Kurtosis	-0.8057905953
Skewness	-8.45884209238214E-17	Skewness	0.4164055846
Range	70	Range	1428
Minimum	10	Minimum	24
Maximum	80	Maximum	1452
Sum	360	Sum	5131
Count	8	Count	8
Confidence Level(95.0%)	20.4782467228	Confidence Level(95.0%)	425.5790963289

Sheet3

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Column 1	8	360	45	600
Column 2	8	5131	641.375	259135.125
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	1422652.5625	1	1422652.5625	10.9546412908	0.0051608778	4.6001099367
Within Groups	1818145.875	14	129867.5625
Total	3240798.4375	15

Sheet1

	Public Image(x)	Sales(y)	xy	x^2	y^2
	10	24	240	100	576
	20	68	1360	400	4624
	30	378	11340	900	142884
	40	552	22080	1600	304704
	50	608	30400	2500	369664
	60	1218	73080	3600	1483524
	70	831	58170	4900	690561
	80	1452	116160	6400	2108304
	360	5131	312830	20400	5104841					Correlation	0.9387126074
Std dev	24.4948974278	509.0531651999
n	7
ERROR:#NAME?

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Public Image(x)

Sales(y)

xy

x^2

10

24

240

100

20

68

1360

400

30

378

11340

900

40

552

22080

1600

50

608

30400

2500

60

1218

73080

3600

70

831

58170

4900

80

1452

116160

6400