Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. A trainee manager wondered whether the length of time his trainees revised for an exam had any effect on their results. A random sample
5. A trainee manager wondered whether the length of time his trainees revised for an exam had any effect on their results. A random sample of trainees was asked to estimate how long they spent revising to the n earest hour. After the exam he investigated the relationship between the two variables. Trainee: ABCDEFGHIJ Revision time: 491014471222117 Exam mark (\%): 31586573374460912184 Use Excel to answer the following questions. Enter the data into two columns. (a) Plot a scatter diagram (decide which is the dependent variable first!) (b) Calculate the correlation coefficient (c) Find the regression model (d) Predict the exam mark for a trainee who revises for 15 hours (e) Predict the exam mark for a trainee who revises for 35 hours (f) Comment on your answer to (e)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started