How do I get the output summary?

R

ri

Hi,
I want to get the uncertainty of the graph.
Withdata, I made a graph like y = ax +b, and got the apoloximately slope and
the intercept.
Since these values are apoloximately, I want to get the uncertainties of the
values.
Thanks,
 
M

Mike Middleton

ri -

To obtain standard errors (i.e., measures of uncertainty of the estimates),
use the array-entered LINEST worksheet function (see Help), or use the
Regression tool of the Analysis ToolPak (which can be installed from your
Excel/Office installation CD).

- Mike
www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error / Uncertainty in Excel 2
Create a chart from a table in word thats dynamic 0
Uncertainty 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Incone & Expenses Statement 0
Use text descriptors as Y axis units 1
Dumb question alert! What program to use? 0
Tagging Misspell Words with "##" 0

Top