Board Thread:Game Discussion/@comment-31526827-20191027014218/@comment-28176349-20191101225837

I replicated ESA-Car-6Os linear regression work in Excel.

Copy from the Cars (Base Stats) page. Go to the edit/source mode and copy the  table.

Paste it into Excel. It will require some cleanup from old "New Car" comments and blank lines. Do Text to Columns, delimited, with the | delimiter. Again some cleanup of "ALT=SS" fields. I moved the metric columns aside.

Run the (Data Analysis) regression in Excel. Input Y Range is the PR column. Input X Range is the remaining 4 performance columns.

The resulting coefficients:

- Intercept: 27.2

- Top Speed (mph): 0.148

- Accel: -9.57

- Braking (ft): -0.0831

- Grip: 27.91

So for the Tesla figures above, 51.684.

Yeah, the negative coefficients for Acceleration and (to a lesser extent) Braking are "interesting". I haven't done a deep dive into the statistics, but "Standard Error" is 5.007. So is Excel saying +/-5 PR?