Question

A researcher wants to determine the relationship between the typing speed of administrative assistants at a major university is related to the time that it takes for the admin assistant to learn to use a new software program and may be used to predict learning time. Data are gathered from 12 departments at the university.

Dept Typing speed (words per minute) Learning time (hours)

A 48 7

B 74 4

C 52 8

D 79 3.5

E 83 2

F 56 6

G 85 2.3

H 63 5

I 88 2.1

J 74 4.5

K 90 1.9

L 92 1.5

Run a regression analysis of the data on Excel. Use your output to answer the following:

d. What is the value of the correlation coefficient between typing speed and learning time? What does is say about the strength of the relationship?

Answer 1

to run the regression equation in excel use the following path , the path is ...

menu---> excel----->enter the data of variable x ( typing speed ) and learning time ( y ) in excel----->data----->data analysis---->regression----->ok------->Input Y range (select the data of variable (y ) )----------> Input x range ( select the data of variable (x) ) ------>click on box of Labels----> Output range ( select one blank box in excel---->ok the excel output is as follows ;

use the excel command to calculate the correlation coefficient ( r ). the excel command is ,

'  = correl ( select the variable ( y ) , select the variable (x) ) ' enter then answer is r = - 0. 9741 .

here , r = ?0.97, which indicates that there is a strong negative relationship between the variables typing speed (x ) and learning time ( y ). The relationship is negative because, as one variable increases, the other variable decreases. it means increase the typing speed (words per minutes) , the other variable learning time (hours ) decrease .