Emails us- Call US

Assignment help 6021

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.


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.