| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weighted Regression
Is it possible to perform weighted least-squares regression in Excel? If so,
how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weighted Regression
Found this on Google:
http://books.google.com/books?id=rDs...lt#PP A376,M1 So, it will take a bit of work, but you're in luck! See info. he http://books.google.com/books?id=-7o...lt #PPA111,M1 All files are listed under 'Menu': http://www3.wabash.edu/econometrics/...Book/index.htm I learned a TON from this resource!! You will too!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: Is it possible to perform weighted least-squares regression in Excel? If so, how? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weighted Regression
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. "ryguy7272" wrote: Found this on Google: http://books.google.com/books?id=rDs...lt#PP A376,M1 So, it will take a bit of work, but you're in luck! See info. he http://books.google.com/books?id=-7o...lt #PPA111,M1 All files are listed under 'Menu': http://www3.wabash.edu/econometrics/...Book/index.htm I learned a TON from this resource!! You will too!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: Is it possible to perform weighted least-squares regression in Excel? If so, how? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weighted Regression
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: 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. "ryguy7272" wrote: Found this on Google: http://books.google.com/books?id=rDs...lt#PP A376,M1 So, it will take a bit of work, but you're in luck! See info. he http://books.google.com/books?id=-7o...lt #PPA111,M1 All files are listed under 'Menu': http://www3.wabash.edu/econometrics/...Book/index.htm I learned a TON from this resource!! You will too!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: Is it possible to perform weighted least-squares regression in Excel? If so, how? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weighted Regression
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). "ryguy7272" wrote: 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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: 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. "ryguy7272" wrote: Found this on Google: http://books.google.com/books?id=rDs...lt#PP A376,M1 So, it will take a bit of work, but you're in luck! See info. he http://books.google.com/books?id=-7o...lt #PPA111,M1 All files are listed under 'Menu': http://www3.wabash.edu/econometrics/...Book/index.htm I learned a TON from this resource!! You will too!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: Is it possible to perform weighted least-squares regression in Excel? If so, how? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weighted Regression
Check it out; go he
http://www3.wabash.edu/econometrics/...Book/index.htm On the right hand side of the screen you will see 'Menu' and all the chapters under that. What you want may be in chapter 7: http://www3.wabash.edu/econometrics/...Book/chap7.htm Maybe chapter 5: http://www3.wabash.edu/econometrics/...Book/chap5.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: 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). "ryguy7272" wrote: 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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: 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. "ryguy7272" wrote: Found this on Google: http://books.google.com/books?id=rDs...lt#PP A376,M1 So, it will take a bit of work, but you're in luck! See info. he http://books.google.com/books?id=-7o...lt #PPA111,M1 All files are listed under 'Menu': http://www3.wabash.edu/econometrics/...Book/index.htm I learned a TON from this resource!! You will too!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Engineer001" wrote: Is it possible to perform weighted least-squares regression in Excel? If so, how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted mean | Excel Discussion (Misc queries) | |||
| The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
| Weighted Avg | Excel Discussion (Misc queries) | |||
| Weighted values when one is zero | Excel Discussion (Misc queries) | |||
| Weighted Average | New Users to Excel | |||
Linear Mode
