A manager would like to know relationship between billable hours spent on the job the total cost of job including materials.The file jobs.xls contains the data. Summarize the relationship.
| Job |
Billable hours |
Total cost including materials |
| 1 |
680 |
123757 |
| 2 |
450 |
85920 |
| 3 |
520 |
98150 |
| 4 |
740 |
122800 |
| 5 |
880 |
128514 |
| 6 |
650 |
122957 |
| 7 |
250 |
82746 |
| 8 |
270 |
80262 |
| 9 |
770 |
121967 |
| 10 |
570 |
116381 |