Excel Graphing Equation

  • Thread starter wjp1982
  • Start date
1
0
Hi, I am attempting to find an equation to fit a curve that I have plotted in Excel. I use the trendline function and get an equation but when i place that formula in excel and with the values they are different. I have attached the spreadsheet to show you. The yellow columns are my original data. The blue columns are the numbers i get from the trendline equation. My R-squared value is 1.0 for both too. Any help is beneficial thanks.
 

Attachments

You are most likely suffering from round-off errors. You are using the displayed coefficients in your formula, however, those displayed coefficients are only showing one significant digit.

Increase the number of displayed digits in the trendline label (right click label, select "format data labels", set Number tab, select Scientific, select number of digits - use at least three).

The displayed coefficients will reveal themselves with more precision. Use these coefficients in your formula.
 

Related Threads for: Excel Graphing Equation

  • Posted
Replies
2
Views
7K
  • Posted
Replies
9
Views
3K
  • Posted
Replies
2
Views
5K
  • Posted
Replies
1
Views
2K
  • Posted
Replies
2
Views
27K
Replies
3
Views
90K
  • Posted
Replies
4
Views
757
  • Posted
Replies
3
Views
2K

Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving
Top