We have been given the labor hour history below. You have been asked to calculate a linear trend line for this data. What is the intermediate solution for the value of ∑(ty)?
Week Hours
1 4558
2 4590
3 4513
4 4407
We place values of Week as “t” in one column in excel
We also place values of Hours as “Y” in adjacent columns in excel
Value of t” gets multiplied by corresponding “y” and feature as “t.y” in column adjacent to “y”
All the values of “ty” get added up to a figure of 45435
Therefore . intermediate solution for the value of Sum ( ty) = 45435
Refer below table for ready reference:
Week ( t) |
Hours ( Y) |
t.Y |
1 |
4558 |
4558 |
2 |
4590 |
9148 |
3 |
4513 |
13661 |
4 |
4407 |
18068 |
SUM = |
45435 |
Get Answers For Free
Most questions answered within 1 hours.