jeffch1970
New Member
- Joined
- May 13, 2009
- Messages
- 5
I am conducting some regression analysis and I'm not certain if my numbers are spot on or way off. I'm using the Data Analysis Toolpak, Regression function in Excel 2010. The Significance F statistic shows up as #NUM! and several of my t Stats come up as 65535, which I've been told indicates something is wrong, possibly. I cannot attach the workbook, but here is the data set. I am trying to ascertain if my Independent Variables (V1-v12) have anything to do with my Dependent Variable. I'm not sure if I'm even stating this correctly. Any help would be appreciated.
DATA SET (copied form Notepad)
MACHINE,INDEX,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10,v11,v12
A,42.42,57.58,21.21,40.91,-6.06,37.88,36.36,-4.55,48.48,9.09,36.36,24.24,42.42
B,25.55,64.63,29.48,26.20,-8.95,26.20,37.12,-20.96,56.33,9.39,-8.73,34.72,34.72
C,25.35,54.93,28.17,30.99,-11.27,33.80,42.25,-15.49,61.97,21.13,11.27,35.21,38.03
D,7.04,56.34,4.23,14.08,-22.54,0.00,23.94,-54.93,40.85,-14.08,11.27,35.21,25.35
E,4.88,56.34,4.23,14.08,-22.54,0.00,23.94,-54.93,40.85,-14.08,11.27,35.21,25.35
F,0.00,57.14,14.29,28.57,-50.00,35.71,-7.14,-14.29,35.71,0.00,7.14,7.14,28.57
G,-8.33,62.50,2.08,0.00,0.00,-6.25,8.33,-25.00,31.25,-35.42,10.42,50.00,22.92
H,-11.00,62.50,2.08,0.00,0.00,-6.25,8.33,-25.00,31.25,-35.42,10.42,50.00,22.92
I,-14.29,80.95,-4.76,-14.29,-66.67,4.76,-19.05,-19.05,9.52,-14.29,-9.52,-38.10,-33.33
J,7.39,55.32,12.25,17.84,-15.32,24.68,28.65,-26.85,38.92,-10.45,4.68,27.39,24.32
DATA SET (copied form Notepad)
MACHINE,INDEX,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10,v11,v12
A,42.42,57.58,21.21,40.91,-6.06,37.88,36.36,-4.55,48.48,9.09,36.36,24.24,42.42
B,25.55,64.63,29.48,26.20,-8.95,26.20,37.12,-20.96,56.33,9.39,-8.73,34.72,34.72
C,25.35,54.93,28.17,30.99,-11.27,33.80,42.25,-15.49,61.97,21.13,11.27,35.21,38.03
D,7.04,56.34,4.23,14.08,-22.54,0.00,23.94,-54.93,40.85,-14.08,11.27,35.21,25.35
E,4.88,56.34,4.23,14.08,-22.54,0.00,23.94,-54.93,40.85,-14.08,11.27,35.21,25.35
F,0.00,57.14,14.29,28.57,-50.00,35.71,-7.14,-14.29,35.71,0.00,7.14,7.14,28.57
G,-8.33,62.50,2.08,0.00,0.00,-6.25,8.33,-25.00,31.25,-35.42,10.42,50.00,22.92
H,-11.00,62.50,2.08,0.00,0.00,-6.25,8.33,-25.00,31.25,-35.42,10.42,50.00,22.92
I,-14.29,80.95,-4.76,-14.29,-66.67,4.76,-19.05,-19.05,9.52,-14.29,-9.52,-38.10,-33.33
J,7.39,55.32,12.25,17.84,-15.32,24.68,28.65,-26.85,38.92,-10.45,4.68,27.39,24.32