Explore BrainMass

Explore BrainMass

    Simple regression using excel and interpreting the results

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    See the attachment.

    1. The quality of the orange juice produced by a manufacturer (e.g., Minute Maid, Tropicana) is constantly monitored. There are numerous sensory and chemical components that combine to make the best-tasting orange juice. For example, one manufacturer has developed a quantitative index of the "sweetness" of orange juice. (The higher the index, the sweeter the juice.) Is there a relationship between the sweetness index and a chemical measure such as the amount of water-soluble pectin (parts per million) in the orange juice? Data collected on these two variables for 24 production runs at a juice manufacturing plant are shown in the table below. Suppose a manufacturer wants to use simple linear regression to predict the sweetness (y) from the amount of pectin (x).
    Run Sweetness Index Pectin (ppm) Run Sweetness Index Pectin (ppm)
    1 5.2 220 13 5.8 306
    2 5.5 227 14 5.5 259
    3 6 259 15 5.3 284
    4 5.9 210 16 5.3 383
    5 5.8 224 17 5.7 271
    6 6 215 18 5.5 264
    7 5.8 231 19 5.7 227
    8 5.6 268 20 5.3 263
    9 5.6 239 21 5.9 232
    10 5.9 212 22 5.8 220
    11 5.4 410 23 5.8 246
    12 5.6 256 24 5.9 241

    Please assist with the following:

    a. Find the least squares line for the data.
    b. What do β0 and β1 represent in the words of the problem?
    c. Predict the sweetness index if amount of pectin in the orange juice is 300 ppm.
    d. Find the values of SSE, s2, and s for this regression.
    e. Explain why it is difficult to give a practical interpretation to s2.
    f. Give a practical interpretation of the value of s.
    g. Use the results of the regression to form a 95% confidence interval for the slope, b1.
    h. Find and interpret the coefficient of determination, r2, and the coefficient of correlation, r.
    i. A 90% confidence interval for the predicted value of mean sweetness index, E(y), for run 1 is (5.649,5.838). What does this interval mean in terms of the problem?

    © BrainMass Inc. brainmass.com March 5, 2021, 1:37 am ad1c9bdddf
    https://brainmass.com/statistics/confidence-interval/simple-regression-excel-interpreting-results-603436

    Attachments

    Solution Preview

    See the attached files.

    1. The quality of the orange juice produced by a manufacturer (e.g., Minute Maid, Tropicana) is constantly monitored. There are numerous sensory and chemical components that combine to make the best-tasting orange juice. For example, one manufacturer has developed a quantitative index of the "sweetness" of orange juice. (The higher the index, the sweeter the juice.) Is there a relationship between the sweetness index and a chemical measure such as the amount of water-soluble pectin (parts per million) in the orange juice? Data collected on these two variables for 24 production runs at a juice manufacturing plant are shown in the table below. Suppose a manufacturer wants to use simple linear regression to predict the sweetness ...

    Solution Summary

    The solution gives detailed steps on running a simple regression using Excel and interpreting the results such as least squares line, slope, coefficient of determination and standard error.

    $2.49

    ADVERTISEMENT