Use the Excel TREND() function to fit a trend line to the Example 8.1 data set, as

Question:

Use the Excel TREND() function to fit a trend line to the Example 8.1 data set, as illustrated in Figure 8.20.

A 1 Example 8.10 4 5 6 Employee number 1 17 18 19 20 2 3 4 5 7 8 9 10 11 12 13 14 15 11 16 12 678 9 GUNNS 10


Data from Example 8.1

A large manufacturing firm with some 8000 employees has designed a training programme that is supposed to increase the production of employees. The personnel manager decides to examine this claim by analysing the data results from the first group of 20 employees that attended the course.

Table 8.1 provides the data set for the % change in production (y) measured against a range of production values (x).

Employee number 1 2 3 4 LO 5 6 7 8 9 10 11 12 13 14 15 16 67 17 18 19 20 Table 8.1 Production, x % change in

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: