Question: Reconsider the data set in Example 8.1. Data from Example 8.1 A large manufacturing firm with some 8000 employees has designed a training programme that

Reconsider the data set in Example 8.1.


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

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 production, y 4.2 47 71 64 35 43 60 38 59 67 56 67 57 69 38 54 76 53 40 47 23 8.1 6.8 4.3 5.0 7.5 4.7 5.9 6.9 5.7 5.7 5.4 7.5 3.8 5.9 6.3 5.7 4.0 5.2 2.2

Step by Step Solution

3.42 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Figure 83 shows the Excel solution to calculate covariance B 1 Covariance Change in production vs p... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!