Refer to the Excel spreadsheet named “Education” (sheet 3) to answer the following questions. You have been selected to be the Teaching Assistant for an Introduction to Statistics class this semester. The Professor wants to know if the students’ Pre-Test grades are correlated with their first Exam grades. The Excel file the Professor gave includes a randomly selected set of scores for the Pre-Test and Exam 1 from a past class of students.1. Calculate the correlation between Pre-Test and Exam 1.2. Is the relationship linear? As the Pre-Test score increases does the Exam 1 score increase also?3. What percentage of the variation in Exam 1 scores is accounted for by the Pre-Test scores?The Professor would also like you to create a regression equation for future semesters to predict student’s Exam 1 grades from their Pre-Test scores.4. Let the Exam 1 grades be the dependent variable and the Pre-Test scores be the independent variable. Determine the Regression Equation.5. Estimate the Exam 1 grade for a student that received a grade of 16 on the Pre-Test.
Assignment help 6021
Solution:
15% off for this assignment.
Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!
Why US?
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Money Back
If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.