Fix My Regression Analysis

[mkmahoney393]

New to doing regression in excel. Not sure, what I'm doing wrong, but this isn't the right output:

[TABLE="width: 799"]
<tbody>[TR]
[TD="colspan: 2"]SUMMARY OUTPUT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]Regression Statistics[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Multiple R[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R Square[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adjusted R Square[/TD]
[TD="align: right"]65535[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Standard Error[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Observations[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ANOVA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]df[/TD]
[TD]SS[/TD]
[TD]MS[/TD]
[TD]F[/TD]
[TD]Significance F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Regression[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14999.66[/TD]
[TD="align: right"]$2,999.9[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: center"]#NUM![/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Residual[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]14999.66[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Coefficients[/TD]
[TD]Standard Error[/TD]
[TD]t Stat[/TD]
[TD]P-value[/TD]
[TD]Lower 95%[/TD]
[TD]Upper 95%[/TD]
[TD]Lower 95.0%[/TD]
[TD]Upper 95.0%[/TD]
[/TR]
[TR]
[TD]Intercept[/TD]
[TD="align: right"]14703.16175[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]14703.16[/TD]
[TD="align: right"]14703.16[/TD]
[TD="align: right"]14703.16[/TD]
[TD="align: right"]14703.16[/TD]
[/TR]
[TR]
[TD]Hogs, Market-Inventory[/TD]
[TD="align: right"]-0.000246884[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]-0.00025[/TD]
[TD="align: right"]-0.00025[/TD]
[TD="align: right"]-0.00025[/TD]
[TD="align: right"]-0.00025[/TD]
[/TR]
[TR]
[TD]Chickens, Broilers-Placements[/TD]
[TD="align: right"]6.04599E-06[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]6.05E-06[/TD]
[TD="align: right"]6.05E-06[/TD]
[TD="align: right"]6.05E-06[/TD]
[TD="align: right"]6.05E-06[/TD]
[/TR]
[TR]
[TD]Meal Export Sales[/TD]
[TD="align: right"]0.000932057[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]0.000932[/TD]
[TD="align: right"]0.000932[/TD]
[TD="align: right"]0.000932[/TD]
[TD="align: right"]0.000932[/TD]
[/TR]
[TR]
[TD]Meal Production[/TD]
[TD="align: right"]-0.000480621[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]-0.00048[/TD]
[TD="align: right"]-0.00048[/TD]
[TD="align: right"]-0.00048[/TD]
[TD="align: right"]-0.00048[/TD]
[/TR]
[TR]
[TD]Meal Stocks[/TD]
[TD="align: right"]-0.008672978[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$65,535.0[/TD]
[TD="align: center"]#NUM![/TD]
[TD="align: right"]-0.00867[/TD]
[TD="align: right"]-0.00867[/TD]
[TD="align: right"]-0.00867[/TD]
[TD="align: right"]-0.00867[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col span="4"></colgroup>[/TABLE]



Here's my data. Right column is Y. Any thoughts?

[TABLE="width: 872"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Hogs, Market-Inventory[/TD]
[TD]Chickens, Broilers-Placements[/TD]
[TD]Meal Export Sales[/TD]
[TD]Meal Production[/TD]
[TD]Meal Stocks[/TD]
[TD]Closing Meal Price[/TD]
[/TR]
[TR]
[TD="align: right"]Sep-16[/TD]
[TD="align: right"]64,835,000[/TD]
[TD="align: right"]709,183,000[/TD]
[TD="align: right"]861,496[/TD]
[TD="align: right"]3,042,315[/TD]
[TD="align: right"]233,715[/TD]
[TD="align: right"]$297.9[/TD]
[/TR]
[TR]
[TD="align: right"]Jun-16[/TD]
[TD="align: right"]62,442,000[/TD]
[TD="align: right"]720,614,000[/TD]
[TD="align: right"]899,231[/TD]
[TD="align: right"]3,411,099[/TD]
[TD="align: right"]281,038[/TD]
[TD="align: right"]$405.3[/TD]
[/TR]
[TR]
[TD="align: right"]Mar-16[/TD]
[TD="align: right"]62,144,000[/TD]
[TD="align: right"]709,660,000[/TD]
[TD="align: right"]1,085,061[/TD]
[TD="align: right"]3,677,248[/TD]
[TD="align: right"]302,672[/TD]
[TD="align: right"]$270.3[/TD]
[/TR]
[TR]
[TD="align: right"]Dec-15[/TD]
[TD="align: right"]62,917,000[/TD]
[TD="align: right"]704,070,000[/TD]
[TD="align: right"]1,015,392[/TD]
[TD="align: right"]3,669,213[/TD]
[TD="align: right"]270,421[/TD]
[TD="align: right"]$264.3[/TD]
[/TR]
[TR]
[TD="align: right"]Sep-15[/TD]
[TD="align: right"]63,200,000[/TD]
[TD="align: right"]697,142,000[/TD]
[TD="align: right"]548,044[/TD]
[TD="align: right"]2,974,159[/TD]
[TD="align: right"]240,755[/TD]
[TD="align: right"]$308.3[/TD]
[/TR]
[TR]
[TD="align: right"]Jun-15[/TD]
[TD="align: right"]61,240,000[/TD]
[TD="align: right"]721,960,000[/TD]
[TD="align: right"]685,544[/TD]
[TD="align: right"]3,380,130[/TD]
[TD="align: right"]300,225[/TD]
[TD="align: right"]$359.5[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]

 

[Oaktree]

I think the "Hogs, Market - Inventory" values are causing the regression model to go haywire. Eyeballing it, the closing meal price jumps around quite a bit on relatively flat values of "Hogs, Market - Inventory", so Excel isn't sure how to use that field to determine the curve.

Running the regression model without that field appears to work just fine.