Creating S-N Diagrams with Excel

  • Thread starter Thread starter fmunene
  • Start date Start date
  • Tags Tags
    Diagrams
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
1 reply · 14K views
fmunene
Messages
1
Reaction score
0
Hello, I need help
with plotting a S-N curve using Excel given the data below
I know how to plot using the scatter function in excel but i am confused on what values should go on the y-axis...i.e S...it is clear that the number of cycles will obviously go onto the x-axis...Please explain what excel equations I need to get . Any help will be highly appreciated.

"Average Diameter [in]","Moment [in-lb]","Number Cycles [N]"
0.25, 122.718463, 20000
0.2513, 101.2723101, 40000
0.2496, 91.59776729, 100000
0.2503, 76.97548741, 200000
0.2506, 61.80207912, 500000
0.2513, 52.1941906, 1000000
0.251, 46.5738686, 2000000
0.2513, 38.95088851, 5000000
0.2503, 33.09945959, 10000000
0.2506, 30.90103956, 100000000
 
Physics news on Phys.org