Mikes Bikes Information

	A	B	C	D	E	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1
2							18,000				Simple linear Regression				x	y		Simple linear Regression				x	y
3							20,616								800	18000						700	18000
4							23,020				SSxy	SSxx	b	a	y=a+bx	x=(y-a)/b		SSxy	SSxx	b	a	y=a+bx	x=(y-a)/b
5	Name	SHV 1	SHV 2	SHV 3	SHV 4		20,332				12209090	368150	33.16335733	371	26,901	531.5895083		14492	134	108.1492537	-53,131	22,573	657.7139571
6	Hugh Campbell	19.63	32.05	23.82	32.61		16,370	5,141			average							average
7	hughgent@gmail.com	zero changes	only producing mtn bikes	producing one of each	Better management of one product each		22,328	5,547			742.5	24,995	605797.459	18085.65574	16575998.37			683.00	20,735	14166608	466533.6667	430916312
8	Drijan						20,594	4,336		n	Sum						n	Sum
9	Drijanvlahna205@MSN.com						141,260	15024		3	1485	49,989	36953645	1103225	1292927873		3	2,049.00	62,204	42499824	1399601	1292748936
10	Julie	$18.51	$48.96								X	Y	X*Y	X^2	Y^2			X	Y	X*Y	X^2	Y^2
11	Julie.fon@gmail.com		2 Bikes only, moutain and youth, went up to 2030, Mountaintop Cycles was just over 100 (from what I recall!)								725	29,657	21501325	525625	879537649			674.00	19,466	13120084	454276	378925156
12											760	20,332	15452320	577600	413390224			690.00	20,842	14380980	476100	434388964
13	b_roseborough@hotmail.com												0	0	0			685.00	21,896	14998760	469225	479434816
14	Hilda	18.24	35.6										0	0	0
15	.hildatoews@hotmail.com		Mtn and Youth bikes - Mountaintop Cycles SHV was $86.26			$12,600,000			$12,600,000	$1,309,269			0	0	0
16	Taimoor					$13,915,800			$13,915,800	$1,446,945			0	0	0
17	taimoors@hotmail.com					$16,114,000			$16,114,000	$1,606,267			0	0	0
18						$15,452,320			$15,452,320	$1,184,689			0	0	0
19						$12,441,200.00	$11,567,250.00		$24,008,450	$4,072,012			0	0	0
20	Cost of Road bikes					$16,187,800.00	$12,480,750.00		$28,668,550	$4,335,694			0	0	0
21	development	1000000				$16,475,200.00	$9,756,000.00		$26,231,200	$7,391,815			0	0	0
22	capacity buying	520000		520000		$103,186,320	$33,804,000.00		$136,990,320	$21,346,691			0	0	0
23	efficiency	875000		875000					Retail sales total	Profit after tax total			0	0	0
24	quality	1000000		1000000									0	0	0
25	advertising	250000											0	0	0
26	PR	1200000											0	0	0
27		4845000		2395000									0	0	0
28													0	0	0
29	Road bikes advertising effectiveness					Road bikes advertising effectiveness							0	0	0
30	total number	23000				total number	21000						0	0	0
31	TV	0.1	2300		0	TV	0.1	2100		0			0	0	0
32	Internet	0.4	9200	0.31	2852	Internet	0.4	8400		0			0	0	0
33	Magazines	0.6	13800	0.25	3450	Magazines	0.6	12600		0			0	0	0
34													0	0	0
35	Mountain Bikes advertising effectiveness					Mountain Bikes advertising effectiveness							0	0	0
36	total number	45000				total number	160000						0	0	0
37	TV	0.4	18000		0	TV	0.4	64000		0			0	0	0
38	Internet	0.3	13500	0.35	4725	Internet	0.3	48000	0.325	15600			0	0	0
39	Magazines	0.5	22500	0.15	3375	Magazines	0.5	80000	0.25	20000			0	0	0
40													0	0	0
41	Kid bikes advertising effectiveness					Kid bikes advertising effectiveness							0	0	0
42	total number	160000				total number	160000						0	0	0
43	TV	0.7	112000	0.4	44800	TV	0.7	112000	0.4	44800			0	0	0
44	Internet	0.2	32000		0	Internet	0.2	32000		0			0	0	0
45	Magazines	0.2	32000		0	Magazines	0.2	32000		0			0	0	0
46													0	0	0
47													0	0	0
48													0	0	0
49													0	0	0
50													0	0	0
51													0	0	0
52													0	0	0
53													0	0	0
54													0	0	0
55													0	0	0
56													0	0	0
57													0	0	0
58													0	0	0
59													0	0	0
60													0	0	0
61													0	0	0
62													0	0	0
63													0	0	0
64													0	0	0
65													0	0	0
66													0	0	0
67													0	0	0
68													0	0	0
69													0	0	0
70													0	0	0
71													0	0	0
72															0
73															0
74															0
75															0
76															0
77															0
78															0
79															0
80															0
81															0
82															0
83															0
84															0
85															0
86															0
87															0
88															0
89
90
91
92
93
94
95
96
97
98
99
100