Weighted Regression


E

Engineer001

Is it possible to perform weighted least-squares regression in Excel? If so,
how?
 
Ad

Advertisements

E

Engineer001

Thanks. I'll look for the book at my local bookstore.

Just thought there might be a quick and easy method without using matrix
equations ... this is not EXCEL's forte -- especially with large matrices.
 
R

ryguy7272

Wait, what do you mean? You can download those sample files from that link.
Match the results to your data (I can't see your data). Should take < 1/2
hour; probably much less because you sound like you know exactly what you are
talking about. You just need to see a sample in Excel, right. There are
tons on sample files on that site.

Good luck,
Ryan---
 
E

Engineer001

Ryan,
Thanks but I don't see any sample spreadsheets on the three links you
posted. The books merely define what weighted regression is ... I already
know that. Just looking to see how to set it up using the LINEST() function
(if that is even possible).
 
Ad

Advertisements


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

Top