multiple regression problem

profilesama6820
_data_set_1.xls

Sheet1

Company Earn/Share %Growth Net Income Revenue%Growth Revenue Annual%Return StkPrice %Change Stock Price Est P/E Ratio Category Tech Industrial Retail Health Financial Telecomm Other
4Kids Entertainment 312 32.2 100 77.9 201 -8 19.06 7 0 0 0 0 0 0 1
RF Micro Devices 179 55.9 129 325.1 164 78 70.13 106 6 0 0 0 0 0 1 0
Siebel Systems 190 166.2 117 1171.2 173 406 150.13 245 1 1 0 0 0 0 0 0
Network Appliance 115 73.8 80 579.3 224 432 76.94 286 1 1 0 0 0 0 0 0
Source Information Mgmt. 112 11.2 125 90.9 74 -26 10.00 14 2 0 1 0 0 0 0 0
Salton 161 83.4 71 795.9 90 38 32.31 6 7 0 0 0 0 0 0 1
Zomax 88 30.3 115 238.4 92 35 17.13 18 1 1 0 0 0 0 0 0
12 Technologies 96 58.4 71 750.5 138 711 119.56 363 1 1 0 0 0 0 0 0
Diamond Tech Partners 300 16.2 50 136.2 133 472 92.00 102 1 1 0 0 0 0 0 0
Stericycle 760 15.3 72 186.7 44 73 24.94 29 7 0 0 0 0 0 0 1
Cree 107 23.7 49 90.0 179 208 90.38 116 1 1 0 0 0 0 0 0
Jakks Pacific 81 26.6 132 209.5 54 -11 17.38 10 7 0 0 0 0 0 0 1
Mercury Interactive 79 43.7 55 237.6 196 330 93.38 176 1 1 0 0 0 0 0 0
Meritage 218 21.4 221 382.9 8 -1 12.81 3 2 0 1 0 0 0 0 0
Hain Celestial Group 75 12.3 68 287.2 97 12 28.38 25 7 0 0 0 0 0 0 1
VISX 100 74.2 69 266.8 68 -76 24.31 35 4 0 0 0 1 0 0 0
THQ 100 28.1 91 293.9 36 -10 17.19 14 1 1 0 0 0 0 0 0
Extended Stay America 280 51.6 110 442.2 -16 30 13.00 18 7 0 0 0 0 0 0 1
Hauppauge Digital 80 3.0 56 70.6 88 -60 5.81 27 1 1 0 0 0 0 0 0
Concord Camera 180 13.3 33 153.3 156 475 21.38 30 2 0 1 0 0 0 0 0
MCSI 52 12.2 134 738.8 47 44 26.81 17 1 1 0 0 0 0 0 0
Qlogic 81 54.0 41 203.2 175 81 74.38 92 1 1 0 0 0 0 0 0
Advance Paradigm 78 20.6 94 1968.4 30 -25 25.81 20 4 0 0 0 1 0 0 0
Forest Laboratories 105 115.9 48 959.9 70 114 113.06 52 4 0 0 0 1 0 0 0
Calpine 43 109.4 66 937.2 140 273 71.50 64 7 0 0 0 0 0 0 1
Chico's Fas 117 18.8 37 175.3 96 137 30.50 18 3 0 0 1 0 0 0 0
Citrix Systems 61 116.9 89 457.4 37 -42 14.75 31 1 1 0 0 0 0 0 0
Minimed 71 28.1 44 252.1 107 60 127.00 108 4 0 0 0 1 0 0 0
Enron 133 1109.0 46 45625.0 49 85 77.63 51 7 0 0 0 0 0 0 1
Polymedica 48 15.1 69 156.9 70 99 38.56 26 4 0 0 0 1 0 0 0
Sunrise Assisted Living 124 17.1 76 280.6 -19 -44 16.31 35 4 0 0 0 1 0 0 0
Pinnacle Entertainment 88 61.8 78 697.5 10 10 20.31 19 7 0 0 0 0 0 0 1
Sapient 34 37.9 79 319.4 105 348 120.81 147 1 1 0 0 0 0 0 0
American Eagle Outfitters 157 91.0 39 864.7 61 -61 14.88 9 3 0 0 1 0 0 0 0
Sandisk 65 260.1 45 403.6 103 64 61.50 80 1 1 0 0 0 0 0 0
Actrade Int'l 66 10.0 120 392.2 14 61 20.94 14 5 0 0 0 0 1 0 0
Arguss Holdings 52 8.7 107 229.9 33 0 17.00 21 6 0 0 0 0 0 1 0
Insight Enterprises 51 39.1 56 1647.5 88 61 45.00 34 1 1 0 0 0 0 0 0
Schuler Homes 130 30.6 64 571.6 1 -13 6.25 4 2 0 1 0 0 0 0 0
Express Scripts 46 158.1 84 4864.5 44 -3 65.88 26 4 0 0 0 1 0 0 0
Metro One Telecomm 78 2.4 70 93.4 19 -27 9.88 24 6 0 0 0 0 0 1 0
Metris 57 163.5 76 1020.4 32 9 28.06 14 5 0 0 0 0 1 0 0
K-Swiss 403 28.4 43 268.4 27 -43 17.44 12 3 0 0 1 0 0 0 0
Dendrite Int'l 71 26.5 43 192.0 82 17 28.75 43 1 1 0 0 0 0 0 0
Armor Holdings 111 14.5 57 179.7 7 49 14.88 17 2 0 1 0 0 0 0 0
Hot Topic 68 15.3 56 185.5 42 124 32.81 17 3 0 0 1 0 0 0 0
Meade Instruments 76 12.2 37 132.5 92 86 17.75 23 2 0 1 0 0 0 0 0
Dell Computers 51 1757.0 47 27008.0 89 -1 39.56 58 1 1 0 0 0 0 0 0
Anaren Microwave 55 8.5 37 53.7 146 350 72.00 101 6 0 0 0 0 0 1 0
Qualcomm 73 667.6 32 3620.9 111 62 61.94 60 6 0 0 0 0 0 1 0
Converse Technology 49 191.0 49 933.0 75 119 81.81 75 6 0 0 0 0 0 1 0
Xeta Technologies 46 5.6 55 69.0 70 -5 10.38 20 6 0 0 0 0 0 1 0
Federal-Mogul 98 231.5 62 6489.0 -35 -81 9.13 3 2 0 1 0 0 0 0 0
Rent-Way 41 38.6 118 534.4 26 42 29.63 17 3 0 0 1 0 0 0 0
Sanmina 38 116.1 57 2364.2 75 179 91.94 68 1 1 0 0 0 0 0 0
AVT 100 17.5 46 126.3 17 -68 4.94 18 6 0 0 0 0 0 1 0
Oshkosh Truck 88 40.7 33 1218.1 58 -10 32.88 12 2 0 1 0 0 0 0 0
Universal Amer. Financial 154 14.8 35 205.1 29 -23 3.75 5 0 0 0 0 1 0 0
EMC 36 1120.2 44 7054.9 151 161 80.50 109 1 1 0 0 0 0 0 0
Profit Recovery Group 45 30.3 73 367.0 22 -74 8.69 16 7 0 0 0 0 0 0 1
Complete Bus. Solutions 58 24.6 63 462.3 12 -33 12.63 25 1 1 0 0 0 0 0 0
Republic Security 69 28.3 64 244.7 -15 -58 4.06 9 5 0 0 0 0 1 0 0
SDL 43 36.8 33 221.6 291 859 345.31 309 1 1 0 0 0 0 0 0
Scansource 36 10.9 72 442.0 39 73 41.00 17 7 0 0 0 0 0 0 1
Concord EFS 38 142.1 76 917.6 31 21 27.50 33 5 0 0 0 0 1 0 0
Triquint Semiconductor 40 32.6 43 189.2 103 272 36.06 100 1 1 0 0 0 0 0 0
Trans World Entertainment 62 79.0 51 1381.2 28 -3 12.06 7 3 0 0 1 0 0 0 0
Abercrombie & Fitch 85 150.8 47 1060.4 10 -62 15.94 9 3 0 0 1 0 0 0 0
Biogen 60 324.8 37 881.1 56 -24 55.50 38 4 0 0 0 1 0 0 0
Advent Software 39 21.7 42 117.4 94 136 52.63 79 1 1 0 0 0 0 0 0
AHL Services 62 16.2 61 863.9 -27 -69 8.00 6 7 0 0 0 0 0 0 1
Summa Industries 42 7.3 63 122.2 28 -21 11.50 8 2 0 1 0 0 0 0 0
Micrel 41 43.5 41 221.9 90 164 50.00 83 1 1 0 0 0 0 0 0
Solectron 33 421.6 53 11613.7 68 22 39.56 57 1 1 0 0 0 0 0 0
Startek 43 16.5 47 209.9 50 47 42.69 32 7 0 0 0 0 0 0 1
Reliant Energy 46 1825.3 60 16894.0 18 25 34.63 13 7 0 0 0 0 0 0 1
Dycom Industries 43 57.0 35 710.4 96 46 44.88 27 6 0 0 0 0 0 1 0
Greater Bay Bancorp 45 39.2 46 214.0 47 58 53.63 16 5 0 0 0 0 1 0 0
SCP Pool 68 26.1 30 620.4 55 74 26.75 15 7 0 0 0 0 0 0 1
Standard Pacific 94 68.1 42 1218.6 1 -4 12.63 5 2 0 1 0 0 0 0 0
MTR Gaming Group 49 8.6 40 127.7 55 132 6.25 8 7 0 0 0 0 0 0 1
Americredit 44 99.8 58 464.2 18 32 20.19 10 5 0 0 0 0 1 0 0
Kellstrom Industries 35 14.0 125 326.4 -34 -46 5.69 7 2 0 1 0 0 0 0 0
Advanced Digital 32 71.7 52 248.9 58 31 13.75 24 1 1 0 0 0 0 0 0
Catellus Development 122 115.2 34 169.7 -6 13 17.81 12 2 0 1 0 0 0 0 0
Autonation 73 265.1 48 20779.3 -34 -54 7.06 7 3 0 0 1 0 0 0 0
Colorado Medtech 52 6.6 54 76.1 2 -68 6.25 11 4 0 0 0 1 0 0 0
New Horizons 48 8.3 40 123.4 37 19 22.75 7 0 0 0 0 0 0 1
Kaneb Services 86 63.5 37 554.8 3 -4 4.31 7 0 0 0 0 0 0 1
Pacific Sunwear of Calif. 55 37.1 41 467.9 25 -43 14.63 14 3 0 0 1 0 0 0 0
Renal Care Group 42 55.4 60 544.1 10 -7 22.00 19 4 0 0 0 1 0 0 0
Impath 38 9.3 56 99.0 26 156 64.75 43 4 0 0 0 1 0 0 0
KV Pharmaceutical 53 24.3 36 146.0 34 98 29.69 21 4 0 0 0 1 0 0 0
CDW Computer Services 38 113.7 40 2885.8 68 111 51.00 41 7 0 0 0 0 0 0 1
Tellabs 48 577.0 38 2489.3 35 1 62.00 46 6 0 0 0 0 0 1 0
Resmed 43 20.7 34 109.2 64 105 30.63 31 4 0 0 0 1 0 0 0
Capital One Financial 35 412.4 43 4477.6 53 21 55.56 23 5 0 0 0 0 1 0 0
Nova 35 87.3 68 1524.9 3 -61 10.75 19 5 0 0 0 0 1 0 0
Guidant 56 437.3 33 2436.1 33 0 59.56 33 4 0 0 0 1 0 0 0
Doral Financial 40 75.9 52 375.5 14 -22 12.69 7 5 0 0 0 0 1 0 0
&A
Page &P

Sheet2

&A
Page &P

Sheet3

&A
Page &P

Sheet4

&A
Page &P

Sheet5

&A
Page &P

Sheet6

&A
Page &P

Sheet7

&A
Page &P

Sheet8

&A
Page &P

Sheet9

&A
Page &P

Sheet10

&A
Page &P

Sheet11

&A
Page &P

Sheet12

&A
Page &P

Sheet13

&A
Page &P

Sheet14

&A
Page &P

Sheet15

&A
Page &P

Sheet16

&A
Page &P