How Can I Determine the Best Fit Line for My Driving Data?

  • Thread starter Thread starter Physics197
  • Start date Start date
Click For Summary
SUMMARY

The discussion focuses on determining the best fit line for driving data using linear regression techniques. The user has collected driving log data and successfully plotted it in Excel, applying a trendline to visualize the relationship between distance and time. To identify the best fit line, the user seeks advice on mathematical tests, specifically regarding the comparison of slope and y-intercept values. The conversation emphasizes the importance of evaluating the linear approximation's effectiveness in predicting travel time for a specific distance, such as 412 km to St. John.

PREREQUISITES
  • Understanding of linear regression concepts
  • Familiarity with Excel's charting and trendline features
  • Basic knowledge of slope and y-intercept in linear equations
  • Ability to interpret graphical data representations
NEXT STEPS
  • Learn how to perform linear regression analysis in Excel
  • Research statistical methods for evaluating the goodness of fit, such as R-squared
  • Explore the use of residual plots to assess the appropriateness of the linear model
  • Investigate how to apply linear models for predictive analytics in travel time estimation
USEFUL FOR

This discussion is beneficial for students in statistics, data analysts, and anyone interested in applying linear regression techniques to real-world data, particularly in transportation and travel time analysis.

Physics197
Messages
70
Reaction score
0

Homework Statement



On a recent trip to Moncton my driving log reads as:
1 hr, 0km
20min, 10km
1hr, 80km
20min, 0km
1hr, 110km
40min, 70km
15min, 10km
a) Plot the distance as a function of time and determine a good linear approximation. (d=at+b)

b) Since there are a number of straight lines that might fit this data, what mathematical test could you think of to determine what might be the "best fit" to the data.

c. Enter into excel and fit a 'treadline' to data.

d. How does the treadline match with my answer.

e) Could you use the approximation to estimate the time required to travel to st John (412km). Explain.

Homework Equations





The Attempt at a Solution


Already have it graphed and given a line of best fit.

Really need help with B

Entered into excel already

Should I compare the slope and y-intercept?

are there toomany variables to include that would make this approximation useless? or could you use it.

Thanks, Just need a steer in the right direction.
 
Physics news on Phys.org
Please, need help
 

Similar threads

Derivation of Line of Best Fit
  • · Replies 9 ·
Replies
9
Views
4K
Undergrad How do I determine if improving a fit is significant?
  • · Replies 13 ·
Replies
13
Views
2K
Formula that will give the equation for the line of best fit of a data set
  • · Replies 3 ·
Replies
3
Views
2K
Undergrad How Can I Accurately Fit an Airy Distribution Over Noisy Resonance Data?
  • · Replies 9 ·
Replies
9
Views
4K
MATLAB Matlab: Data from Best Fit Lines into Legend
  • · Replies 4 ·
Replies
4
Views
5K
Undergrad How does excel calculate the best fit line?
  • · Replies 5 ·
Replies
5
Views
8K
Maple How can I fit a sigmoid line to data points using Excel or Maple?
  • · Replies 1 ·
Replies
1
Views
3K
Intensity for Young’s Double Slit Interference
  • · Replies 9 ·
Replies
9
Views
8K
Coefficient of Determination( Line Best Fit Error)
  • · Replies 3 ·
Replies
3
Views
4K
Undergrad Determining the best fit regression for a set of data
  • · Replies 6 ·
Replies
6
Views
9K