Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Least squares approximation

have a poll, and I want to calculate "betas" with the last square aproxximation formula.

 

I have "Y" (satisfaction), and some other variables as "X"

 

I have a column with all values of "Y", and one column with all answers of the "X" other answers of the questios of the poll:

 

Table Name = Registers

Y    X    QuestionCode

3    3           x1

2    3           x2

4    2           x1

      3           x3

      4           x2

 

 

"X" and QuestionCode columns are bigger than "Y"column.

I want to acces with a filter on QuestionCode, and multiply Y * (all) x1

 

That is because of the part of the formula that is SUMMATORY ( X*Y ).

That is differrent of SUMMATORY (X) * SUMMATORY (Y)

 

What I have been trying is SUMX(Registers[Y] * CALCULATE(Registers, Registers[X]) and filtering on the inform sheet with the QuestionCodes, but when I filter it, it turns "zero"

1 Reply