Finding Acceleration Using a Table: Small Graphing Question | Homework Help

  • Thread starter Thread starter BayernBlues
  • Start date Start date
  • Tags Tags
    Graphing
Click For Summary
SUMMARY

The discussion focuses on calculating acceleration from a dataset using regression analysis in Excel. The user seeks to determine the slope of the line of best fit for a graph representing displacement versus time squared, with specific values ranging from 7.132 to 9.686 seconds squared. Additionally, the user inquires about adding error bars for the x-axis and the implications of including the origin point (0,0) in the graph. The relevant equation for this analysis is s = 1/2 a * t², where 's' represents displacement and 'a' represents acceleration.

PREREQUISITES
  • Understanding of linear regression analysis
  • Familiarity with Excel graphing tools
  • Knowledge of basic physics equations related to motion
  • Ability to interpret error bars in data visualization
NEXT STEPS
  • Learn how to perform linear regression in Excel
  • Research methods for adding error bars in Excel graphs
  • Study the implications of including intercepts in regression analysis
  • Explore the physics of motion, specifically the relationship between displacement and acceleration
USEFUL FOR

Students in physics or mathematics, educators teaching graphing techniques, and anyone interested in data analysis using Excel for regression analysis.

BayernBlues
Messages
61
Reaction score
0

Homework Statement



I have a question for a graph where I'm basically trying to find the acceleration using a table which has a time squared value starting at 7.132 seconds squared and ending at 9.686 seconds squared. I need to find a regression (I need to find the slope for the line of best fit. This is the graph:

The first problem is the error bars. I got y error bars but when I click on format options for the excel graph, it doesn't show x bars options so how do I add error bars? And my other question is, how/should I add (0,0) to the graph because obviously the displacement is 0 m at 0 seconds but this wasn't conducted in the experiment so wouldn't it skew the slope of the line of best fit?

Homework Equations



Here's the relation:
y= mx + b --------> s(displacement) = 1/2 a(acceleration)*t^2(seconds squared)

and here's the table:

-(s)--------(t^2)
113.76-----7.132
123.56-----7.896
133.3------8.588
143.66-----9.321
152.9------9.686


The Attempt at a Solution



http://img106.imageshack.us/img106/2456/nettles1qb0.png
 
Last edited by a moderator:
Physics news on Phys.org
Should I set 7.132 to be the x intercept?
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
33K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 2 ·
Replies
2
Views
11K
  • · Replies 1 ·
Replies
1
Views
5K
  • · Replies 1 ·
Replies
1
Views
5K
Replies
9
Views
29K
  • · Replies 4 ·
Replies
4
Views
4K