Standard Error

M

Maral

I'm trying to calculate the t-stat but keep getting stumped. I used LINEST
to get the mean and standard error, but can't seem to replicate how Excel is
calculating the standard error. Does anyone have the equation that Excel is
using?
 
B

Bernard Liengme

Excel uses the same formulas that you would find in a standard statistics
book.
Give us some data (no more than 10 (x,y) pairs) and indicate which standard
error you are concerned with (slope, Intercept, etc)

best wishes
 

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

Integrating information from Word to Excel (not mail merge) 1
Creating Forms 0
Basic Statistics 4
Microsoft 365 Activations, Users or Devices? 0
Images are pixelated when saving to PDF 0
back transforming log10 standard error 1
Deriving P-Value through LINEST Function 1
Adding Cost Field to Appointment 0

Top