View Single Post
Old 02-19-2010, 10:11 PM   #47 (permalink)
RobertSmalls
Left Lane Ecodriver
 
RobertSmalls's Avatar
 
Join Date: Aug 2008
Location: Buffalo, NY, USA
Posts: 2,257

Prius C - '12 Toyota Prius C
Thanks: 79
Thanked 287 Times in 200 Posts
You can get Excel to fit a parabola to anything, but the Rē (the correlation coefficient) tells you how tightly your curve fits the data. 0 is no correlation, and 1 is a perfect correlation. In Excel, go to Add Trendline - Options - Display R-squared on chart.

Since the template was hand-drawn, it probably is a parabola, so I expect an Rē around 0.99. It would be interesting to know if the Honda's tail is also a perfect parabola, or only a looser approximation of one.


Actually, you'll need a second foam template for the sides. The first picture in post #41 shows one template in the vertical plane, and the same template on a different scale in the ground plane.

You want your tail to have the same height and angle where it takes over from the Honda tail, so you'll need to scale your equation so the y and dy/dx of the template match those of the Honda, at the point where the Honda ends. Or just eyeball it as I did in the second picture in post #41.

Last edited by RobertSmalls; 02-19-2010 at 10:32 PM.. Reason: in response to your edit
  Reply With Quote