Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 6th 17, 07:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2017
Posts: 1
Default Linear weighted regression

Hi Jerry,

If I want to do a linear regression with 1/x weighting, how do I calculate the weights for the X data and Y data?

Thanks,

Baylye

  #2   Report Post  
Old March 6th 17, 08:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 533
Default Linear weighted regression

boxallbk wrote:

Hi Jerry,

If I want to do a linear regression with 1/x weighting, how do I
calculate the weights for the X data and Y data?

Thanks,

Baylye


You start by not replying to a post that's ***THIRTEEN*** ****ING YEARS OLD!

--
- I'm not brave. I'm just too tired and hungry and angry to care anymore.
- Perhaps they are not mutually exclusive. Perhaps bravery is simply apathy
with delusions of grandeur.
  #3   Report Post  
Old January 10th 21, 05:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2021
Posts: 1
Default Linear weighted regression

Il giorno lunedì 6 marzo 2017 alle 20:52:04 UTC+1 Auric__ ha scritto:
boxallbk wrote:

Hi Jerry,

If I want to do a linear regression with 1/x weighting, how do I
calculate the weights for the X data and Y data?

Thanks,

Baylye

You start by not replying to a post that's ***THIRTEEN*** ****ING YEARS OLD!

--
- I'm not brave. I'm just too tired and hungry and angry to care anymore.
- Perhaps they are not mutually exclusive. Perhaps bravery is simply apathy
with delusions of grandeur.


Dear Auric,

I am very sorry for your unfriendly answer to Baylye.

Weighted linear regression is still a widely used approach in analytical chemistry and maybe in other fields.

No matter if the post is 13, or 50, or 100 years old!

Baylye's question was very interesting and an answer to it would benefit other interested people.

Best regards,
Gianfranco
  #4   Report Post  
Old January 10th 21, 08:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 533
Default Linear weighted regression

Jambo Frigerio wrote:

Il giorno lunedì 6 marzo 2017 alle 20:52:04 UTC+1 Auric__ ha scritto:
boxallbk wrote:

Hi Jerry,

If I want to do a linear regression with 1/x weighting, how do I
calculate the weights for the X data and Y data?

Thanks,

Baylye

You start by not replying to a post that's ***THIRTEEN*** ****ING YEARS
OLD!


****ing Google Groupies. You obviously have no idea what Usenet is or how it
works. In the future, when replying, remove everything you quote after the
"-- ", because that's my signature and has nothing to do with the body of
the post.

I am very sorry for your unfriendly answer to Baylye.


I'm not.

Weighted linear regression is still a widely used approach in analytical
chemistry and maybe in other fields.

No matter if the post is 13, or 50, or 100 years old!

Baylye's question was very interesting and an answer to it would benefit
other interested people.


He should have started a new thread, and referenced the previous thread.
Bringing an old thread back from the dead -- like you have done -- is not
The Right Thing[tm].

Google Groups is connected to Usenet, which predates GG by a couple DECADES.
The original users eventually came up with rules of etiquette ("netiquette")
that help keep the peace. GG users seem to be deliberately ignorant.

--
In my country, "lost in the wilderness" is the #2 leading cause of death.
Chipmunk attack is #4.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weighted Regression Engineer001 Excel Worksheet Functions 5 April 1st 09 10:45 PM
Linear Regression al boccia Excel Worksheet Functions 8 December 12th 08 10:40 PM
Weighted Linear Regression Dave_AD Excel Programming 1 July 28th 08 07:24 AM
The multiple regression tool - linear or non-linear regression? Statistical interest Excel Discussion (Misc queries) 2 February 7th 08 12:01 AM
linear regression Jason - MR Excel Worksheet Functions 1 November 28th 05 08:51 PM


All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017