Assignment Question Read the case notes below and consider the information shown in the appendix Use this information to determine the likely consequences of the introduction of a profit sharing scheme Then write a report for the Directors of PK Mart which addresses this issue and makes appropriate recommendations Profit Sharing You have recently been appointed as an analyst within a large retail organisation (PK Mart) that employs approximately 10,000 individuals PK Mart is a non specialist retailer selling items such as clothing, electricals and furniture The Directors of PK Mart are considering whether the company should introduce a profit sharing scheme for all of its employees To help with this important decision the Directors want to determine the possible benefits associated with such a scheme You have therefore been asked to undertake some quantitative analysis looking at this issue While you are familiar with various different aspects of statistics and a number of statistical packages you have not undertaken a project of this nature before Hence you start by conducting a literature search This search proves beneficial and you find that there are a number of existing studies which look at the impact of profit sharing, although none specifically in a retail context In terms of theoretical work two principle arguments have been put forward to suggest that profit sharing may have positive effects The first of these postulates that introduction of such a scheme will improve employee satisfaction and organisational commitment The second that there will be greater alignment of employee and employer interests if such a scheme is introduced In both cases there is also the suggestion that individual productivity is likely to increase In contrast, empirical work has tended to focus on the impact which the introduction of a profit sharing scheme is likely to have upon the performance of the company concerned In this context various measures of company performance have been used including return on capital employed, value added and shareholder wealth All such studies also contain 'control variables' which are likely to impact on company performance The most frequently used of these are firm size and market power In addition, many studies have attempted to control for the industry in which the firms are located From the material you have identified you draw up a list of variables which can be used to identify the impact, if any, of the introduction of a profit sharing scheme You then obtain numerical data on each of these variables (details of the data can be found in Appendix I) You now need to consider how you will analyse this information In addition you need to consider how you will explain the approach(es) you have adopted and the implications of your analysis given that the Directors of PK Mart are not experts in quantitative or statistical methods Appendix I The data related to this assignment, in total there are 280 observations The first 6 observations are shown below All data is annual Variable definitions Roce Return on capital employed, percent Prod Productivity, output per employee averaged across the firm Commit Employee commitment, 3 point scale averaged across the firm Scheme 1 if company has a profit sharing scheme, 0 otherwise Assets Book value of firm assets, m Measure of firm size Power Market power, proxied by market share (percent) Industry Sector in which company operates 1 if primary, 2 if manufacturing, 3 if services Roce Prod Commit Scheme Assets Power Industry 16 8 3 62 2 05 1 8782 18 3 22 4 7 42 2 56 1 7795 14 3 3 5 1 56 1 71 1 12805 15 2 16 8 4 34 1 79 1 7071 12 1 16 1 4 62 1 93 1 13840 14 3 26 6 6 7 2 06 1 4884 21 3 9 8 2 94 2 19 1 6035 21 2 21 7 7 58 2 08 1 13961 16 3 23 1 7 5 2 1 10967 9 3 18 2 7 86 2 09 1 8574 13 2 28 7 8 45 2 64 1 5996 15 3 18 9 6 87 2 22 1 1792 13 3 17 5 5 42 2 41 1 48 17 3 16 1 4 25 1 92 1 5207 15 3 15 4 5 19 2 03 1 3557 17 3 26 6 8 72 2 05 1 4440 18 3 4 2 1 37 1 71 1 2805 10 2 25 9 8 7 2 33 1 5538 12 3 11 9 4 21 2 04 1 8125 10 2 6 3 2 13 2 06 0 14006 17 3 11 2 4 49 2 41 1 6051 13 2 9 1 2 8 1 71 1 14977 18 3 6 3 2 59 2 15 1 7698 13 2 6 3 2 74 2 02 0 8683 10 3 17 5 5 4 1 95 1 4036 17 2 23 8 6 26 2 12 1 10910 15 3 8 4 2 3 1 84 0 5906 11 2 26 6 10 1 2 49 1 13216 15 3 11 9 3 45 2 29 0 2356 19 2 14 7 4 83 2 21 0 7750 17 2 10 5 4 14 2 09 1 4855 11 3 12 6 4 34 2 22 0 6874 10 2 11 9 3 29 1 76 1 15596 15 3 16 8 3 52 1 84 0 12446 16 2 14 7 4 92 2 32 1 4205 10 3 23 1 8 71 2 48 1 1213 20 2 6 3 1 98 2 14 1 1929 16 2 14 3 98 2 04 1 6831 14 3 24 5 7 86 2 15 1 13248 16 3 20 3 10 76 2 28 1 7034 11 3 21 6 24 2 05 1 7038 14 3 2 1 2 36 1 73 0 762 13 3 22 4 9 19 2 2 1 4237 16 3 21 7 10 85 2 32 1 7456 16 3 9 1 2 19 2 1 11399 15 3 12 6 3 31 1 96 0 9717 18 3 24 5 8 89 2 45 1 6569 14 2 18 2 8 89 2 63 1 3726 17 2 25 2 7 08 2 45 1 9038 18 3 9 8 2 95 2 15 0 6699 12 3 11 2 3 82 1 79 0 13444 15 2 22 4 7 95 2 45 1 5402 12 2 14 3 99 2 32 1 6979 16 2 19 6 5 93 2 17 1 8632 16 3 25 2 7 43 2 11 1 14916 14 3 21 6 73 2 34 0 10463 15 3 15 4 5 22 2 14 1 6035 10 3 18 2 10 22 2 42 1 13678 13 3 30 1 8 76 2 33 0 4143 11 3 22 4 8 2 2 41 1 9347 13 3 15 4 5 07 2 09 0 6963 16 3 18 2 10 58 2 3 1 3998 17 3 17 5 5 34 2 15 1 9427 16 3 11 9 4 58 1 71 1 2736 15 3 18 2 8 79 2 49 1 3581 16 3 4 2 1 48 2 01 0 1227 18 2 21 7 6 36 2 03 1 7322 20 2 19 6 5 66 2 12 1 7057 13 3 18 2 7 92 2 41 1 11673 16 3 23 8 9 5 2 68 1 7526 15 3 6 3 2 7 1 65 1 6153 15 3 15 4 5 05 2 09 1 9568 19 3 24 5 10 37 2 09 1 6579 12 3 11 9 3 21 2 1 1776 16 3 20 3 10 58 2 32 1 10930 20 3 16 1 5 31 2 04 1 6838 13 1 13 3 3 55 1 93 1 6920 17 2 23 8 8 5 2 08 1 12160 10 3 11 2 4 58 2 4 0 3260 16 2 37 8 14 4 2 81 1 4348 18 2 18 2 5 46 2 0 12012 14 1 18 2 5 54 1 89 1 8330 13 3 10 5 4 76 2 22 1 9524 9 3 1 4 1 51 1 98 0 6318 17 3 24 5 6 2 2 4 0 7156 14 3 11 9 3 63 2 23 0 8224 13 3 11 9 3 72 2 4 1 2515 13 2 30 8 12 19 2 44 1 11452 21 1 28 10 86 2 7 1 9356 12 2 11 2 4 5 1 95 0 5870 17 2 24 5 7 74 1 87 1 12590 15 3 9 8 2 94 1 85 0 8945 15 3 25 9 9 06 2 07 1 16357 19 3 23 1 9 23 2 19 1 12357 16 2 13 3 3 66 2 33 1 3298 19 3 7 1 85 1 58 0 2880 11 3 16 1 3 29 2 19 0 3808 16 3 2 8 1 56 1 67 0 11362 14 2 12 6 4 11 1 68 1 3753 16 3 9 8 2 91 2 03 1 9990 13 2 13 3 3 86 2 08 0 2636 15 3 2 8 2 04 1 78 1 4152 14 2 22 4 6 55 2 56 0 8424 22 2 24 5 6 4 2 34 1 7728 19 3 0 7 1 55 2 01 0 4145 14 3 8 4 2 07 1 98 0 1179 14 3 16 1 3 8 2 18 0 15200 17 2 19 6 6 04 2 1 7733 13 1 12 6 4 16 2 16 1 5981 18 3 18 2 8 7 2 22 1 13979 11 3 14 7 4 86 1 71 1 11062 20 2 20 3 6 15 2 22 0 4273 12 3 12 6 4 22 2 26 1 737 16 2 21 6 65 2 37 1 4380 16 3 0 7 1 02 1 63 0 4605 20 3 3 5 2 01 1 64 0 9424 19 3 11 2 3 39 1 89 0 9813 16 2 16 1 5 34 2 36 1 8842 15 3 11 2 4 21 2 23 1 173 13 3 14 7 4 31 2 22 1 7100 12 3 24 5 7 74 2 43 0 14710 13 3 2 8 1 98 2 07 1 4595 13 3 10 5 3 1 2 03 1 8676 15 2 2 1 2 36 1 85 1 12108 15 3 7 1 8 1 82 1 4103 14 3 11 9 3 21 2 46 0 7512 14 3 23 1 7 1 2 18 1 7136 14 3 21 6 98 2 58 1 8348 15 2 24 5 8 33 2 25 1 5364 16 2 2 8 2 18 2 38 0 2491 16 3 8 4 1 98 2 04 0 6549 17 3 2 8 2 14 1 62 0 2739 11 2 30 8 12 21 2 72 1 4386 16 3 18 9 7 1 2 28 1 3470 16 3 4 9 2 41 2 1 6384 14 2 9 8 2 91 1 74 0 4154 14 2 28 6 47 2 37 1 8150 19 3 8 4 2 63 1 87 0 4208 13 3 18 2 7 96 2 67 1 3396 14 2 15 4 5 2 2 33 1 971 12 3 14 7 3 43 2 11 0 275 17 2 21 6 44 2 3 1 6045 16 3 11 9 3 75 1 97 1 15234 11 2 14 3 93 2 05 1 5903 19 2 30 8 9 26 2 5 1 14078 16 2 21 7 9 03 2 54 1 10248 10 3 16 8 3 64 2 03 0 12054 12 2 18 2 5 54 2 1 12522 11 2 22 4 6 42 2 13 1 2865 18 1 13 3 3 89 1 87 1 1982 17 3 0 1 01 1 87 0 863 14 2 4 2 2 65 2 27 0 9152 16 2 17 5 5 46 2 12 1 1910 16 3 14 7 3 82 2 08 0 6149 15 3 11 9 4 48 2 22 0 13024 16 3 19 6 5 8 2 46 0 9776 12 2 11 2 4 12 2 07 0 2929 18 3 14 4 63 2 28 0 5485 16 3 8 4 2 29 1 75 1 4541 17 2 14 7 4 08 2 22 0 6619 20 3 10 5 3 19 1 86 1 3279 12 3 3 5 2 13 1 96 0 3799 12 1 18 2 5 5 2 23 1 6754 16 3 20 3 7 26 2 19 1 8254 10 3 4 9 2 3 1 69 0 3266 21 3 11 2 4 43 2 01 1 8476 9 2 20 3 9 67 2 48 1 12992 12 2 15 4 5 08 2 24 1 2690 13 3 16 1 4 1 1 96 0 1427 13 1 18 9 7 25 2 42 1 7971 13 3 18 9 10 47 2 3 1 11269 14 2 28 7 6 21 2 2 0 11830 15 2 19 6 5 75 2 59 1 3311 15 3 16 1 3 35 2 13 1 4140 11 2 16 8 3 31 2 35 1 26 15 2 14 7 3 31 1 94 1 12199 16 3 23 8 9 55 2 25 1 2186 7 3 6 3 2 72 1 75 1 16012 21 3 19 6 5 79 2 5 1 8831 14 3 12 6 4 51 2 38 1 11880 14 3 22 4 8 82 2 53 1 10801 13 1 37 8 13 34 2 55 1 14906 18 3 9 8 3 03 1 77 0 4526 13 2 10 5 4 61 2 32 0 1504 14 3 15 4 5 1 1 89 1 8307 15 3 11 2 3 71 1 84 0 11707 11 3 13 3 3 73 2 06 0 8484 11 3 7 7 2 32 2 43 1 348 12 2 8 4 2 55 1 63 0 6835 12 3 28 10 26 2 02 1 7850 15 3 19 6 5 62 2 09 1 9969 21 3 31 5 12 6 2 48 1 11465 13 3 11 2 3 59 2 19 0 4375 12 2 12 6 4 25 2 05 1 10364 19 3 7 1 79 2 21 1 16747 9 3 17 5 5 41 2 2 0 14281 16 2 13 3 4 36 2 23 1 4801 17 3 16 1 4 34 1 88 1 7016 13 3 8 4 2 5 1 75 0 2572 16 3 15 4 5 12 2 04 1 3842 10 3 6 3 2 71 1 97 0 6068 15 1 12 6 4 29 2 07 1 9530 13 2 21 8 04 2 48 1 3650 17 3 21 6 76 2 11 1 3904 11 1 10 5 3 5 2 07 1 4248 13 2 14 3 95 2 05 0 5145 14 3 4 9 1 93 1 97 0 4066 16 3 23 1 9 18 2 38 0 4092 10 3 21 7 7 5 1 91 1 8150 13 3 10 5 3 17 2 23 1 6660 12 3 9 8 3 04 2 05 0 8352 13 1 28 8 97 2 27 1 6494 16 3 9 1 2 87 2 12 0 7448 15 2 39 2 15 5 2 53 1 8428 14 3 32 2 12 96 2 65 1 3167 13 3 28 9 5 2 47 1 6697 12 2 24 5 6 32 2 15 0 2485 15 3 21 7 10 24 2 48 1 9968 13 2 21 6 93 2 29 1 4608 14 2 24 5 8 85 2 41 1 8580 10 3 7 7 1 89 2 03 0 6805 19 2 32 9 13 2 4 1 3328 12 3 10 5 3 14 1 81 1 10015 18 3 9 1 2 75 2 01 0 7871 14 3 10 5 3 17 1 96 0 9564 16 3 16 8 3 62 2 15 1 10768 16 1 14 4 66 2 35 0 6670 16 3 30 8 11 08 2 63 1 1701 16 3 14 7 4 84 2 15 1 11142 13 3 20 3 6 14 2 41 1 14586 12 3 14 7 4 85 2 26 1 10980 16 3 6 3 2 75 1 83 1 11460 13 3 21 7 6 43 2 5 1 6733 15 2 23 1 10 75 2 45 1 6842 17 3 14 7 4 93 1 98 1 13932 11 3 20 3 6 1 2 25 1 1668 10 3 3 5 1 95 1 77 1 4229 15 3 14 7 4 95 2 1 7688 10 3 17 5 5 44 2 34 1 5754 13 2 14 4 46 1 93 1 8715 15 3 8 4 2 25 2 2 0 12600 16 3 18 9 6 55 2 06 1 12244 17 1 26 6 9 28 2 56 1 7804 19 2 0 7 1 79 1 94 0 2723 18 3 15 4 5 2 2 02 1 11452 11 2 24 5 8 77 2 4 1 9517 12 3 11 9 3 65 2 28 1 11555 15 3 18 9 7 2 2 36 1 10737 13 3 30 1 6 25 2 23 1 4672 13 1 11 9 3 22 2 45 0 1871 14 2 17 5 4 81 2 16 1 6680 12 2 19 6 5 67 2 26 1 6172 15 3 12 6 3 33 1 84 0 10356 14 3 9 8 2 87 2 14 1 12306 15 3 21 7 6 89 2 25 1 6181 16 2 12 6 3 39 2 01 1 9125 16 3 24 5 6 53 2 22 1 8544 14 3 15 4 4 98 2 39 1 9140 17 3 16 1 3 98 2 05 1 11854 13 2 4 9 2 33 2 23 0 7108 12 2 13 3 4 43 1 98 1 10883 12 2 7 1 87 1 71 1 3466 16 2 25 2 8 95 2 39 1 14658 16 2 16 1 3 62 2 15 0 12613 16 3 18 2 5 47 1 94 1 6692 11 3 0 7 1 17 2 13 0 5599 19 3 19 6 6 03 1 94 1 6136 13 3 21 7 6 69 1 95 1 11850 14 1 18 2 5 57 2 09 1 15498 17 2 20 3 7 62 1 89 0 6119 11 3 23 8 6 69 2 45 0 6253 14 3 15 4 5 25 2 01 1 8962 14 3 20 3 8 49 2 04 1 2863 15 1 20 3 6 06 2 6 0 979 17 2 11 2 3 37 1 94 0 9812 14 2 16 1 4 53 1 95 1 8451 15 2 18 9 8 07 2 57 1 7474 12 3 14 7 3 84 2 13 1 7300 14 3 32 9 13 2 2 36 1 6182 12 3 18 2 9 94 2 67 1 7410 8 3 Further Guidance It is important to bear in mind that the content of your answer will depend on the argument that you wish to put forward in answer to the question and not solely on the concepts that the question explicitly identifies Remember, the Directors of PK Mart are not experts in statistical analysis Hence you will need to explain what you are doing and why, as well as the meaning of your results In structuring your report you may wish to consider the following framework This does not mean that you simply respond to (a) to (e) below, but rather that you formulate headings and sub headings for your report using the framework as a starting point A graphical representation of the data and a discussion of any issues or patterns which arise from this exercise You need to decide upon the exact data to use and appropriate graph(s) Descriptive analysis and discussion of the variables shown in the data set Bivariate (two variable) analysis and discussion which considers these variables and the effects of profit sharing Multivariate (three or more variable) analysis and associated discussion which makes use of the data given Any other issues, problems or additional complications which you feel should be conveyed to the Directors of PK Mart with respect to your analysis

The Answer is in the image, click to view ...

Question: Assignment Question Read the case notes below and consider the information shown in the appendix. Use this information to determine the likely consequences of the

Assignment Question

Read the case notes below and consider the information shown in the appendix.

Use this information to determine the likely consequences of the introduction of a profit sharing scheme.

Then write a report for the Directors of PK Mart which addresses this issue and makes appropriate recommendations.

Profit Sharing

You have recently been appointed as an analyst within a large retail organisation (PK Mart) that employs approximately 10,000 individuals. PK Mart is a non-specialist retailer selling items such as clothing, electricals and furniture.

The Directors of PK Mart are considering whether the company should introduce a profit sharing scheme for all of its employees. To help with this important decision the Directors want to determine the possible benefits associated with such a scheme.

You have therefore been asked to undertake some quantitative analysis looking at this issue. While you are familiar with various different aspects of statistics and a number of statistical packages you have not undertaken a project of this nature before. Hence you start by conducting a literature search.

This search proves beneficial and you find that there are a number of existing studies which look at the impact of profit sharing, although none specifically in a retail context.

In terms of theoretical work two principle arguments have been put forward to suggest that profit sharing may have positive effects. The first of these postulates that introduction of such a scheme will improve employee satisfaction and organisational commitment. The second that there will be greater alignment of employee and employer interests if such a scheme is introduced. In both cases there is also the suggestion that individual productivity is likely to increase. In contrast, empirical work has tended to focus on the impact which the introduction of a profit sharing scheme is likely to have upon the performance of the company concerned.

In this context various measures of company performance have been used including return on capital employed, value added and shareholder wealth. All such studies also contain 'control variables' which are likely to impact on company performance. The most frequently used of these are firm size and market power. In addition, many studies have attempted to control for the industry in which the firms are located.

From the material you have identified you draw up a list of variables which can be used to identify the impact, if any, of the introduction of a profit sharing scheme. You then obtain numerical data on each of these variables (details of the data can be found in Appendix I).

You now need to consider how you will analyse this information. In addition you need to consider how you will explain the approach(es) you have adopted and the implications of your analysis given that the Directors of PK Mart are not experts in quantitative or statistical methods.

Appendix I

The data related to this assignment, in total there are 280 observations. The first 6 observations are shown below. All data is annual.

Variable definitions:

Roce: Return on capital employed, percent.

Prod: Productivity, output per employee averaged across the firm.

Commit: Employee commitment, 3 point scale averaged across the firm.

Scheme: 1 if company has a profit sharing scheme, 0 otherwise.

Assets: Book value of firm assets, m. Measure of firm size.

Power: Market power, proxied by market share (percent).

Industry: Sector in which company operates:

1 if primary,

2 if manufacturing,

3 if services

Roce	Prod	Commit	Scheme	Assets	Power	Industry
16.8	3.62	2.05	1	8782	18	3
22.4	7.42	2.56	1	7795	14	3
-3.5	1.56	1.71	1	12805	15	2
16.8	4.34	1.79	1	7071	12	1
16.1	4.62	1.93	1	13840	14	3
26.6	6.7	2.06	1	4884	21	3
9.8	2.94	2.19	1	6035	21	2
21.7	7.58	2.08	1	13961	16	3
23.1	7.5	2	1	10967	9	3
18.2	7.86	2.09	1	8574	13	2
28.7	8.45	2.64	1	5996	15	3
18.9	6.87	2.22	1	1792	13	3
17.5	5.42	2.41	1	48	17	3
16.1	4.25	1.92	1	5207	15	3
15.4	5.19	2.03	1	3557	17	3
26.6	8.72	2.05	1	4440	18	3
-4.2	1.37	1.71	1	2805	10	2
25.9	8.7	2.33	1	5538	12	3
11.9	4.21	2.04	1	8125	10	2
6.3	2.13	2.06	0	14006	17	3
11.2	4.49	2.41	1	6051	13	2
9.1	2.8	1.71	1	14977	18	3
6.3	2.59	2.15	1	7698	13	2
6.3	2.74	2.02	0	8683	10	3
17.5	5.4	1.95	1	4036	17	2
23.8	6.26	2.12	1	10910	15	3
8.4	2.3	1.84	0	5906	11	2
26.6	10.1	2.49	1	13216	15	3
11.9	3.45	2.29	0	2356	19	2
14.7	4.83	2.21	0	7750	17	2
10.5	4.14	2.09	1	4855	11	3
12.6	4.34	2.22	0	6874	10	2
11.9	3.29	1.76	1	15596	15	3
16.8	3.52	1.84	0	12446	16	2
14.7	4.92	2.32	1	4205	10	3
23.1	8.71	2.48	1	1213	20	2
6.3	1.98	2.14	1	1929	16	2
14	3.98	2.04	1	6831	14	3
24.5	7.86	2.15	1	13248	16	3
20.3	10.76	2.28	1	7034	11	3
21	6.24	2.05	1	7038	14	3
2.1	2.36	1.73	0	762	13	3
22.4	9.19	2.2	1	4237	16	3
21.7	10.85	2.32	1	7456	16	3
9.1	2.19	2	1	11399	15	3
12.6	3.31	1.96	0	9717	18	3
24.5	8.89	2.45	1	6569	14	2
18.2	8.89	2.63	1	3726	17	2
25.2	7.08	2.45	1	9038	18	3
9.8	2.95	2.15	0	6699	12	3
11.2	3.82	1.79	0	13444	15	2
22.4	7.95	2.45	1	5402	12	2
14	3.99	2.32	1	6979	16	2
19.6	5.93	2.17	1	8632	16	3
25.2	7.43	2.11	1	14916	14	3
21	6.73	2.34	0	10463	15	3
15.4	5.22	2.14	1	6035	10	3
18.2	10.22	2.42	1	13678	13	3
30.1	8.76	2.33	0	4143	11	3
22.4	8.2	2.41	1	9347	13	3
15.4	5.07	2.09	0	6963	16	3
18.2	10.58	2.3	1	3998	17	3
17.5	5.34	2.15	1	9427	16	3
11.9	4.58	1.71	1	2736	15	3
18.2	8.79	2.49	1	3581	16	3
-4.2	1.48	2.01	0	1227	18	2
21.7	6.36	2.03	1	7322	20	2
19.6	5.66	2.12	1	7057	13	3
18.2	7.92	2.41	1	11673	16	3
23.8	9.5	2.68	1	7526	15	3
6.3	2.7	1.65	1	6153	15	3
15.4	5.05	2.09	1	9568	19	3
24.5	10.37	2.09	1	6579	12	3
11.9	3.21	2	1	1776	16	3
20.3	10.58	2.32	1	10930	20	3
16.1	5.31	2.04	1	6838	13	1
13.3	3.55	1.93	1	6920	17	2
23.8	8.5	2.08	1	12160	10	3
11.2	4.58	2.4	0	3260	16	2
37.8	14.4	2.81	1	4348	18	2
18.2	5.46	2	0	12012	14	1
18.2	5.54	1.89	1	8330	13	3
10.5	4.76	2.22	1	9524	9	3
-1.4	1.51	1.98	0	6318	17	3
24.5	6.2	2.4	0	7156	14	3
11.9	3.63	2.23	0	8224	13	3
11.9	3.72	2.4	1	2515	13	2
30.8	12.19	2.44	1	11452	21	1
28	10.86	2.7	1	9356	12	2
11.2	4.5	1.95	0	5870	17	2
24.5	7.74	1.87	1	12590	15	3
9.8	2.94	1.85	0	8945	15	3
25.9	9.06	2.07	1	16357	19	3
23.1	9.23	2.19	1	12357	16	2
13.3	3.66	2.33	1	3298	19	3
7	1.85	1.58	0	2880	11	3
16.1	3.29	2.19	0	3808	16	3
-2.8	1.56	1.67	0	11362	14	2
12.6	4.11	1.68	1	3753	16	3
9.8	2.91	2.03	1	9990	13	2
13.3	3.86	2.08	0	2636	15	3
2.8	2.04	1.78	1	4152	14	2
22.4	6.55	2.56	0	8424	22	2
24.5	6.4	2.34	1	7728	19	3
0.7	1.55	2.01	0	4145	14	3
8.4	2.07	1.98	0	1179	14	3
16.1	3.8	2.18	0	15200	17	2
19.6	6.04	2	1	7733	13	1
12.6	4.16	2.16	1	5981	18	3
18.2	8.7	2.22	1	13979	11	3
14.7	4.86	1.71	1	11062	20	2
20.3	6.15	2.22	0	4273	12	3
12.6	4.22	2.26	1	737	16	2
21	6.65	2.37	1	4380	16	3
0.7	1.02	1.63	0	4605	20	3
3.5	2.01	1.64	0	9424	19	3
11.2	3.39	1.89	0	9813	16	2
16.1	5.34	2.36	1	8842	15	3
11.2	4.21	2.23	1	173	13	3
14.7	4.31	2.22	1	7100	12	3
24.5	7.74	2.43	0	14710	13	3
2.8	1.98	2.07	1	4595	13	3
10.5	3.1	2.03	1	8676	15	2
2.1	2.36	1.85	1	12108	15	3
7	1.8	1.82	1	4103	14	3
11.9	3.21	2.46	0	7512	14	3
23.1	7.1	2.18	1	7136	14	3
21	6.98	2.58	1	8348	15	2
24.5	8.33	2.25	1	5364	16	2
2.8	2.18	2.38	0	2491	16	3
8.4	1.98	2.04	0	6549	17	3
2.8	2.14	1.62	0	2739	11	2
30.8	12.21	2.72	1	4386	16	3
18.9	7.1	2.28	1	3470	16	3
4.9	2.41	2	1	6384	14	2
9.8	2.91	1.74	0	4154	14	2
28	6.47	2.37	1	8150	19	3
8.4	2.63	1.87	0	4208	13	3
18.2	7.96	2.67	1	3396	14	2
15.4	5.2	2.33	1	971	12	3
14.7	3.43	2.11	0	275	17	2
21	6.44	2.3	1	6045	16	3
11.9	3.75	1.97	1	15234	11	2
14	3.93	2.05	1	5903	19	2
30.8	9.26	2.5	1	14078	16	2
21.7	9.03	2.54	1	10248	10	3
16.8	3.64	2.03	0	12054	12	2
18.2	5.54	2	1	12522	11	2
22.4	6.42	2.13	1	2865	18	1
13.3	3.89	1.87	1	1982	17	3
0	1.01	1.87	0	863	14	2
4.2	2.65	2.27	0	9152	16	2
17.5	5.46	2.12	1	1910	16	3
14.7	3.82	2.08	0	6149	15	3
11.9	4.48	2.22	0	13024	16	3
19.6	5.8	2.46	0	9776	12	2
11.2	4.12	2.07	0	2929	18	3
14	4.63	2.28	0	5485	16	3
8.4	2.29	1.75	1	4541	17	2
14.7	4.08	2.22	0	6619	20	3
10.5	3.19	1.86	1	3279	12	3
3.5	2.13	1.96	0	3799	12	1
18.2	5.5	2.23	1	6754	16	3
20.3	7.26	2.19	1	8254	10	3
4.9	2.3	1.69	0	3266	21	3
11.2	4.43	2.01	1	8476	9	2
20.3	9.67	2.48	1	12992	12	2
15.4	5.08	2.24	1	2690	13	3
16.1	4.1	1.96	0	1427	13	1
18.9	7.25	2.42	1	7971	13	3
18.9	10.47	2.3	1	11269	14	2
28.7	6.21	2.2	0	11830	15	2
19.6	5.75	2.59	1	3311	15	3
16.1	3.35	2.13	1	4140	11	2
16.8	3.31	2.35	1	26	15	2
14.7	3.31	1.94	1	12199	16	3
23.8	9.55	2.25	1	2186	7	3
6.3	2.72	1.75	1	16012	21	3
19.6	5.79	2.5	1	8831	14	3
12.6	4.51	2.38	1	11880	14	3
22.4	8.82	2.53	1	10801	13	1
37.8	13.34	2.55	1	14906	18	3
9.8	3.03	1.77	0	4526	13	2
10.5	4.61	2.32	0	1504	14	3
15.4	5.1	1.89	1	8307	15	3
11.2	3.71	1.84	0	11707	11	3
13.3	3.73	2.06	0	8484	11	3
7.7	2.32	2.43	1	348	12	2
8.4	2.55	1.63	0	6835	12	3
28	10.26	2.02	1	7850	15	3
19.6	5.62	2.09	1	9969	21	3
31.5	12.6	2.48	1	11465	13	3
11.2	3.59	2.19	0	4375	12	2
12.6	4.25	2.05	1	10364	19	3
7	1.79	2.21	1	16747	9	3
17.5	5.41	2.2	0	14281	16	2
13.3	4.36	2.23	1	4801	17	3
16.1	4.34	1.88	1	7016	13	3
8.4	2.5	1.75	0	2572	16	3
15.4	5.12	2.04	1	3842	10	3
6.3	2.71	1.97	0	6068	15	1
12.6	4.29	2.07	1	9530	13	2
21	8.04	2.48	1	3650	17	3
21	6.76	2.11	1	3904	11	1
10.5	3.5	2.07	1	4248	13	2
14	3.95	2.05	0	5145	14	3
4.9	1.93	1.97	0	4066	16	3
23.1	9.18	2.38	0	4092	10	3
21.7	7.5	1.91	1	8150	13	3
10.5	3.17	2.23	1	6660	12	3
9.8	3.04	2.05	0	8352	13	1
28	8.97	2.27	1	6494	16	3
9.1	2.87	2.12	0	7448	15	2
39.2	15.5	2.53	1	8428	14	3
32.2	12.96	2.65	1	3167	13	3
28	9.5	2.47	1	6697	12	2
24.5	6.32	2.15	0	2485	15	3
21.7	10.24	2.48	1	9968	13	2
21	6.93	2.29	1	4608	14	2
24.5	8.85	2.41	1	8580	10	3
7.7	1.89	2.03	0	6805	19	2
32.9	13	2.4	1	3328	12	3
10.5	3.14	1.81	1	10015	18	3
9.1	2.75	2.01	0	7871	14	3
10.5	3.17	1.96	0	9564	16	3
16.8	3.62	2.15	1	10768	16	1
14	4.66	2.35	0	6670	16	3
30.8	11.08	2.63	1	1701	16	3
14.7	4.84	2.15	1	11142	13	3
20.3	6.14	2.41	1	14586	12	3
14.7	4.85	2.26	1	10980	16	3
6.3	2.75	1.83	1	11460	13	3
21.7	6.43	2.5	1	6733	15	2
23.1	10.75	2.45	1	6842	17	3
14.7	4.93	1.98	1	13932	11	3
20.3	6.1	2.25	1	1668	10	3
3.5	1.95	1.77	1	4229	15	3
14.7	4.95	2	1	7688	10	3
17.5	5.44	2.34	1	5754	13	2
14	4.46	1.93	1	8715	15	3
8.4	2.25	2.2	0	12600	16	3
18.9	6.55	2.06	1	12244	17	1
26.6	9.28	2.56	1	7804	19	2
-0.7	1.79	1.94	0	2723	18	3
15.4	5.2	2.02	1	11452	11	2
24.5	8.77	2.4	1	9517	12	3
11.9	3.65	2.28	1	11555	15	3
18.9	7.2	2.36	1	10737	13	3
30.1	6.25	2.23	1	4672	13	1
11.9	3.22	2.45	0	1871	14	2
17.5	4.81	2.16	1	6680	12	2
19.6	5.67	2.26	1	6172	15	3
12.6	3.33	1.84	0	10356	14	3
9.8	2.87	2.14	1	12306	15	3
21.7	6.89	2.25	1	6181	16	2
12.6	3.39	2.01	1	9125	16	3
24.5	6.53	2.22	1	8544	14	3
15.4	4.98	2.39	1	9140	17	3
16.1	3.98	2.05	1	11854	13	2
4.9	2.33	2.23	0	7108	12	2
13.3	4.43	1.98	1	10883	12	2
7	1.87	1.71	1	3466	16	2
25.2	8.95	2.39	1	14658	16	2
16.1	3.62	2.15	0	12613	16	3
18.2	5.47	1.94	1	6692	11	3
0.7	1.17	2.13	0	5599	19	3
19.6	6.03	1.94	1	6136	13	3
21.7	6.69	1.95	1	11850	14	1
18.2	5.57	2.09	1	15498	17	2
20.3	7.62	1.89	0	6119	11	3
23.8	6.69	2.45	0	6253	14	3
15.4	5.25	2.01	1	8962	14	3
20.3	8.49	2.04	1	2863	15	1
20.3	6.06	2.6	0	979	17	2
11.2	3.37	1.94	0	9812	14	2
16.1	4.53	1.95	1	8451	15	2
18.9	8.07	2.57	1	7474	12	3
14.7	3.84	2.13	1	7300	14	3
32.9	13.2	2.36	1	6182	12	3
18.2	9.94	2.67	1	7410	8	3

Further Guidance

It is important to bear in mind that the content of your answer will depend on the argument that you wish to put forward in answer to the question and not solely on the concepts that the question explicitly identifies. Remember, the Directors of PK Mart are not experts in statistical analysis. Hence you will need to explain what you are doing and why, as well as the meaning of your results.

In structuring your report you may wish to consider the following framework. This does not mean that you simply respond to (a) to (e) below, but rather that you formulate headings and sub-headings for your report using the framework as a starting point.

A graphical representation of the data and a discussion of any issues or patterns which arise from this exercise. You need to decide upon the exact data to use and appropriate graph(s).

Descriptive analysis and discussion of the variables shown in the data set.

Bivariate (two variable) analysis and discussion which considers these variables and the effects of profit sharing.

Multivariate (three or more variable) analysis and associated discussion which makes use of the data given.

Any other issues, problems or additional complications which you feel should be conveyed to the Directors of PK Mart with respect to your analysis.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 Finance Questions!

please kindly solve this question for me. thank you 2:564 11 3G Assignment Read the case notes below and consider the information shown in the appendix Determine how this information can be used to...

Assignment Read the case notes below and consider the information shown in the appendix Determine how this information can be used to shed light on the impact of ownership structure on company...

Please can you help with the solution to these questions Assignment Read the case notes below and consider the information shown in the appendix Determine how this information can be used to shed...

W&S Partners commenced the planning phase of the Cloud 9 audit with procedures to gain an understanding of the client?s structure and its business environment. You have completed your research on the...

audit case question. read the case properly and ans the required qus, I also upload the picture and copy paste it for your better understanding Introduction The accounting firm of Barnes and Fischer,...

Submit this coursework through the Student Portal with a Turn-it-in Report Word Limit: 1000 words (Plus or minus 10%) Learning outcomes assessed: 1. Explain the sales ledger, purchase ledger and...

Hello I am in need of some assistance with an assignment: APA formatted Grammer and Spelling is key Read Brewing Up Controversy: A Case Exploring the Ethics of Corporate Tax Planning Written...

See attached the case study for below questions. CASE REQUIREMENTS 1. What principles are involved in this situation? Start with not only the written standards that apply to this situation (i.e., the...

Refer to the Real life titled How should the Pacific Islands Forum Fisheries Agency allocate its overheads? in the section Issues in estimating overhead rates and evaluate the FFAs decision to...

Given the following information, standard deviation = 6 %3D coefficient of variation = 96% what is the mean? O 0.625 O 0.96 O 6 O 6.25

In financial accounting, which cornerstone is a simple formula and has to always stay in balance? Financial Statements Accounting Equation Budgets Generally Accepted Accounting Principles

n For sample values x, X2, X, the sample variance is s 1 n = 0-1 i=1 (1-3)* (x-2 where x =x, is the sample mean. 1 n i=1 (a) Show that the sample variance is unchanged if a constant c is added to or...