Hybrid Car Sales, the Recession and Gas Prices

Recently,  I was contacted about a quick calculation I did back in July of 2007.  I simply calculated the <a href="http://hybridreview.blogspot.com/2007/07/correlation-between-hybrid-cars-and-gas.html">correlation between gas prices and hybrid car sales</a> up to that point.  Not surprisingly, the correlation was very high (0.855) and very significant.<br /><br />The student who contacted me used the data I had collected, then updated the data to show that the relationship was still very strong. <br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC5GLyFEe_nFYSHi3OHeUBI2vstQzN_L_4VXNWK_ZEBBRlTvtGkZRR3PB878ViRjyrBV3xYprMhjx1lvrat-gdMNIMdo8_8oT1eFYZtoJ_jLWPcdJ4bkrZvxDURk0IN1ffQyUHN1GseN4/s1600-h/Fit+Plot+for+Number+of+Hybrids+Sold+vs+Gas+Prices.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC5GLyFEe_nFYSHi3OHeUBI2vstQzN_L_4VXNWK_ZEBBRlTvtGkZRR3PB878ViRjyrBV3xYprMhjx1lvrat-gdMNIMdo8_8oT1eFYZtoJ_jLWPcdJ4bkrZvxDURk0IN1ffQyUHN1GseN4/s320/Fit+Plot+for+Number+of+Hybrids+Sold+vs+Gas+Prices.JPG" /></a></div>I decided to see if the correlation still stands up myself.  It had dropped (R= 0.75, p-value < 0.0001), but it was still strong.  (See the first figure to see how strongly the number of hybrids sold is related to gas price that month).  More on that drop later.<br /><br />For those of you who are already bored with the statistics, skip down to the conclusions. <br /><br /><b>A More Complicated Model </b><br />I also wanted to add some other things to the mix.  So, I decided to run some more complicated regression models using hybrid car sales as the outcome.  I tried modeling gas price, month, time, and the number of models available.  (Time is just a counter for each month starting in January of 2004, when I started tracking hybrid car sales).  I quickly came to the conclusion that hybrid car sales were related to all of these things, but unfortunately, they were also highly correlated to each other.<br /><br />Gas prices were highly correlated with time (R = 0.55, p-value < 0.001) and number of models sold (R = 0.43, p-value = 0.0004).  And the number of hybrid car models sold is highly correlated with time (R = 0.96, p-value < 0.0001).  <br /><br />So I decided that I could (and should) drop something and quickly tossed out the number of models sold.  As long as I have the other variables, number of models would just muddy the waters (confound).<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6NltzgGztDQl_WbTbFOeTVvWXbjEUHqpCXJSpKZZ8bF4UxNMzqtQNvG9YL7zJNjMnp6Rz-K_NNE9vL47ayeAoU8NfQ8PhyphenhyphenNEoPwjDur-08PgzLJD246FFwlF4k2_blusX0o0O90hndTs/s1600-h/Fit+Diagnositcs+for+Full+Model.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6NltzgGztDQl_WbTbFOeTVvWXbjEUHqpCXJSpKZZ8bF4UxNMzqtQNvG9YL7zJNjMnp6Rz-K_NNE9vL47ayeAoU8NfQ8PhyphenhyphenNEoPwjDur-08PgzLJD246FFwlF4k2_blusX0o0O90hndTs/s320/Fit+Diagnositcs+for+Full+Model.JPG" /></a>I ran a regression model using dummy variables for the months, time, and gas prices.  I got a good fit (R-squared - 0.72, adjusted R-squared of 0.65).  But the residual plots looked off.  The residual plot showed why the correlation had dropped from when I ran this back in July, 2007, but it didn't explain why.  <br /><br />It almost looked like there was a curve to the residual plot, so I tried modeling with different time variables, but that didn't seem to fit the bill.  I tried a few other interactions, but nothing seemed to make the problem go away.<br /><br />I was almost resigned to just leaving it at that, but then I decided to try one more thing.  I decided to model the recession, seeing as how that seems to have had a big affect on car sales.  So I created a dummy variable indicating a break point in May of 2008.  It seemed to do a good job, so I threw it into the whole model and voila, it worked pretty well (See the table of Parameter Estimates and the second figure).<br /><br /><br /><table border="1" bordercolor="#000000" cellpadding="7" cellspacing="1" class="Table" frame="box" rules="groups" summary="Procedure Reg: Parameter Estimates"><thead><tr> <th class="c b Header" colspan="6" scope="colgroup">Parameter Estimates</th></tr><tr> <th class="l b Header" scope="col">Variable</th> <th class="r b Header" scope="col">DF</th> <th class="r b Header" scope="col">Parameter<br />Estimate</th> <th class="r b Header" scope="col">Standard<br />Error</th> <th class="r b Header" scope="col">t Value</th> <th class="r b Header" scope="col">Pr > |t|</th></tr></thead> <tbody><tr> <th class="l RowHeader" scope="row">Intercept</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-4469.28975</td> <td class="r Data">2416.66010</td> <td class="r Data" nowrap="nowrap">-1.85</td> <td class="r Data">0.0703</td></tr><tr> <th class="l RowHeader" scope="row">Gas_Price</th> <th class="r Data">1</th> <td class="r Data">56.88336</td> <td class="r Data">10.86820</td> <td class="r Data">5.23</td> <td class="r Data"><.0001</td></tr><tr> <th class="l RowHeader" scope="row">Recession</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-13179</td> <td class="r Data">1663.59432</td> <td class="r Data" nowrap="nowrap">-7.92</td> <td class="r Data"><.0001</td></tr><tr> <th class="l RowHeader" scope="row">time</th> <th class="r Data">1</th> <td class="r Data">398.61143</td> <td class="r Data">43.60902</td> <td class="r Data">9.14</td> <td class="r Data"><.0001</td></tr><tr> <th class="l RowHeader" scope="row">January</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-3876.86879</td> <td class="r Data">2181.03947</td> <td class="r Data" nowrap="nowrap">-1.78</td> <td class="r Data">0.0816</td></tr><tr> <th class="l RowHeader" scope="row">February</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-3206.59171</td> <td class="r Data">2179.80633</td> <td class="r Data" nowrap="nowrap">-1.47</td> <td class="r Data">0.1475</td></tr><tr> <th class="l RowHeader" scope="row">March</th> <th class="r Data">1</th> <td class="r Data">2635.57235</td> <td class="r Data">2187.10717</td> <td class="r Data">1.21</td> <td class="r Data">0.2339</td></tr><tr> <th class="l RowHeader" scope="row">April</th> <th class="r Data">1</th> <td class="r Data">1694.27245</td> <td class="r Data">2209.67133</td> <td class="r Data">0.77</td> <td class="r Data">0.4468</td></tr><tr> <th class="l RowHeader" scope="row">May</th> <th class="r Data">1</th> <td class="r Data">4994.91892</td> <td class="r Data">2281.48836</td> <td class="r Data">2.19</td> <td class="r Data">0.0333</td></tr><tr> <th class="l RowHeader" scope="row">June</th> <th class="r Data">1</th> <td class="r Data">476.40455</td> <td class="r Data">2430.98600</td> <td class="r Data">0.20</td> <td class="r Data">0.8454</td></tr><tr> <th class="l RowHeader" scope="row">July</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-16.45925</td> <td class="r Data">2425.43771</td> <td class="r Data" nowrap="nowrap">-0.01</td> <td class="r Data">0.9946</td></tr><tr> <th class="l RowHeader" scope="row">August</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-160.91587</td> <td class="r Data">2391.17318</td> <td class="r Data" nowrap="nowrap">-0.07</td> <td class="r Data">0.9466</td></tr><tr> <th class="l RowHeader" scope="row">September</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-3606.45695</td> <td class="r Data">2378.10359</td> <td class="r Data" nowrap="nowrap">-1.52</td> <td class="r Data">0.1357</td></tr><tr> <th class="l RowHeader" scope="row">October</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-2834.32326</td> <td class="r Data">2316.73403</td> <td class="r Data" nowrap="nowrap">-1.22</td> <td class="r Data">0.2269</td></tr><tr> <th class="l RowHeader" scope="row">November</th> <th class="r Data">1</th> <td class="r Data" nowrap="nowrap">-1697.19686</td> <td class="r Data">2279.80620</td> <td class="r Data" nowrap="nowrap">-0.74</td> <td class="r Data">0.4601</td></tr></tbody></table><br />The overall model fits pretty well (R-squared = 0.87, adjusted R-squared = 0.84).<br /><br /><b>Conclusions</b><br /><br />If you don't mind, I'm going to take some liberties with my conclusions. No good statistician would accept these conclusions (and they shouldn't!), but I'm going to write it this way to spark some thought.<br /><br />If we take the model on it's own, it seems the recession is responsible for sales of hybrid cars dropping over 13,000 units. Also, every time the gas price goes up a penny, 57 more hybrids are sold that month. And, for every month that passes, 400 more hybrid cars are sold than in the previous month (allowing for seasonal differences). The seasonal differences aren't significant.  This is probably due to gas prices being affected by the seasons, so adding the months doesn't really add much to the ability of the model to explain hybrid car sales.  But you can see that March through May are better for sales, while the winter months can be tough.<br /><br />It's a little surprising to me how correlated gas prices are to hybrid car sales.  Yes, I expect there to be a relationship between them, but not as strong a linear one as we see here.  I would have expected other factors to muddy the relationship (lack of inventory early on, number of models being sold, month of sale, federal tax credits, etc...), but it seems that gas prices trump those things.  But the recession has had a huge affect, trumping even gas prices.<br /><br /><b>Where Do We Go From Here</b><br />That leads us to some interesting questions.  Will we see a bounce back when the recession ends?  If gas prices dropped down too much, would car companies turn away from hybrid technology once again (look at the history of hybrid and electric cars, turn of the century, to understand what I'm saying).  Should the government mandate higher gas prices in order to force consumers to consider hybrids on a larger scale?<br /><br />Plug-in hybrids and electric cars are probably going to suffer even worse at the hands of gas prices than hybrids do now.  Given their larger price-tags, most consumers are likely to shy away unless there's some other factor pushing them towards on.  It's hard to know for sure, but these are some of the questions we need to consider going forward.<br /><br /><br /><br /><br />By the way, I ran the models using SAS v9.1.3.

Hybrid Car Sales, the Recession and Gas Prices

Recently,  I was contacted about a quick calculation I did back in July of 2007.  I simply calculated the correlation between gas prices and...

Baca selengkapnya »