Loading
Anterior Previous slide Next slide Próximo

Resíduo de análise parte 2

  • Nota de Estudos
  • Rever Tópicos
    Henock A.
    ET
    Henock A.

    done

    Jahidul I.
    BD
    Jahidul I.

    We now need to calculate two more columns of information. We need to have the predicted yield values from the regression equation and then we need the residuals, the difference between the actual yield and the predicted yield. To calculate the predicted yield we need to substitute the X values into the regression equation. To do this, type the regression equation with an = sign in front of it into cell c43 (in the example) and then fill down. To calculate the residuals type =b3-c3 into cell d3 then fill down. Now we need to graph the residuals and we do this by highlighting the X values and the residual values and following the chart wizard instructions. There appears to be a quadratic (squared) pattern among the residuals. This suggests that the linear model does not capture all the essential features of the data. We therefore need to transform the data, in this case a square transformation is indicated by the residual pattern. We then graph x2 versus Y and calculate another regression line.

    Jahidul I.
    BD
    Jahidul I.

    what is regression equation ?

  • Text Version
Notification

Você recebeu uma nova notificação

Clique aqui para visualizar todos eles