In: Statistics and Probability
Use the following to answer questions: A company wants to study the relationship between an employee's length of employment and their number of workdays absent. The company collected the following information on a random sample of seven employees.
Number of Workdays Absent |
2 |
3 |
3 |
5 |
7 |
7 |
8 |
Length of Employment (in yrs) |
5 |
6 |
9 |
4 |
2 |
2 |
0 |
1.What is the independent variable (X)?
2.What is the dependent variable (Y)?
3.What is the slope of the linear equation?
4.What is the Y intercept of the linear equation?
5.What is the least squares equation for the data?
6.What is the meaning of a negative slope?
7.What is the standard error of estimate?
Using Excel
data -> data analysis -> regression
select cell values for y column $B$1:$B$8 and x-column $A$1:$A$8
tick on label
1.What is the independent variable (X)?
length of Employment
2.What is the dependent variable (Y)?
Number of Workdays Absent
3.What is the slope of the linear equation?
slope = -0.6852
4.What is the Y intercept of the linear equation?
y-intercept = 7.7407
5.What is the least squares equation for the data?
y^ = 7.7407 - 0.6852 x
6.What is the meaning of a negative slope?
this means as length of employment increase by 1 years, number of workdata Absent decreases
7.What is the standard error of estimate?
standard error = 1.3152
Please give me a thumbs-up if this helps you out. Thank you! :)