Explore BrainMass

Explore BrainMass

    calculate the regression

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

    Somewhere in the Milky Way Galaxy, a class of 2,000 students took a course in Astronomy. The first exam scores and the final exam percentage reached earth, but transmission broke off after only a dozen students' scores were received. This is the only information available about that class. That information is in the table below.
    Student Exam 1 Final
    Scorpio 85 76
    Andromeda 80 77
    Pictor 70 72
    Tucana 85 88
    Vulpecula 80 76
    Crux 85 83
    Perseus 40 55
    Orion 75 77
    Cassieopia 80 72
    Ursa 55 73
    Centaurus 70 71
    Hydrus 85 81
    Use these data to answer the following questions
    a. Find the slope and the intercept term for Final = a + b Exam1. Please show work/steps.

    b. Use Excel to calculate the regression. Show numbers as two decimal places even if, 0.00.

    © BrainMass Inc. brainmass.com October 9, 2019, 8:53 pm ad1c9bdddf

    Solution Summary

    This job calculates the regression in the Milky Way Galaxy. percentages researched for transmission are determined.