Explore BrainMass

Explore BrainMass

    Multiple Regression Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    In Microsoft Excel, please respond to all questions and math problems in the following problem. See Attachment. Please show Microsoft Excel formula(s) work.

    -------------------------

    Problem 1: Twenty-six observations

    1. Suppose Y is related to R and S in the following nonlinear way: Y = aRbSc
    a. In order to estimate the parameters a, b, and c, the equation must be transformed into the form: ___________________________________.

    Twenty-six observations are used to obtain the following regression results:
    DEPENDENT VARIABLE: LNY R-SQUARE F-RATIO P-VALUE ON F
    OBSERVATIONS: 26 0.3647 4.21 0.0170
    VARIABLE PARAMETER STANDARD T-RATIO P-VALUE
    ESTIMATE ERROR

    INTERCEPT 2.9957 0.3545 8.45 0.0001
    LNR 2.34 0.87 2.69 0.0134
    LNS -0.687 0.334 -2.06 0.0517

    b. There are __________ degrees of freedom for the t-test. At the 1% level of significance, the critical t-value for the test is ________________.
    c. At the 1% level of significance, a? ____________ (is, is not) significant, b? __________ (is, is not) significant, and ? c ___________ (is, is not) significant.
    d. The estimated value of a is __________________.
    e. The p-value for b? indicates that the exact level of significance is _______ percent, which is the probability of _________________________________.
    f. At the 1% level of significance, the critical value of the F-statistic is _________. The model as a whole ___________ (is, is not) significant at the 1% level.
    g. If R = 12 and S = 30, the fitted (or predicted) value of Y is _____________.
    h. The percentage of the total variation in the dependent variable not explained by the regression is _______________ percent.
    i. If R increases by 14%, Y will increase by ________ percent.
    j. A 6.87% increase in Y will occur if S ________________ (increases, decreases) by _______ percent.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:15 am ad1c9bdddf
    https://brainmass.com/statistics/students-t-test/449360

    Attachments

    Solution Preview

    Problem 1: Twenty-six observations
    1. Suppose Y is related to R and S in the following nonlinear way: Y = aRbSc
    a. In order to estimate the parameters a, b, and c, the equation must be transformed into the form: _ln(Y) = ln(a) + b*ln(R) +c*ln(S)___.
    I assume that the question is supposed to read Y = a * Rb * Sc (b and c are exponents). Is that correct? If so, then you need to take the logarithm of both sides:
    Y = a * Rb * Sc
    ln(Y) = ln(a * Rb * Sc)
    ln(Y) = ln(a) + b*ln(R) +c*ln(S)
    This transforms the original equation into a linear equation.

    Twenty-six observations are used to obtain the following regression results:
    DEPENDENT VARIABLE: LNY R-SQUARE F-RATIO P-VALUE ON F
    OBSERVATIONS: 26 0.3647 4.21 0.0170
    VARIABLE PARAMETER STANDARD T-RATIO P-VALUE
    ESTIMATE ...

    $2.19

    ADVERTISEMENT