Sliding on the surface of a rough sphere (ploting theta in excel)

Click For Summary
SUMMARY

The discussion focuses on plotting the angle theta as a block slides off a rough sphere, specifically with a coefficient of kinetic friction (Mu k) ranging from 0.0 to 0.5 in increments of 0.05. The parameters provided include a sphere radius (r) of 1.5 meters and an initial velocity (V_0) of 3 m/s. The equation used to calculate the velocity (V) incorporates both the kinetic friction and the angle theta, which is essential for generating the plot in Microsoft Excel. The user seeks assistance in implementing this equation in Excel to visualize the relationship between Mu k and theta.

PREREQUISITES
  • Understanding of basic physics concepts, specifically dynamics involving friction.
  • Familiarity with the equation of motion and how to manipulate algebraic expressions.
  • Basic proficiency in Microsoft Excel, including creating graphs and using formulas.
  • Knowledge of exponential functions and trigonometric identities relevant to the problem.
NEXT STEPS
  • Learn how to use Excel's graphing features to plot equations and data points.
  • Research how to implement complex equations in Excel using cell references and functions.
  • Study the relationship between kinetic friction and motion to better understand the physics involved.
  • Explore Excel's data analysis tools for handling incremental data sets effectively.
USEFUL FOR

Students in physics or engineering courses, educators teaching dynamics, and anyone interested in applying Excel for scientific data visualization and analysis.

chart2006
Messages
11
Reaction score
0

Homework Statement



I have determined the solution to my problem however now the problem asks me to plot theta as the block flies off the sphere when Mu k ranges from 0.0 to 0.5 in increments of 0.05 I don't know a great deal about working with Microsoft Excel. Well I do just not enough to know how to plot theta from this equation. The information is as follows.

r = 1.5m

[tex]V_0 = 3m/s[/tex]

[tex]\mu[/tex] = 0.0 thru 0.5 in increments of 0.05

[tex]\theta = ?[/tex]

Homework Equations



[tex] V^2 = \frac{(2 - 4 \mu^2) (e^{2\mu\theta} - cos(\theta)) - 6 \mu sin(\theta)} {(1 + 4\mu^2)}+ V_0^2 e^{2\mu\theta}[/tex]

[tex] V = rgcos(\theta)[/tex]


The Attempt at a Solution



As for the attempt at the solution as I said I've already established the solution now I only need to plug into excel in order to solve for theta. Any help would be appreciated.
 
Last edited:
Physics news on Phys.org
You need to state the entire problem. I don't think anyone understands what you're trying to do.
 

Similar threads

Replies
4
Views
3K
Replies
6
Views
4K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
Replies
19
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 29 ·
Replies
29
Views
4K
Replies
10
Views
4K