Do the students’ scores for the two exams tend to go together, so that those who do poorly on the midterm tend to do poorly on the final, and those who do well on the midterm tend to do well on the final? Create a scatterplot, along with a correlation, to

profileUOPOnlineTutor
 (Not rated)
 (Not rated)
Chat
  1. Do the students’ scores for the two exams tend to go together, so that those who do poorly on the midterm tend to do poorly on the final, and those who do well on the midterm tend to do well on the final? Create a scatterplot, along with a correlation, to answer this question.
  2. Superimpose a (linear) trend line on the scatterplot, along with the equation of the line. Based on this equation, what would you expect a student with a 75 on the midterm to score on the final exam? (Albright, 2017, p. 105).

In the discussion area, answer both questions in Parts a and b. Attach the Excel document that shows the scatterplot, correlation, and trend line.

 

Reference:

  • Albright, S. C, & Winston, W. L. (2017). Business Analytics: Data Analysis and Decision Making (6th ed.). Boston, MA: Cengage Learning.
    • 7 years ago
    A+ Solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      regreb.docx