Individual written analysis (suitable for a web page) integrating applied quantitative analysis within Excel, real data and focused interpretation. (Maximum words 2,500 with additional evidence as reader notes, data and Excel analysis).
QUANTITATIVE SKILLS FOR BUSINESS
Description of the assessment
Module Learning Outcomes
On successful completion of the module, students will be able to:
1. Demonstrate knowledge of quantitative techniques for business data analysis.
2. Use relevant quantitative techniques within Excel, with real data to create a focused industry/business analysis. Component 2: COURSEWORK
Summary of Assessment Method:
Assesses Learning Outcomes: 2
Individual written analysis (suitable for a web page) integrating applied quantitative analysis within Excel, real data and focused interpretation. (Maximum words 2,500 with additional evidence as reader notes, data and Excel analysis).
This assessment is an individual client report. You must analyse the data, provided by the Client in the CW2 Excel file. The file contains a sample of companies from the UK food and tobacco manufacturing. You must write a report using your analysis of the data provided, that meet the requirements of the Client as set out below. The data set for this assessment is in the CW2 Excel file in the CW2 folder, in the assessment section of Course Resources. You will also find some notes on the measurement of the variables used in a separate Word file. You are required to analyse the data provided using Excel only. You should use the results of your Excel analysis to create fit for purpose tables and charts, which must be embedded in the body of the report to support your discussion and analysis for the client.
You can submit before the deadline. You should write the report in Word and submit it via the Turnitin link in the Assessment section of Course Resources. Do not submit an Excel file. You will receive individual feedback as comments, summary comments and rubric comments on your report in Turnitin within 3 weeks of the submission date.
Assessment Content
Assessment Requirements
You must write an individual report analysing only the data provided. The data is real UK data from a specialist database. There are more than 5,000 food and tobacco manufacturers registered in the UK, but consistent data on the variables in this data set is only available for the sample you have in the
data set for the latest year available, 2020. The data includes measurements of performance, size, and other variables. The overall aim of your analysis is to help the client understand the UK food and tobacco manufacturing sector. The client is thinking about investing in this sector and wants you to analyse the available data provided in the Excel file. You should use your analysis to provide the client with a better understanding of the performance potential of different groups of companies in the sector. Your report must provide only the analysis that the client has requested, and your discussion must explain why the analysis might be relevant to the client as they think about investing in the sector. Your job is not to decide whether the client should invest or not, or to do financial analysis for the client. Your job is to provide the analysis that the client requests, and provide recommendations drawn directly from the analysis. Only use the data provided. Do not add new or additional data or information from other sources. Only use the techniques we have covered in the lectures. Do not use evidence or techniques that we have not covered in the lectures. You can only use EXCEL spreadsheet for your analysis that we have used in the lectures and/or computer labs.
Any evidence that students have colluded or copied each other or used the work of a source without reference and citation will be investigated and may result in a plagiarism investigation. If you use techniques we have not covered in the lectures, it will be treated as a major failure to meet the requirements of the CW2 brief.
The Client’s Requirements
The client is a business investor. This client has not invested in the UK food and tobacco manufacturing sector before. The client wants you to analyse the data they have provided and present the analysis as a business report of no more than 2,500 (excluding tables, charts, and appendices). The report should help the client in their aim to better understand company performance in the UK food and
tobacco manufacturing sector and how the information from this data set might be used when thinking about investing in the sector. The client has requested the following from you:
The client requires you to provide:
a) An analysis of the distribution of the profit rate across all companies in the data set.
b) An analysis of the distribution of the profit rate, comparing the large and SME (small & medium sized) firms in the data set.
c) An analysis of the distribution of the profit rate, comparing manufacturers in the data set by their export activity.
d) An analysis of the distribution of Return on Capital Employed comparing large and SME manufacturers in the data set.
e) An analysis of the export activity of the manufacturers in the data set against their size, measured by whether they are large or SME companies
f) An analysis of the extent to which the profit margin across all manufacturers in the data set is associated with the other quantitative variables in the data set.
g) An analysis of the extent to which the profit margin for manufacturers in the data set that can be predicted using the other quantitative variables in the data set.
1. In order to meet the client’s requirements, you MUST use all the following methods in
your analysis in the report:
a. Analysis of required variable distributions (using descriptive statistics and histograms) with appropriate explanations and comments on what your findings imply for the Client’s aim.
b. Hypothesis tests of the difference of means with appropriate explanation and comments on what the tests results imply in relation to the Client’s aim.
c. Cross tab analysis with appropriate probability pattern discussion, and associated Chi squared test with explanations of what the results imply in relation to the Client’s aim.
d. Correlation analysis with appropriate explanations of what the results imply in relation to the Client’s aim.
e. Bivariate regression analysis with appropriate explanations of what the results imply in relation to the Client’s aim. The regression output should be reported and the interpretation of the results is required.
Please include all EXCEL output in the appendix.
2. You must choose which techniques and variables to use for each of the client’s stated requirements.
3. Each part of the analysis must be explained. You must say why you chose the variables, why you chose the technique, give appropriate explanations of any results (any calculations should be put in the appendix and not in the body of the report). You need to ensure you interpret the results of techniques used but you do not need to explain calculations to the client. You must provide a full discussion of what your results mean for the client within each part of the analysis (not at the end of the report). Failure to do this will result in very low marks. Marks are mainly awarded for presenting and interpreting the output of Excel for the Client in terms of what it means, not for getting Excel to produce the output. For example, if you say the distribution is skewed, you need to show the evidence and explain why this might be of interest to the client in terms of their understanding performance in the UK food and tobacco manufacturing sector and the client’s plans to invest in the sector.
4. Any tables or charts used must be ‘fit for purpose’ – You must adapt the Excel tables and charts so that they meet the client needs and are fit for presentation in a formal business report. When you have done this, you can cut and paste them into the report. Any fit for purpose charts or tables should be put in the body of the report (not in the appendix) and every table and chart should be numbered, with titles, and have beneath it, a full explained and discussion saying what the table or chart shows and how this relates to the client’s aim.
The report must be set out as follows:
5. Write your analysis as a typed report with an appropriate title page, contents page, section headings, numbered and labelled figures and tables, and appendices. You do not need an Executive Summary.
6. You must provide an introduction to your report. Your introduction must state your overall aim and your objectives in order to meet the client’s requirements.
7. You must provide evidence in an appendix showing how you did the analysis and how your results were calculated. Normally this means providing a ‘screen shot’ of part of an excel sheet showing the Excel results. This evidence should be put in the appendix. Do not include a screen shot of all the data.
8. You must provide a conclusion with a summary of your results and recommendations. Your conclusion should summarise what you have already discussed in your analysis, and summarise your recommendations, which should already have been discussed within the analysis. Summarise your findings. Clearly state whether your analysis has met your objectives and why. If you think your report has some weakness, explain what it is and why. Your recommendations must be linked to your conclusions. You will gain marks for this type of critical review.
9. The word count (excluding tables and appendices) is a MAXIMUM OF 2,500 words for the whole report. This report can be well done in fewer than 2,500 words if well written and well focused. You should choose how many words are appropriate for each section in your report. You must provide a word count on the Front Page of the Report.
10. The word count (excluding tables and appendices) is a MAXIMUM OF 2,500 words for the whole report. This report can be well done in fewer than 2,500 words if well written and well-focused. You should choose how many words are appropriate for each section in your report. You must provide a word count on the Front Page of the Report. If you exceed the word limit you will lose marks as follows:
i. 10 marks deducted for exceeding the word limit by up to 250 words
ii. 20 marks deducted for exceeding the word limit by 251-500 words iii. 30 marks deducted for exceeding the word limit by 501-750 words iv. 50 marks deducted for exceeding the word limit by more than 750 words.
11. You should reference your sources. You are not required to read about the UK food and tobacco manufacturing sector. But you are expected to cite sources that relate to your
Excel analysis and statistical techniques. You should cite and reference all materials you use including lecture notes, web pages, on-line books, hard copy books, etc. A citation should be provided whenever you are using a statistical technique. These will include textbooks and web sites. Remember, the client may want to consult a source if they are not familiar with your technique, so a citation in a report can be used to guide the reader to some supporting material. References to sources must be provided using the Harvard method in the text of the report and all sources should be fully identified in a bibliography at the end of the report.
Sensitivity: Internal
2
Sensitivity: Internal
2
Sensitivity: Internal
Sheet1
| Profit Margin (%) | Number of employees | Salaries as a % of turnover | Return on Shareholder Funds (%) | Return on Capital Employed (%) | Cost of production (£) | Credit limit (£) | SME indicator 1=SME Size 0=Large | Exporter 2 = Domestic sales only 1 =Export Sales |
| 0.72 | 34 | 4.16 | 39.1 | 22.22 | 23741 | 5207 | 1 | 1 |
| -0.17 | 7 | 0.89 | -22.97 | -14.12 | 49951 | 6870 | 0 | 2 |
| 1.72 | 153 | 31.62 | 10.9 | 4.36 | 8067 | 7421 | 1 | 2 |
| 0.33 | 73 | 19.95 | 22.01 | 3.71 | 9182 | 8583 | 1 | 2 |
| 0.57 | 134 | 38.68 | 1.7 | 1.38 | 6261 | 9301 | 1 | 2 |
| -2.16 | 323 | 27.43 | -103.44 | -35.98 | 20874 | 9398 | 0 | 2 |
| -2.16 | 323 | 27.43 | -103.44 | -35.98 | 20874 | 9398 | 0 | 2 |
| 0.07 | 106 | 7.89 | 5.97 | 0.1 | 29244 | 11654 | 1 | 1 |
| 4.76 | 71 | 26.28 | 218.37 | 9.19 | 6330 | 12868 | 1 | 2 |
| -1.69 | 111 | 19.37 | -30.47 | -28.99 | 10020 | 14602 | 1 | 2 |
| 0.45 | 299 | 34.34 | 5.18 | 1.21 | 12787 | 15300 | 0 | 2 |
| 0.81 | 118 | 17.56 | 3.88 | 3.01 | 10863 | 15615 | 1 | 2 |
| -2.54 | 60 | 17.39 | -8.3 | -5.29 | 6573 | 16357 | 1 | 2 |
| 0.68 | 298 | 44.05 | 2.28 | 1.88 | 11305 | 17526 | 0 | 2 |
| 1.47 | 12 | 7.86 | 22.3 | 6.1 | 5170 | 18508 | 1 | 2 |
| -1.66 | 111 | 19.37 | -30.02 | -28.56 | 10020 | 19736 | 1 | 2 |
| -12.41 | 44 | 18.95 | -67.28 | -48.68 | 4795 | 20358 | 1 | 2 |
| -0.69 | 133 | 18.59 | -26.23 | -23.34 | 12558 | 21470 | 1 | 2 |
| -0.24 | 11 | 1.13 | -10.21 | -8.54 | 52623 | 21802 | 0 | 1 |
| 22.42 | 133 | 4.14 | 23.58 | 22.42 | 93290 | 14000000 | 0 | 1 |
| 1.31 | 693 | 5.07 | 3.18 | 2.4 | 1000000 | 15000000 | 0 | 1 |
| 26.14 | 1036 | 18.54 | 35.71 | 42.93 | 194949 | 15000000 | 0 | 1 |
| -1.38 | 3622 | 16.4 | -1.96 | -0.4 | 511600 | 16000000 | 0 | 1 |
| 3.97 | 1007 | 12.19 | 6.73 | 6.27 | 344400 | 20000000 | 0 | 1 |
| 54.24 | 264 | 9.34 | 17.18 | 16.97 | 91817 | 20000000 | 0 | 1 |
| 40.83 | 942 | 48.69 | 27.77 | 22.03 | 98700 | 21000000 | 0 | 1 |
| 7.87 | 4460 | 14.26 | 29.61 | 10.88 | 851600 | 21000000 | 0 | 1 |
| 16.16 | 228 | 16.4 | 16.92 | 15.75 | 109000 | 24000000 | 0 | 1 |
| 2.31 | 570 | 1.38 | 23.96 | 10.66 | 5300000 | 24000000 | 0 | 1 |
| 6.33 | 4155 | 19.94 | 3.19 | 4.57 | 549600 | 25000000 | 0 | 1 |
| 28.65 | 2526 | 18.23 | 34.81 | 11.59 | 518500 | 35000000 | 0 | 1 |
| 19.52 | 670 | 12.88 | 8.22 | 6.14 | 184325 | 38000000 | 0 | 1 |
| 72.82 | 128 | 4.36 | 21.76 | 19.57 | 111300 | 39000000 | 0 | 1 |
| 8.59 | 4255 | 19.6 | 4.3 | 3.84 | 573700 | 50000000 | 0 | 1 |
| 26.62 | 1649 | 10.84 | 8.1 | 5.81 | 387871 | 50000000 | 0 | 1 |
| 6.55 | 22200 | 15.6 | 11.54 | 4.6 | 6100000 | 50000000 | 0 | 1 |
| 23.03 | 3137 | 13.06 | 12.51 | 10.39 | 853000 | 50000000 | 0 | 1 |
| 6.27 | 3 | 10.2 | 20.25 | 19.87 | 1000000 | 50000000 | 0 | 1 |
| 17.38 | 27775 | 11.95 | 30.17 | 7.95 | 4700000 | 50000000 | 0 | 1 |
| 6.65 | 32100 | 3.33 | 44.47 | 11.37 | 26000000 | 50000000 | 0 | 1 |
| 2.5 | 4 | 5.59 | 29.44 | 29.44 | 3561 | 21809 | 1 | 2 |
| 9.15 | 72 | 29.62 | 13.78 | 13.51 | 4083 | 27346 | 1 | 2 |
| -0.66 | 44 | 8.94 | -13.81 | -13.53 | 24412 | 27685 | 1 | 1 |
| -1.31 | 113 | 24.16 | -14.76 | -13.44 | 8798 | 28179 | 1 | 2 |
| 0.99 | 207 | 21.97 | 8.36 | 6.08 | 24349 | 28186 | 1 | 1 |
| 1.53 | 135 | 27.59 | 266.83 | 136.98 | 4730 | 28303 | 1 | 2 |
| 3.24 | 37 | 8.15 | 7.63 | 4.52 | 9902 | 29273 | 1 | 2 |
| -5.03 | 692 | 16.8 | -29.16 | -18.92 | 59166 | 29927 | 0 | 1 |
| 0.33 | 73 | 19.87 | 6.16 | 2.59 | 9182 | 31508 | 1 | 2 |
| 1.23 | 354 | 34.1 | 20.84 | 11.38 | 15067 | 32861 | 0 | 2 |
| 3.85 | 5 | 0.41 | 26.94 | 26.94 | 5124 | 33246 | 1 | 2 |
| 0.85 | 137 | 19.83 | 15.72 | 1.13 | 13051 | 33258 | 1 | 2 |
| -0.21 | 40 | 6.96 | -0.45 | -0.41 | 15668 | 33808 | 1 | 2 |
| 0.65 | 66 | 11.82 | 44.43 | 44.43 | 24250 | 34682 | 1 | 1 |
| 3.37 | 136 | 17.91 | 17.27 | 4.79 | 19325 | 35245 | 1 | 1 |
| 9.6 | 24 | 11.03 | 44.68 | 40.55 | 5805 | 35880 | 1 | 2 |
| -11.69 | 177 | 10.36 | -233.77 | -215.98 | 51297 | 37559 | 0 | 1 |
| -0.86 | 81 | 5.02 | -9.24 | -8.78 | 36860 | 37719 | 1 | 1 |
| 0.39 | 184 | 34.36 | 3.62 | 3.29 | 8532 | 38867 | 1 | 2 |
| -12 | 341 | 30.23 | -49.44 | -49.44 | 48759 | 44532 | 0 | 1 |
| -2.74 | 41 | 10.77 | -19.19 | -18.54 | 6998 | 44669 | 1 | 2 |
| 1.34 | 137 | 23.44 | 11.17 | 10.99 | 11251 | 47352 | 1 | 2 |
| -0.26 | 56 | 8.28 | -2.87 | -1.28 | 11873 | 47439 | 1 | 2 |
| 3.17 | 156 | 22.78 | 321.13 | 60.96 | 10257 | 47847 | 1 | 2 |
| 4.08 | 13 | 7.84 | 25.96 | 10.75 | 5233 | 50253 | 1 | 2 |
| -9.55 | 60 | 18.26 | -47.05 | -47.05 | 7169 | 51443 | 1 | 2 |
| 5.47 | 15 | 9.57 | 15.48 | 15.17 | 3799 | 53160 | 1 | 2 |
| 1.24 | 162 | 16.41 | 42.78 | 29.07 | 23012 | 56112 | 1 | 1 |
| 8.27 | 49 | 11.55 | 21.79 | 21.79 | 6764 | 56916 | 1 | 2 |
| 0.01 | 119 | 12.75 | 0.03 | 0.02 | 20446 | 60121 | 1 | 1 |
| 1.95 | 62 | 5.63 | 31.53 | 29.69 | 48809 | 62397 | 0 | 1 |
| -1.34 | 68 | 16.78 | -7.04 | -7.04 | 8739 | 62959 | 1 | 2 |
| 8.46 | 165 | 36.58 | 17.69 | 17.69 | 8135 | 63925 | 1 | 2 |
| 2.6 | 52 | 19.07 | 99.43 | 91.36 | 13789 | 64297 | 1 | 2 |
| -0.44 | 92 | 8.45 | -4.73 | -3.87 | 38226 | 64936 | 1 | 1 |
| 1.08 | 301 | 27 | 14.75 | 4.69 | 22879 | 65092 | 0 | 2 |
| 0.77 | 4 | 2.97 | 89.7 | 84.86 | 21401 | 65097 | 1 | 1 |
| 1.32 | 90 | 9.38 | 18.29 | 12.4 | 13236 | 65238 | 1 | 2 |
| 1.15 | 135 | 24.32 | 13.18 | 8.65 | 14933 | 65247 | 1 | 2 |
| 4.65 | 149 | 12.05 | 46.3 | 24.44 | 28877 | 65690 | 1 | 1 |
| 1.87 | 32 | 6.65 | 21.38 | 12.99 | 14087 | 66249 | 1 | 2 |
| -7.47 | 95 | 32.74 | -31.81 | -30.17 | 6210 | 66977 | 1 | 2 |
| -1.8 | 162 | 20.92 | -25.11 | -17.29 | 15484 | 67476 | 1 | 2 |
| -2.39 | 66 | 23.9 | -13.82 | -13.82 | 8226 | 69185 | 1 | 2 |
| 8.05 | 49 | 10.27 | 13.93 | 13.84 | 11773 | 69415 | 1 | 2 |
| 2.33 | 13 | 4.07 | 27.09 | 12.85 | 13008 | 70913 | 1 | 2 |
| -0.38 | 84 | 19.02 | -2.11 | -1.62 | 11054 | 72877 | 1 | 2 |
| 2.3 | 199 | 30.64 | 30.45 | 19.01 | 14338 | 73438 | 1 | 2 |
| 0.46 | 78 | 14.04 | 51.67 | 3.47 | 20783 | 73844 | 1 | 1 |
| 0.96 | 159 | 16.91 | 2.58 | 2.48 | 18185 | 74613 | 1 | 2 |
| 2.04 | 140 | 20.5 | 40.12 | 14.04 | 12169 | 75371 | 1 | 2 |
| 0.04 | 46 | 11.55 | 0.38 | 0.37 | 13944 | 75535 | 1 | 2 |
| 0.9 | 20 | 5.95 | 19.3 | 10.45 | 13949 | 76103 | 1 | 2 |
| -1.14 | 54 | 17.77 | -3.82 | -3.51 | 7936 | 76283 | 1 | 2 |
| -5.46 | 82 | 32.99 | -17.62 | -11.4 | 6646 | 76861 | 1 | 2 |
| 2.89 | 74 | 14.6 | 133.87 | 130.57 | 13009 | 78000 | 1 | 2 |
| 0.51 | 109 | 29.66 | 2.1 | 1.66 | 8178 | 79432 | 1 | 2 |
| -1.18 | 135 | 24.32 | -9.63 | -6.19 | 14933 | 80034 | 1 | 2 |
| 1.63 | 254 | 42.5 | 382.4 | 82.74 | 10023 | 80543 | 1 | 2 |
| 0.39 | 53 | 9.77 | 4.14 | 1.74 | 19331 | 81246 | 1 | 2 |
| 1.42 | 71 | 18.3 | 38.62 | 25.7 | 8162 | 81948 | 1 | 2 |
| 1.59 | 72 | 11.31 | 24.42 | 13.13 | 11293 | 85356 | 1 | 2 |
| 2.51 | 82 | 19.24 | 22.87 | 16.2 | 9973 | 86720 | 1 | 2 |
| 1.17 | 97 | 19.68 | 8.1 | 7.72 | 20575 | 86756 | 1 | 1 |
| -3.11 | 78 | 21.52 | -13.46 | -13.46 | 6647 | 90772 | 1 | 2 |
| 1.09 | 68 | 14.45 | 6.73 | 5.61 | 14445 | 91060 | 1 | 2 |
| -4.53 | 343 | 47.55 | -32.43 | -24 | 13283 | 93233 | 0 | 2 |
| -5.94 | 14 | 3.68 | -46.59 | -46.59 | 16285 | 93764 | 1 | 2 |
| -0.82 | 42 | 9.78 | -4.28 | -3.79 | 11646 | 98153 | 1 | 2 |
| 1.57 | 12 | 4.35 | 7.83 | 6.27 | 15343 | 99105 | 1 | 2 |
| 1.06 | 121 | 16.84 | 7.48 | 5.77 | 16970 | 101506 | 1 | 2 |
| -2.51 | 130 | 14.9 | -14.11 | -13.07 | 6725 | 102697 | 1 | 2 |
| -1.64 | 82 | 24 | -5.3 | -5.3 | 7504 | 103126 | 1 | 2 |
| -0.48 | 9 | 1.59 | -40.86 | -2.59 | 24995 | 103589 | 1 | 1 |
| 1.18 | 248 | 8.33 | 17.93 | 14.02 | 61349 | 105655 | 0 | 1 |
| 1.98 | 88 | 5.29 | 23.36 | 5.32 | 22011 | 106459 | 1 | 1 |
| 1.71 | 59 | 10.13 | 12.65 | 11.76 | 14332 | 106594 | 1 | 2 |
| -1.49 | 64 | 11.25 | -7.57 | -7.57 | 12261 | 107215 | 1 | 2 |
| 1.24 | 55 | 19.12 | 4.39 | 4.31 | 6244 | 108996 | 1 | 2 |
| 13.84 | 34 | 6.24 | 24.23 | 24.23 | 7474 | 110136 | 1 | 2 |
| 4.92 | 28 | 14.99 | 14.33 | 11.81 | 7748 | 112524 | 1 | 2 |
| 0.85 | 64 | 4.03 | 14.74 | 12.06 | 40732 | 112769 | 0 | 2 |
| 0.29 | 94 | 7.46 | 3.01 | 2.65 | 32349 | 112791 | 1 | 1 |
| -3.4 | 102 | 43.81 | -5.77 | -5.51 | 4598 | 113629 | 1 | 2 |
| 5.68 | 48 | 19.01 | 27.06 | 20.05 | 6511 | 114023 | 1 | 2 |
| -3.61 | 305 | 22.81 | -42.22 | -18.63 | 40200 | 115430 | 0 | 1 |
| 5.44 | 97 | 16.57 | 58.07 | 30.14 | 8815 | 115962 | 1 | 2 |
| 0.34 | 177 | 15.14 | 3.9 | 3.82 | 25874 | 117702 | 1 | 1 |
| -26.26 | 77 | 10.06 | -159.27 | -154.45 | 28315 | 117864 | 1 | 1 |
| -1.09 | 82 | 17.14 | -5.08 | -2.84 | 11679 | 119209 | 1 | 2 |
| 1.31 | 301 | 21.75 | 14.2 | 8.13 | 32355 | 120451 | 0 | 2 |
| 0.82 | 24 | 3.58 | 8.15 | 7.87 | 27340 | 120589 | 1 | 1 |
| -0.96 | 163 | 24.12 | -4.9 | -3.3 | 12735 | 121363 | 1 | 2 |
| 13.57 | 190 | 25.09 | 16.12 | 15.97 | 10626 | 121577 | 1 | 2 |
| -7.17 | 692 | 30.07 | -97.19 | -71.94 | 50049 | 121851 | 0 | 1 |
| 3.72 | 74 | 16.15 | 20.11 | 11.2 | 10504 | 122371 | 1 | 2 |
| -0.14 | 51 | 20.51 | -0.44 | -0.4 | 7152 | 122839 | 1 | 2 |
| 3.72 | 74 | 16.15 | 20.88 | 11.43 | 10504 | 123240 | 1 | 2 |
| 0.78 | 354 | 34.1 | 4.68 | 3.62 | 15067 | 123764 | 0 | 2 |
| 5.41 | 102 | 17.43 | 27.64 | 5.01 | 8145 | 125234 | 1 | 2 |
| 3.46 | 157 | 14.22 | 81.77 | 72.03 | 15532 | 125352 | 0 | 2 |
| 8.6 | 13 | 7.84 | 92.57 | 92.57 | 5233 | 127408 | 1 | 2 |
| 2.87 | 219 | 35.58 | 10.11 | 6.3 | 7614 | 128560 | 1 | 2 |
| 0.79 | 15 | 4.28 | 5.55 | 5.4 | 19858 | 130847 | 1 | 2 |
| 0.11 | 88 | 12.76 | 0.45 | 0.4 | 12930 | 130927 | 1 | 2 |
| -32.09 | 49 | 23.42 | -37.87 | -23.78 | 5125 | 132089 | 1 | 2 |
| -0.39 | 53 | 7.63 | -2.36 | -1.91 | 23153 | 132594 | 1 | 1 |
| -9.1 | 145 | 19.64 | -40.35 | -28.52 | 13809 | 133692 | 1 | 2 |
| 0.79 | 85 | 19.52 | 29.74 | 5.95 | 9457 | 133758 | 1 | 2 |
| 4.63 | 20 | 10.68 | 26.78 | 26.27 | 11679 | 135417 | 1 | 2 |
| -2.04 | 58 | 11.44 | -7.31 | -6.14 | 17686 | 136593 | 1 | 2 |
| -0.3 | 70 | 7.25 | -3.26 | -2.16 | 26314 | 137414 | 1 | 1 |
| 8.33 | 246 | 54.45 | 42.58 | 14.58 | 6050 | 137599 | 1 | 2 |
| 2.8 | 78 | 15.05 | 23.09 | 14.48 | 11863 | 137827 | 1 | 2 |
| -0.79 | 165 | 20.42 | -3.14 | -2.37 | 19234 | 138620 | 1 | 2 |
| 0.8 | 152 | 24.91 | 6.59 | 3.46 | 8963 | 138920 | 1 | 2 |
| 0.85 | 41 | 7.84 | 5.58 | 5.58 | 20814 | 139477 | 1 | 1 |
| 1.96 | 95 | 4.97 | 24.78 | 22.79 | 36551 | 139996 | 1 | 1 |
| 1.24 | 99 | 23.35 | 15.35 | 5.73 | 10231 | 140834 | 1 | 2 |
| -5.97 | 264 | 31.33 | -21.45 | -9.69 | 19751 | 142914 | 0 | 2 |
| 2.43 | 104 | 6.5 | 43.89 | 35.31 | 23408 | 144955 | 1 | 1 |
| 1.23 | 125 | 33.15 | 2.04 | 1.5 | 5144 | 145434 | 1 | 2 |
| -1.37 | 107 | 33.24 | -3.2 | -2.69 | 8618 | 145499 | 1 | 2 |
| 2.96 | 115 | 11.96 | 41.98 | 28.5 | 18872 | 145745 | 1 | 1 |
| -8.07 | 55 | 11.15 | -77.66 | -71.91 | 22804 | 146130 | 1 | 1 |
| 2.06 | 353 | 41.58 | 12.28 | 9.59 | 19325 | 146382 | 0 | 2 |
| -33.91 | 726 | 39.2 | -20.97 | -8.78 | 40279 | 147381 | 0 | 2 |
| 2.35 | 104 | 6.5 | 31.62 | 26.79 | 23408 | 149151 | 1 | 1 |
| 2.14 | 64 | 13.69 | 8.32 | 7.65 | 14332 | 149983 | 1 | 2 |
| 2.79 | 603 | 34.97 | 3.76 | 2.52 | 9447 | 150169 | 0 | 2 |
| 3.3 | 259 | 30.63 | 29.47 | 18.91 | 16919 | 151025 | 0 | 2 |
| 3.09 | 147 | 38.81 | 22.82 | 16.47 | 5968 | 152649 | 1 | 2 |
| 0.81 | 118 | 17.56 | 4.02 | 3.1 | 10863 | 152773 | 1 | 2 |
| -0.76 | 192 | 19.25 | -4.15 | -3.99 | 20027 | 154085 | 1 | 1 |
| -4.44 | 267 | 21.52 | -32.08 | -28.71 | 28316 | 154263 | 0 | 2 |
| 1.58 | 128 | 25.07 | 14.1 | 11.1 | 9540 | 155457 | 1 | 2 |
| 2.96 | 61 | 10.59 | 21.01 | 20.71 | 13540 | 156101 | 1 | 2 |
| 1.35 | 460 | 28.15 | 11.26 | 11.26 | 30229 | 156421 | 0 | 2 |
| 5.53 | 293 | 36.19 | 25.14 | 23.44 | 6708 | 156722 | 0 | 2 |
| 2.2 | 141 | 15.9 | 27.51 | 26.71 | 28061 | 156762 | 1 | 1 |
| 1.59 | 138 | 8.38 | 16.4 | 16.31 | 43609 | 158102 | 1 | 1 |
| 2.16 | 40 | 10.49 | 11.06 | 10.36 | 17710 | 160092 | 1 | 2 |
| 2.07 | 129 | 23.81 | 10.71 | 9.34 | 6657 | 160842 | 1 | 2 |
| 0.81 | 50 | 1.32 | 370.03 | 370.03 | 136857 | 162546 | 0 | 1 |
| 4.75 | 11 | 3.36 | 12.71 | 12.71 | 10635 | 162821 | 1 | 2 |
| 2.76 | 204 | 12.49 | 13.67 | 11.3 | 27649 | 165429 | 1 | 1 |
| 4.37 | 74 | 17.41 | 14.79 | 8.13 | 9720 | 166414 | 1 | 2 |
| -1.76 | 102 | 32.09 | -4.48 | -3.66 | 7877 | 166430 | 1 | 2 |
| 3.26 | 140 | 16.67 | 24.57 | 3.6 | 25515 | 166567 | 1 | 1 |
| 2.65 | 62 | 13.22 | 28.84 | 14.56 | 12485 | 167123 | 1 | 2 |
| 2.44 | 153 | 15.63 | 9.57 | 8.89 | 17455 | 171830 | 1 | 2 |
| 4.2 | 477 | 48.2 | 70.88 | 21.49 | 19995 | 172942 | 0 | 2 |
| 1.93 | 30 | 10.01 | 16.17 | 9.23 | 10977 | 174941 | 1 | 2 |
| 0.46 | 108 | 10.65 | 8.43 | 6.27 | 35873 | 176118 | 1 | 1 |
| 13.67 | 179 | 33.34 | 39.79 | 39.68 | 6505 | 177865 | 1 | 2 |
| 5.61 | 66 | 2.09 | 47.81 | 42.74 | 13966 | 179160 | 1 | 2 |
| -6.58 | 30 | 22.93 | -16.51 | -11.05 | 4166 | 179718 | 1 | 2 |
| 1.68 | 67 | 6.37 | 11.08 | 10.93 | 24757 | 181435 | 1 | 1 |
| 4.63 | 15 | 5.84 | 10.56 | 9.58 | 7813 | 182400 | 1 | 2 |
| 0.67 | 58 | 11.44 | 2.82 | 2.74 | 17686 | 184135 | 1 | 2 |
| 10.37 | 246 | 54.45 | 15.08 | 14.57 | 6050 | 185705 | 1 | 2 |
| 5.08 | 71 | 26.28 | 8.89 | 8.55 | 6330 | 186193 | 1 | 2 |
| 1.29 | 56 | 22.99 | 2.72 | 2.22 | 4053 | 188313 | 1 | 2 |
| -0.78 | 306 | 5.95 | -16.78 | -14.34 | 182824 | 188848 | 0 | 1 |
| 2.52 | 186 | 19.34 | 13.74 | 13.25 | 19502 | 192878 | 1 | 1 |
| 4.63 | 15 | 5.84 | 10.56 | 9.58 | 7813 | 192883 | 1 | 2 |
| 0.02 | 115 | 17.79 | 0.08 | 0.05 | 13812 | 193294 | 1 | 2 |
| 0.43 | 85 | 11.07 | 2.52 | 2.44 | 26742 | 194565 | 1 | 1 |
| 1.04 | 90 | 28.56 | 3 | 1.95 | 5514 | 196095 | 1 | 2 |
| 1.1 | 125 | 35.34 | 1.79 | 1.44 | 5280 | 196813 | 1 | 2 |
| 1.63 | 83 | 12.08 | 7.99 | 5.39 | 17831 | 196973 | 1 | 1 |
| 5.26 | 52 | 13.93 | 33.71 | 32.46 | 12738 | 197116 | 1 | 2 |
| 1.74 | 179 | 8.17 | 6.58 | 5.72 | 57903 | 197172 | 0 | 1 |
| 10.99 | 71 | 38.83 | 22.65 | 22.46 | 5840 | 198600 | 1 | 2 |
| 2.98 | 80 | 9.77 | 18.51 | 15.39 | 18896 | 199419 | 1 | 2 |
| 3.94 | 43 | 8.25 | 17.49 | 16.41 | 16906 | 202564 | 1 | 2 |
| -5.62 | 36 | 4.3 | -35.08 | -10.99 | 35862 | 202958 | 1 | 1 |
| 3.26 | 84 | 10.44 | 9.35 | 7.85 | 17822 | 207825 | 1 | 2 |
| 1.43 | 39 | 4.95 | 9.03 | 6.88 | 25083 | 209618 | 1 | 1 |
| 3.51 | 215 | 23.14 | 60.41 | 49.29 | 17762 | 211128 | 1 | 1 |
| 3.55 | 81 | 10.25 | 14.77 | 14.77 | 17602 | 211417 | 1 | 2 |
| 7.8 | 67 | 16.05 | 23.99 | 22.65 | 8263 | 213255 | 1 | 2 |
| 2.19 | 56 | 10.65 | 5.38 | 5.37 | 10095 | 216709 | 1 | 2 |
| 5.68 | 116 | 20.23 | 24.11 | 15.16 | 11235 | 218454 | 1 | 2 |
| 0.34 | 675 | 22.81 | 4.77 | 1.37 | 89475 | 218466 | 0 | 1 |
| 5.07 | 4 | 1.24 | 435.79 | 435.79 | 23511 | 221117 | 1 | 1 |
| 2.91 | 98 | 10.89 | 13.31 | 13.17 | 22156 | 222716 | 1 | 1 |
| 4.24 | 275 | 16.52 | 13.09 | 12.83 | 43098 | 223230 | 0 | 1 |
| 0.47 | 110 | 15.68 | 3.58 | 3.49 | 19305 | 223315 | 1 | 2 |
| 3.76 | 251 | 27.63 | 18.85 | 18.01 | 14983 | 224499 | 0 | 2 |
| 1.09 | 143 | 4.55 | 17.19 | 14.82 | 82744 | 225523 | 0 | 1 |
| -1.34 | 311 | 36.89 | -34.8 | -11.34 | 17047 | 226221 | 0 | 2 |
| 4.61 | 157 | 23.76 | 48.71 | 38.84 | 14842 | 226375 | 1 | 2 |
| 19.99 | 16 | 8.98 | 23.39 | 23.36 | 3290 | 226747 | 1 | 2 |
| -0.44 | 92 | 8.45 | -1.96 | -1.79 | 38226 | 226812 | 1 | 1 |
| -6.33 | 121 | 32.25 | -14.86 | -9.64 | 9113 | 227242 | 1 | 2 |
| 3.95 | 215 | 23.12 | 37.2 | 27.19 | 17762 | 228030 | 1 | 1 |
| 6.83 | 82 | 13.62 | 18.8 | 18.74 | 12831 | 228057 | 1 | 2 |
| 4.51 | 58 | 22.94 | 4.26 | 3.9 | 5039 | 228348 | 1 | 2 |
| -0.86 | 336 | 45.45 | -1.95 | -1.67 | 9472 | 231426 | 0 | 2 |
| -3.53 | 33 | 11.78 | -3.71 | -3.19 | 5621 | 231859 | 1 | 2 |
| -4.77 | 182 | 27.6 | -4.42 | -4.42 | 29616 | 232103 | 1 | 1 |
| 6.88 | 105 | 26.2 | 16.68 | 15.53 | 10722 | 232467 | 1 | 2 |
| 4.64 | 236 | 24.48 | 20.59 | 13.86 | 13026 | 233493 | 1 | 2 |
| 3.7 | 151 | 14.91 | 72.96 | 72.96 | 25924 | 234429 | 1 | 1 |
| 3.89 | 130 | 16.9 | 33.91 | 18.72 | 22149 | 235219 | 1 | 1 |
| 4.42 | 333 | 33.62 | 142.73 | 67.59 | 23316 | 237180 | 0 | 2 |
| 3.82 | 61 | 4.4 | 30.18 | 16.78 | 21893 | 237469 | 1 | 1 |
| 1.83 | 126 | 25.28 | 6.45 | 6.08 | 15825 | 238611 | 1 | 2 |
| -7.99 | 9 | 5.39 | -10.95 | -10.95 | 8146 | 242301 | 1 | 2 |
| -4.51 | 103 | 17.84 | -11.33 | -10.38 | 13327 | 244656 | 1 | 2 |
| 4.23 | 23 | 4.1 | 14.18 | 11.07 | 21352 | 245444 | 1 | 1 |
| 4.23 | 29 | 8.12 | 18.81 | 15.53 | 22584 | 245964 | 1 | 1 |
| 1.48 | 55 | 10.03 | 5.94 | 5.75 | 19343 | 246916 | 1 | 2 |
| 0.43 | 178 | 50.83 | 0.69 | 0.57 | 6211 | 247027 | 1 | 2 |
| 2.11 | 53 | 6.75 | 17.96 | 15.11 | 27398 | 247050 | 1 | 1 |
| 4.15 | 83 | 23.31 | 8.31 | 8.06 | 8469 | 247117 | 1 | 2 |
| 2.31 | 215 | 10.28 | 10.62 | 7.9 | 39593 | 248151 | 0 | 2 |
| 2.44 | 153 | 15.63 | 8.93 | 8.33 | 17455 | 249686 | 1 | 2 |
| 27.1 | 239 | 32.73 | 121.53 | 121.2 | 6594 | 249805 | 1 | 2 |
| -8.69 | 65 | 17.95 | -76.53 | -51.52 | 14814 | 250128 | 1 | 2 |
| 6.89 | 164 | 25.27 | 24.08 | 20.47 | 10981 | 250845 | 1 | 2 |
| 4.99 | 178 | 33.59 | 11.65 | 10.37 | 8706 | 251090 | 1 | 2 |
| 16.63 | 281 | 23.56 | 30.71 | 29.29 | 16705 | 253057 | 0 | 2 |
| 11.5 | 13 | 6.01 | 28.54 | 28.54 | 6673 | 253060 | 1 | 2 |
| 4.7 | 68 | 28.24 | 4.09 | 4 | 4370 | 255567 | 1 | 2 |
| 3.15 | 256 | 17.28 | 21.04 | 13.97 | 34012 | 258761 | 0 | 2 |
| 1.84 | 162 | 38.77 | 3 | 2.92 | 7196 | 259121 | 1 | 2 |
| 9.31 | 40 | 6.3 | 32.66 | 32.08 | 13044 | 259537 | 1 | 2 |
| 2.37 | 107 | 11.59 | 10 | 9.41 | 25632 | 259635 | 1 | 1 |
| 3.12 | 76 | 6.56 | 18.48 | 17.33 | 27620 | 260374 | 1 | 1 |
| 23.3 | 6 | 2.99 | 55.16 | 55.16 | 5001 | 260995 | 1 | 2 |
| 6.02 | 67 | 8.64 | 16.63 | 16.5 | 13648 | 262231 | 1 | 2 |
| -1.23 | 265 | 23.43 | -6.52 | -6.51 | 17903 | 263064 | 0 | 2 |
| 2.46 | 107 | 11.71 | 13.82 | 12.81 | 25614 | 263149 | 1 | 1 |
| 1.38 | 6 | 0.45 | 31.27 | 31.21 | 33519 | 263558 | 1 | 1 |
| 0.24 | 91 | 11.85 | 1.23 | 1.08 | 27918 | 264363 | 1 | 1 |
| 7.95 | 65 | 13.92 | 22.93 | 21.91 | 10999 | 264806 | 1 | 2 |
| 5.3 | 13 | 3.01 | 31.74 | 27.09 | 19949 | 265884 | 1 | 2 |
| 23.94 | 6 | 2.71 | 61.11 | 60.98 | 4274 | 266446 | 1 | 2 |
| 11.1 | 77 | 23.64 | 21.15 | 18.65 | 5821 | 268083 | 1 | 2 |
| 6.88 | 105 | 26.2 | 16.68 | 15.53 | 10722 | 269548 | 1 | 2 |
| 3.63 | 322 | 33.87 | 11.9 | 10.58 | 16757 | 269628 | 0 | 2 |
| 1.24 | 301 | 22.03 | 15.57 | 7.96 | 32355 | 270173 | 0 | 2 |
| 2.48 | 101 | 5.08 | 29.75 | 29.32 | 42555 | 270509 | 1 | 1 |
| -4.48 | 185 | 18.83 | -18.89 | -9.53 | 18373 | 271372 | 1 | 1 |
| 4.04 | 39 | 4.95 | 15.72 | 13.17 | 24232 | 275180 | 1 | 1 |
| -0.38 | 97 | 5.37 | -4.08 | -4.01 | 56778 | 275452 | 0 | 1 |
| 5.63 | 181 | 26.67 | 50.41 | 38.34 | 12624 | 277118 | 1 | 2 |
| 3.73 | 23 | 12.8 | 4.24 | 4.24 | 6011 | 277890 | 1 | 2 |
| -8 | 82 | 21.7 | -9.37 | -7.49 | 6222 | 277950 | 1 | 2 |
| 0.86 | 223 | 8.89 | 19.32 | 17.03 | 59186 | 278031 | 0 | 1 |
| 0.65 | 209 | 33.14 | 1.51 | 1.48 | 11199 | 278682 | 1 | 2 |
| 0.33 | 227 | 12.9 | 1.7 | 1.7 | 35210 | 279476 | 0 | 2 |
| 7.49 | 109 | 18.43 | 50.48 | 46.29 | 11987 | 279487 | 1 | 2 |
| 2.18 | 172 | 11.68 | 16.11 | 11 | 39518 | 281819 | 0 | 1 |
| 5.42 | 24 | 3.8 | 24.12 | 22.32 | 18046 | 283677 | 1 | 2 |
| 0.36 | 209 | 33.14 | 0.63 | 0.62 | 11199 | 283791 | 1 | 2 |
| 4.28 | 33 | 12.62 | 7.48 | 6.62 | 9548 | 284720 | 1 | 2 |
| 0.92 | 198 | 31.27 | 0.8 | 0.79 | 15155 | 284876 | 1 | 2 |
| 5.63 | 77 | 11.08 | 17.23 | 14.63 | 15068 | 290043 | 1 | 2 |
| -5.77 | 264 | 31.33 | -16.1 | -9.37 | 19751 | 297689 | 0 | 2 |
| 7.2 | 109 | 24.28 | 12.69 | 11.11 | 5840 | 300181 | 1 | 2 |
| 2.9 | 39 | 9.2 | 5.85 | 5.74 | 12771 | 300565 | 1 | 2 |
| 9.38 | 100 | 25.29 | 17.33 | 17.23 | 10575 | 301856 | 1 | 2 |
| 5.54 | 43 | 3.59 | 24.07 | 23.44 | 21428 | 302205 | 1 | 1 |
| 4.15 | 166 | 11.44 | 21.35 | 17.58 | 27288 | 302308 | 1 | 1 |
| 3.03 | 137 | 14.26 | 21.66 | 14.48 | 25831 | 302425 | 1 | 1 |
| 7.4 | 180 | 28.43 | 14.45 | 8.49 | 11992 | 302953 | 1 | 2 |
| 9.53 | 114 | 19.78 | 72.97 | 51.41 | 9851 | 303254 | 1 | 2 |
| 9.34 | 83 | 15.24 | 23.12 | 22.52 | 9842 | 304606 | 1 | 2 |
| 6.87 | 69 | 15.98 | 17.02 | 7.52 | 9795 | 304947 | 1 | 2 |
| 1.83 | 97 | 16.57 | 3.37 | 2.96 | 8815 | 307765 | 1 | 2 |
| 3.78 | 163 | 13.75 | 28.11 | 21.08 | 30163 | 310302 | 1 | 1 |
| 4.89 | 271 | 12.73 | 17.92 | 16.58 | 79635 | 311294 | 0 | 1 |
| 14.09 | 74 | 17.01 | 253.13 | 178.2 | 9322 | 311650 | 1 | 2 |
| 21.36 | 59 | 29.99 | 31.98 | 31.13 | 3565 | 316235 | 1 | 2 |
| 8.43 | 61 | 14.57 | 27.05 | 26.63 | 7464 | 316596 | 1 | 2 |
| 2.2 | 124 | 5.37 | 17.91 | 16.21 | 48733 | 316969 | 0 | 1 |
| 2.53 | 217 | 22.76 | 9.02 | 7.59 | 22971 | 317317 | 1 | 1 |
| 8.3 | 74 | 14.92 | 20.97 | 16.45 | 13480 | 319357 | 1 | 2 |
| 6.39 | 82 | 8.3 | 45.1 | 43.07 | 19635 | 319953 | 1 | 2 |
| 3.82 | 24 | 5.32 | 34.98 | 34.94 | 34916 | 321042 | 1 | 1 |
| 0.73 | 235 | 11.45 | 5.95 | 4.61 | 42091 | 323438 | 0 | 1 |
| 5.7 | 22 | 7.22 | 11.52 | 11 | 14591 | 326204 | 1 | 2 |
| 0.8 | 69 | 5.14 | 5.13 | 3.64 | 43134 | 327087 | 0 | 2 |
| 2.67 | 127 | 6.2 | 22.58 | 20.96 | 44302 | 328583 | 0 | 2 |
| 0.72 | 145 | 6.23 | 7.48 | 3.3 | 74182 | 329014 | 0 | 1 |
| 13.78 | 5 | 1.02 | 88.8 | 88.4 | 10191 | 329604 | 1 | 2 |
| 0.97 | 86 | 6 | 4.87 | 3.71 | 43595 | 332074 | 0 | 2 |
| 5.71 | 151 | 20.03 | 30.66 | 29.82 | 14638 | 332626 | 1 | 2 |
| 4.39 | 29 | 4.29 | 15.02 | 14.44 | 22313 | 333187 | 1 | 1 |
| 9.85 | 69 | 16.23 | 28.97 | 11.48 | 9604 | 333259 | 1 | 2 |
| 9.44 | 74 | 13.84 | 28.78 | 25.14 | 11765 | 334079 | 1 | 2 |
| -0.03 | 13 | 2.03 | -0.16 | -0.16 | 19089 | 336228 | 1 | 2 |
| 9.22 | 161 | 30.01 | 25.51 | 39.21 | 10600 | 340111 | 1 | 2 |
| 4.23 | 90 | 9.72 | 20.37 | 14.23 | 33031 | 340954 | 1 | 1 |
| 1.61 | 508 | 11.15 | 518.35 | 518.35 | 107273 | 341487 | 0 | 1 |
| 11.33 | 10 | 2.85 | 28.78 | 28.61 | 10710 | 341862 | 1 | 2 |
| 0.98 | 1522 | 18.59 | 5.61 | 5.58 | 180674 | 342526 | 0 | 1 |
| 8.25 | 162 | 15.28 | 33.83 | 32.3 | 10634 | 344231 | 1 | 2 |
| 7 | 56 | 13.73 | 9.53 | 8.52 | 8541 | 345575 | 1 | 2 |
| 4.97 | 61 | 8.57 | 16.83 | 14.88 | 17620 | 346208 | 1 | 1 |
| 6.53 | 111 | 13.91 | 43.82 | 41.3 | 14735 | 346299 | 1 | 1 |
| -1.42 | 56 | 10.78 | -9.52 | -8.72 | 22309 | 347913 | 1 | 1 |
| 5.94 | 137 | 7.85 | 15.05 | 15.01 | 66922 | 347972 | 0 | 1 |
| 3.59 | 106 | 16.3 | 10.68 | 10.61 | 22488 | 348076 | 1 | 1 |
| 18.82 | 77 | 18.7 | 54.9 | 48.11 | 8444 | 350151 | 1 | 2 |
| 5.94 | 70 | 14.06 | 10.52 | 5.93 | 8600 | 352010 | 1 | 2 |
| 3.55 | 23 | 2.98 | 25.43 | 20.75 | 22822 | 352396 | 1 | 1 |
| 1.53 | 63 | 7.82 | 6.58 | 6.3 | 24182 | 353540 | 1 | 1 |
| 4.77 | 183 | 25.04 | 12.13 | 10.59 | 15839 | 354839 | 1 | 2 |
| 15.96 | 30 | 19.42 | 25.97 | 25.84 | 6011 | 357075 | 1 | 2 |
| 5.05 | 90 | 10.55 | 26.95 | 26.95 | 35837 | 367254 | 0 | 2 |
| -7.81 | 471 | 31.97 | -27.65 | -26.41 | 31613 | 368107 | 0 | 2 |
| 2.84 | 124 | 6.95 | 13.66 | 13.38 | 34662 | 368411 | 1 | 1 |
| 0.32 | 352 | 17.53 | 3.72 | 2.82 | 64308 | 369997 | 0 | 1 |
| 8.3 | 74 | 14.92 | 16.45 | 16.09 | 13480 | 375545 | 1 | 2 |
| 10.04 | 45 | 8.88 | 15.73 | 15.15 | 9906 | 376488 | 1 | 2 |
| 0.95 | 74 | 33.75 | 0.68 | 0.68 | 4379 | 377272 | 1 | 2 |
| 2.72 | 257 | 13.72 | 16.31 | 12.97 | 45811 | 377783 | 0 | 1 |
| 3.7 | 278 | 23.72 | 110.1 | 110.1 | 45934 | 377894 | 0 | 1 |
| 3.14 | 83 | 13.04 | 11.05 | 8.54 | 21234 | 378386 | 1 | 2 |
| 5.08 | 185 | 19.18 | 29.54 | 29.04 | 18984 | 378450 | 1 | 1 |
| 1.49 | 306 | 16.28 | 7.87 | 6.64 | 55314 | 380031 | 0 | 1 |
| 6.59 | 48 | 5.91 | 26.6 | 26.21 | 23699 | 381122 | 1 | 1 |
| 8.08 | 149 | 20.02 | 18.36 | 17.05 | 12157 | 381632 | 1 | 2 |
| 5.81 | 325 | 33.35 | 117.48 | 42.2 | 23550 | 383575 | 0 | 2 |
| -6.81 | 97 | 24.78 | -4.64 | -4.47 | 6401 | 390986 | 1 | 2 |
| 9.52 | 33 | 13.42 | 21.92 | 21.57 | 11736 | 392162 | 1 | 2 |
| 0.49 | 163 | 16.15 | 1.54 | 1.51 | 28756 | 393491 | 1 | 1 |
| 4.07 | 130 | 9.07 | 13.03 | 12.36 | 33233 | 396089 | 1 | 1 |
| 6.16 | 11 | 5.67 | 6.23 | 3.99 | 8181 | 398954 | 1 | 2 |
| -7.25 | 115 | 16.88 | -27.45 | -23.24 | 28850 | 399788 | 0 | 2 |
| 3.38 | 181 | 11.07 | 77.54 | 65.46 | 52430 | 404672 | 0 | 1 |
| 3.88 | 150 | 18.7 | 10.06 | 9.48 | 20389 | 405294 | 1 | 1 |
| 3.48 | 126 | 25.62 | 14.33 | 11.03 | 12800 | 406282 | 1 | 2 |
| 0.11 | 143 | 10.79 | 0.41 | 0.3 | 29701 | 406450 | 1 | 1 |
| 3.91 | 57 | 14.38 | 5.9 | 4.3 | 12952 | 406450 | 1 | 2 |
| 2.67 | 131 | 10.23 | 9.66 | 9.63 | 30698 | 410489 | 1 | 1 |
| 7.69 | 153 | 22.96 | 38.69 | 33.25 | 14505 | 414484 | 1 | 2 |
| 8.5 | 80 | 19.99 | 14.8 | 14.24 | 11731 | 415035 | 1 | 2 |
| 4.08 | 80 | 7.65 | 45.81 | 38.84 | 33219 | 415247 | 0 | 2 |
| 1.38 | 165 | 16.51 | 3.39 | 3.05 | 28756 | 415798 | 1 | 1 |
| 3.56 | 85 | 7.31 | 19.72 | 19.14 | 38379 | 416818 | 0 | 2 |
| 4.49 | 44 | 2.61 | 16.65 | 15.98 | 33512 | 417759 | 1 | 1 |
| 2 | 58 | 11.53 | 9.94 | 9.71 | 41150 | 425385 | 0 | 2 |
| 4.95 | 316 | 29.44 | 11.81 | 9.83 | 15255 | 427291 | 0 | 2 |
| -16.12 | 493 | 26.11 | -69.54 | -69 | 45014 | 428075 | 0 | 1 |
| 18.97 | 68 | 11.99 | 80.43 | 78.74 | 14562 | 430018 | 1 | 1 |
| 10.6 | 107 | 22.78 | 69.03 | 55.27 | 14777 | 430108 | 1 | 2 |
| 17.84 | 135 | 24.14 | 17.94 | 17.66 | 5855 | 436755 | 1 | 2 |
| 12.09 | 171 | 27.58 | 32.46 | 26.15 | 10741 | 436875 | 1 | 2 |
| 2.88 | 41 | 7.91 | 10.35 | 5.92 | 24441 | 441428 | 1 | 1 |
| 7.09 | 121 | 16.04 | 11.26 | 13.75 | 13479 | 441949 | 1 | 2 |
| -4.36 | 95 | 8.18 | -16.83 | -16.83 | 39159 | 445194 | 0 | 1 |
| 5.18 | 83 | 16.33 | 8.44 | 7.9 | 12496 | 445915 | 1 | 2 |
| 5.37 | 66 | 16.21 | 11.73 | 11.53 | 13929 | 448459 | 1 | 2 |
| 7.04 | 239 | 27.98 | 30.82 | 24.94 | 18629 | 453216 | 0 | 2 |
| 13.73 | 70 | 17.55 | 46.88 | 46.88 | 9168 | 453803 | 1 | 2 |
| 9.02 | 44 | 11.98 | 23.53 | 23.04 | 14669 | 456197 | 1 | 2 |
| 4.44 | 88 | 7 | 14.13 | 13.31 | 30271 | 459261 | 1 | 1 |
| 2.79 | 353 | 13.79 | 20.25 | 20.13 | 59357 | 461482 | 0 | 1 |
| 2.27 | 143 | 10.14 | 8.3 | 8.13 | 32970 | 461991 | 1 | 1 |
| 1.04 | 179 | 33.61 | 1.29 | 1.2 | 9272 | 463559 | 1 | 2 |
| 2.79 | 353 | 13.79 | 21.22 | 21.08 | 59357 | 464761 | 0 | 1 |
| 6.99 | 11 | 2.63 | 6.86 | 6.83 | 10146 | 465600 | 1 | 2 |
| 16.78 | 48 | 22.73 | 111.24 | 56.86 | 4583 | 470559 | 1 | 2 |
| 4.19 | 110 | 14.73 | 42.36 | 40.88 | 20372 | 474852 | 1 | 2 |
| 13.74 | 69 | 8.5 | 65.83 | 36.79 | 11019 | 478000 | 1 | 2 |
| 2.54 | 133 | 8.92 | 10.29 | 3.31 | 38211 | 478096 | 0 | 2 |
| 9.34 | 103 | 14.5 | 40.73 | 32.94 | 15029 | 479764 | 1 | 2 |
| 6.67 | 304 | 34.3 | 46.29 | 36.86 | 19611 | 482733 | 0 | 2 |
| 2 | 39 | 3.67 | 16.2 | 16.11 | 40762 | 484640 | 0 | 2 |
| 11.44 | 63 | 14.53 | 26.68 | 23.95 | 7907 | 485277 | 1 | 2 |
| 9.85 | 564 | 42.66 | 20.55 | 19.69 | 7393 | 489443 | 0 | 2 |
| 6.22 | 73 | 7.5 | 30.09 | 27.62 | 28497 | 493833 | 1 | 1 |
| 7.68 | 216 | 21.11 | 43.02 | 25.17 | 13546 | 494490 | 1 | 2 |
| 0.08 | 438 | 30.76 | 0.21 | 0.19 | 26190 | 500468 | 0 | 2 |
| 1.73 | 60 | 5.74 | 10.14 | 10.06 | 50352 | 507665 | 0 | 1 |
| 6.68 | 105 | 14.71 | 15.42 | 14.68 | 22915 | 510675 | 1 | 1 |
| 8.52 | 42 | 16.83 | 15.92 | 15.91 | 17930 | 513034 | 1 | 1 |
| 3.46 | 16 | 3.79 | 6.27 | 6.27 | 18843 | 513696 | 1 | 2 |
| -27.24 | 12 | 10.41 | -23.65 | -23.27 | 4628 | 521110 | 1 | 2 |
| -7.96 | 637 | 22.84 | -28.6 | -16.94 | 66426 | 524944 | 0 | 1 |
| -7.96 | 637 | 22.84 | -28.6 | -16.94 | 66426 | 524944 | 0 | 1 |
| 0.07 | 249 | 24.41 | 0.27 | 0.19 | 23405 | 530433 | 1 | 1 |
| -2.08 | 212 | 19.58 | -5.7 | -5.41 | 33191 | 532512 | 1 | 1 |
| 5.76 | 255 | 18.08 | 16.34 | 12.16 | 33233 | 536460 | 0 | 2 |
| 14.7 | 118 | 22.67 | 17.03 | 16.64 | 8969 | 537759 | 1 | 2 |
| 13.26 | 149 | 29.22 | 19.91 | 19.21 | 7015 | 541721 | 1 | 2 |
| 7.22 | 114 | 14.57 | 22.18 | 21.06 | 26813 | 542695 | 1 | 1 |
| 5.03 | 892 | 49.38 | 17.09 | 16.7 | 27724 | 544563 | 0 | 2 |
| -36.31 | 1799 | 40.48 | -200.06 | -49.52 | 81653 | 551865 | 0 | 1 |
| 6.09 | 346 | 33.72 | 18.18 | 16.76 | 23682 | 557664 | 0 | 2 |
| 12.96 | 97 | 20.24 | 26.25 | 26.25 | 10793 | 562297 | 1 | 2 |
| 1.28 | 145 | 21.4 | 20.34 | 13.34 | 30860 | 563720 | 1 | 1 |
| 2.18 | 854 | 6.96 | 14.62 | 10.63 | 395323 | 568165 | 0 | 1 |
| 2.77 | 194 | 12.89 | 24.73 | 24.73 | 27370 | 580596 | 1 | 1 |
| 6.88 | 286 | 19.97 | 39.6 | 33.09 | 31095 | 580912 | 0 | 2 |
| 4.59 | 188 | 18.96 | 14.75 | 14.67 | 22191 | 583537 | 1 | 1 |
| 6.09 | 346 | 33.72 | 18.18 | 16.76 | 23682 | 587015 | 0 | 2 |
| 1.09 | 1116 | 13.63 | 10.43 | 8.78 | 196046 | 592296 | 0 | 1 |
| 4.46 | 10 | 1.34 | 119.25 | 119.25 | 50483 | 592950 | 0 | 1 |
| 8.43 | 105 | 10.97 | 17.02 | 16.2 | 21430 | 593472 | 1 | 1 |
| 20.43 | 2692 | 38.39 | 6.33 | 5.47 | 3488 | 598496 | 0 | 2 |
| 2.34 | 175 | 8.18 | 18.03 | 14.99 | 82231 | 599078 | 0 | 1 |
| 8.3 | 270 | 25.25 | 22.66 | 20.43 | 15286 | 600024 | 0 | 2 |
| -1.62 | 923 | 30.56 | -11.15 | -11.15 | 89837 | 602362 | 0 | 1 |
| -18.25 | 63 | 26.44 | -8.89 | -7.66 | 10882 | 602926 | 1 | 2 |
| 1.53 | 1674 | 45.27 | 5.88 | 5.72 | 18870 | 603154 | 0 | 1 |
| 2.46 | 496 | 20.71 | 10.19 | 9.51 | 52354 | 626529 | 0 | 1 |
| 2.12 | 1166 | 25.8 | 19.49 | 15.69 | 107972 | 639371 | 0 | 1 |
| 48.81 | 96 | 32.06 | 47.52 | 45.89 | 9281 | 643746 | 1 | 2 |
| 2.83 | 102 | 30.73 | 6.75 | 6.51 | 25892 | 647179 | 1 | 1 |
| 1.63 | 159 | 11.71 | 5.61 | 5.2 | 48809 | 647802 | 0 | 1 |
| 7.31 | 42 | 16.83 | 12 | 12 | 18100 | 652288 | 1 | 1 |
| 1.56 | 14 | 0.72 | 43.65 | 43.59 | 100277 | 653383 | 0 | 1 |
| 2.77 | 57 | 8.65 | 6.86 | 6.49 | 32559 | 661982 | 1 | 1 |
| 4.01 | 93 | 9.04 | 11.98 | 11.68 | 35833 | 661982 | 0 | 2 |
| 4.26 | 64 | 3.52 | 68.51 | 68.13 | 57819 | 663964 | 0 | 1 |
| -2.72 | 693 | 19.54 | -12.08 | -10.02 | 25620 | 666329 | 0 | 1 |
| 0.76 | 185 | 20.08 | 1.75 | 1.73 | 24713 | 668406 | 1 | 1 |
| 1.97 | 195 | 8.08 | 15.17 | 12.62 | 85907 | 672714 | 0 | 1 |
| 5.14 | 99 | 6.75 | 26.67 | 24.75 | 47730 | 672744 | 0 | 1 |
| 2.94 | 89 | 21.31 | 6.22 | 6.2 | 12914 | 679701 | 1 | 2 |
| 6.2 | 82 | 44.62 | 2.18 | 2.12 | 4074 | 681267 | 1 | 2 |
| -4.36 | 405 | 27.04 | -8.38 | -7.99 | 34653 | 684061 | 0 | 2 |
| 1.35 | 766 | 18.4 | 23.94 | 8.66 | 84869 | 686441 | 0 | 1 |
| 2.69 | 39 | 2.98 | 7.6 | 7.48 | 31095 | 689417 | 1 | 1 |
| 3.44 | 187 | 14.34 | 8.15 | 6.42 | 37239 | 698889 | 0 | 2 |
| 6.05 | 102 | 12.09 | 12.32 | 9.94 | 26782 | 698915 | 1 | 1 |
| 2.67 | 87 | 19.18 | 5.77 | 5.75 | 12914 | 699671 | 1 | 2 |
| 3.39 | 195 | 11.46 | 15.65 | 14.89 | 41853 | 709328 | 0 | 1 |
| -50.52 | 102 | 20.19 | -25.85 | -22.99 | 9959 | 710134 | 1 | 2 |
| 2.95 | 754 | 27.22 | 13.34 | 12.3 | 52693 | 720109 | 0 | 1 |
| 1.06 | 187 | 17.87 | 4.4 | 3.99 | 24460 | 722504 | 1 | 1 |
| 20.76 | 54 | 13.84 | 24.23 | 23.32 | 4912 | 723107 | 1 | 2 |
| 2.94 | 1282 | 29.55 | 2.57 | 2.07 | 29431 | 734694 | 0 | 1 |
| 19.43 | 83 | 10.8 | 53.47 | 51.95 | 9979 | 739983 | 1 | 2 |
| 16.12 | 106 | 16.92 | 32.34 | 31.39 | 6734 | 742187 | 1 | 2 |
| 3.97 | 220 | 18.21 | 5.82 | 5.54 | 24435 | 743919 | 1 | 1 |
| 9.67 | 615 | 35.2 | 54.04 | 48.79 | 12091 | 750503 | 0 | 2 |
| 53.33 | 107 | 33.33 | 70.38 | 53.16 | 4211 | 758532 | 1 | 2 |
| -5.38 | 617 | 51.5 | -32.56 | -12.57 | 24990 | 758861 | 0 | 2 |
| 1.52 | 847 | 26.38 | 31.76 | 5.36 | 50069 | 780781 | 0 | 1 |
| 3.85 | 98 | 25.16 | 3.38 | 3.25 | 9551 | 789003 | 1 | 2 |
| 22.17 | 54 | 13.84 | 66.11 | 64.1 | 4912 | 794983 | 1 | 2 |
| 3.59 | 193 | 8.47 | 22.02 | 19.94 | 81271 | 795900 | 0 | 1 |
| 14.44 | 89 | 12.67 | 18.85 | 18.28 | 16045 | 805384 | 1 | 1 |
| 14.58 | 193 | 12.37 | 203.87 | 126.56 | 33440 | 807300 | 0 | 2 |
| 16.05 | 133 | 23.13 | 27.17 | 26.89 | 6653 | 809058 | 1 | 2 |
| 13.21 | 67 | 8.66 | 22.43 | 22.43 | 17289 | 811241 | 1 | 1 |
| 3.98 | 155 | 7.93 | 14.91 | 13.62 | 74543 | 813388 | 0 | 1 |
| 4.7 | 322 | 13.33 | 24.62 | 23.34 | 44184 | 815083 | 0 | 1 |
| 11.1 | 41 | 5.39 | 16.02 | 15.74 | 23306 | 815709 | 1 | 1 |
| 2.37 | 647 | 18.05 | 7.15 | 7.08 | 72895 | 815741 | 0 | 1 |
| 5.64 | 126 | 8.67 | 33.39 | 33.39 | 64386 | 825893 | 0 | 1 |
| 7.7 | 240 | 15.85 | 24.4 | 23.88 | 35964 | 827145 | 1 | 1 |
| 40.53 | 55 | 13.86 | 74.55 | 73.96 | 7788 | 829833 | 1 | 2 |
| 16.71 | 106 | 16.92 | 28.69 | 27.8 | 6734 | 832647 | 1 | 2 |
| 4.46 | 296 | 21.46 | 11.75 | 9.31 | 39185 | 841760 | 0 | 2 |
| 19.61 | 91 | 20.03 | 27.17 | 23.33 | 8347 | 845242 | 1 | 2 |
| 2.84 | 86 | 12.71 | 4.49 | 4.35 | 22949 | 847928 | 1 | 1 |
| 0.45 | 487 | 12.52 | 3.86 | 1.87 | 111075 | 848209 | 0 | 1 |
| 20.79 | 91 | 15.65 | 17.84 | 17.53 | 8800 | 848736 | 1 | 2 |
| 1.46 | 398 | 12.37 | 9.56 | 8.8 | 93393 | 850230 | 0 | 1 |
| 23.04 | 60 | 17.51 | 26.93 | 20.83 | 9774 | 854540 | 1 | 2 |
| 2.32 | 89 | 14.5 | 1.89 | 1.53 | 11961 | 857343 | 1 | 2 |
| 5.78 | 222 | 14.31 | 32.97 | 32.12 | 52434 | 862404 | 0 | 1 |
| 8.86 | 197 | 18.47 | 11.38 | 10.55 | 19171 | 863735 | 1 | 1 |
| 5.56 | 881 | 29.94 | 98.11 | 66.24 | 43834 | 866626 | 0 | 1 |
| 30.58 | 161 | 24.16 | 43.84 | 43.58 | 8060 | 880454 | 1 | 2 |
| 0.9 | 317 | 5.28 | 8.47 | 8.17 | 191674 | 880783 | 0 | 1 |
| 18.77 | 114 | 16.19 | 17.84 | 17.64 | 25283 | 889555 | 1 | 1 |
| 2.99 | 256 | 10.24 | 13.66 | 6.14 | 94500 | 891993 | 0 | 1 |
| 12.19 | 36 | 3.79 | 729.75 | 575.53 | 42556 | 892119 | 0 | 1 |
| 5.16 | 754 | 17.16 | 177.97 | 88.39 | 57476 | 901682 | 0 | 1 |
| 24.22 | 68 | 12.85 | 71.05 | 61.64 | 6189 | 905608 | 1 | 2 |
| 2.91 | 706 | 16.78 | 15.44 | 15.28 | 94681 | 909378 | 0 | 1 |
| 11.06 | 499 | 24.29 | 24.59 | 23.05 | 49038 | 916351 | 0 | 1 |
| 6.74 | 221 | 11.2 | 31.7 | 30.57 | 32693 | 927597 | 0 | 2 |
| 3.26 | 1467 | 31.07 | 33.64 | 18.32 | 102772 | 931338 | 0 | 1 |
| 1.24 | 45 | 4 | 3.51 | 3.41 | 54632 | 935488 | 0 | 1 |
| 0.98 | 160 | 7.33 | 17.08 | 17.08 | 65840 | 939361 | 0 | 1 |
| 4.89 | 180 | 8.86 | 17.14 | 14.61 | 66209 | 946544 | 0 | 1 |
| 20.01 | 114 | 16.26 | 14.86 | 14.73 | 25283 | 947984 | 0 | 2 |
| -3.21 | 279 | 15.27 | -18.32 | -7.3 | 80928 | 956785 | 0 | 1 |
| -1.68 | 2217 | 12.79 | -25.66 | -22.36 | 765122 | 963235 | 0 | 1 |
| 5.23 | 16 | 0.41 | 58.94 | 58.94 | 82113 | 976014 | 0 | 1 |
| 14.75 | 143 | 21.14 | 26.97 | 25.83 | 13955 | 977595 | 1 | 2 |
| 2.68 | 23 | 1.87 | 9.16 | 9.16 | 68567 | 978504 | 0 | 1 |
| 22.42 | 73 | 18.08 | 10.94 | 5.77 | 5275 | 983675 | 1 | 2 |
| 1.24 | 278 | 7.81 | 8.75 | 8.42 | 140454 | 1000000 | 0 | 1 |
| 8.1 | 237 | 21.64 | 23.43 | 22.87 | 22514 | 1000000 | 0 | 1 |
| 18.93 | 74 | 12.53 | 24.56 | 24.12 | 20301 | 1000000 | 1 | 1 |
| 8.56 | 47 | 8.68 | 26.42 | 23.9 | 26118 | 1000000 | 0 | 2 |
| 3.26 | 1467 | 31.07 | 33.25 | 18.2 | 102772 | 1000000 | 0 | 1 |
| 4.47 | 115 | 17.93 | 2.68 | 2.65 | 7588 | 1100000 | 1 | 2 |
| 0.34 | 1979 | 9.2 | 3.65 | 2.61 | 403208 | 1100000 | 0 | 1 |
| 2.08 | 301 | 15.07 | 5.59 | 4.82 | 62931 | 1100000 | 0 | 1 |
| 1.48 | 13 | 3.33 | 9.57 | 9.57 | 48744 | 1100000 | 0 | 1 |
| 3.79 | 103 | 4.95 | 10.13 | 9.8 | 54316 | 1100000 | 0 | 1 |
| 5.98 | 145 | 8.98 | 17.94 | 16.51 | 49386 | 1100000 | 0 | 1 |
| 8.92 | 236 | 21.37 | 26.11 | 25.48 | 22680 | 1100000 | 0 | 1 |
| 32.41 | 245 | 29.28 | 27.12 | 26.58 | 6234 | 1100000 | 1 | 2 |
| -7.22 | 5625 | 26.35 | -32.56 | -29.05 | 679716 | 1200000 | 0 | 1 |
| -0.51 | 1328 | 8.75 | -3.28 | -2.33 | 774008 | 1200000 | 0 | 1 |
| 0.98 | 457 | 21.61 | 1.88 | 1.88 | 32576 | 1200000 | 0 | 1 |
| 8.05 | 570 | 36.73 | 9.18 | 8.36 | 32475 | 1200000 | 0 | 2 |
| 1.51 | 215 | 7.16 | 9.55 | 7.46 | 154686 | 1200000 | 0 | 1 |
| 9.76 | 117 | 7.57 | 21.82 | 21.37 | 43303 | 1200000 | 0 | 2 |
| 2.82 | 298 | 10.52 | 23.92 | 6.79 | 110055 | 1200000 | 0 | 1 |
| 6.85 | 164 | 9.99 | 26.91 | 26.56 | 57562 | 1200000 | 0 | 1 |
| 5.3 | 1118 | 22.6 | 29.07 | 14.63 | 34494 | 1200000 | 0 | 1 |
| 12.98 | 80 | 7.95 | 32.47 | 28.43 | 30975 | 1200000 | 0 | 2 |
| 47.71 | 35 | 13.29 | 38.45 | 38.42 | 3129 | 1200000 | 1 | 2 |
| 14.95 | 404 | 32.11 | 64.37 | 44.86 | 23735 | 1200000 | 0 | 2 |
| 12.79 | 52 | 11.4 | 66.57 | 60.18 | 25561 | 1200000 | 0 | 2 |
| -8 | 432 | 77.28 | -22.18 | -12.74 | 19069 | 1300000 | 0 | 2 |
| -2.07 | 769 | 7.88 | -16.44 | -14.74 | 273577 | 1300000 | 0 | 1 |
| 7.11 | 1 | 0.02 | 8.68 | 8.45 | 29037 | 1300000 | 1 | 1 |
| 3.59 | 41 | 2.37 | 9.24 | 9.22 | 66241 | 1300000 | 0 | 1 |
| 6.87 | 197 | 17.48 | 10.36 | 10.21 | 36063 | 1300000 | 0 | 2 |
| 4.39 | 83 | 4.64 | 11.81 | 10.05 | 65809 | 1300000 | 0 | 1 |
| 2 | 2787 | 29.62 | 13.69 | 13.69 | 287199 | 1300000 | 0 | 1 |
| 17.53 | 120 | 24.06 | 14.26 | 13.66 | 14670 | 1300000 | 0 | 2 |
| 16.37 | 183 | 18.57 | 23.5 | 22.38 | 21903 | 1300000 | 1 | 1 |
| 15.21 | 216 | 21.42 | 66.95 | 63.58 | 21532 | 1300000 | 1 | 1 |
| -3.99 | 328 | 18.23 | -8.34 | -6.44 | 73222 | 1400000 | 0 | 1 |
| 1.6 | 56 | 22.56 | 0.43 | 0.41 | 4006 | 1400000 | 1 | 2 |
| 3.75 | 232 | 20.24 | 9.85 | 9.39 | 57279 | 1400000 | 0 | 1 |
| 25.57 | 6 | 1.05 | 35.52 | 19.77 | 17937 | 1400000 | 1 | 1 |
| 7.92 | 418 | 14.2 | 47.45 | 24.92 | 62367 | 1400000 | 0 | 1 |
| 6.83 | 491 | 28.44 | 64.13 | 21.97 | 60588 | 1400000 | 0 | 1 |
| 8.17 | 930 | 23.73 | 82.72 | 70.4 | 56100 | 1400000 | 0 | 1 |
| -43.65 | 322 | 13.11 | -94.11 | -92.18 | 52794 | 1500000 | 0 | 1 |
| -4.51 | 176 | 16.4 | -4.73 | -4.47 | 25755 | 1500000 | 0 | 2 |
| 1.11 | 501 | 5.75 | 9.7 | 8.37 | 259409 | 1500000 | 0 | 1 |
| 3.2 | 168 | 4.5 | 25.51 | 17.98 | 172174 | 1500000 | 0 | 1 |
| 5.96 | 132 | 3.76 | 57.76 | 27.17 | 81377 | 1500000 | 0 | 1 |
| -1.91 | 234 | 18.6 | -45.6 | -0.64 | 45325 | 1600000 | 0 | 1 |
| 0.08 | 2206 | 20.32 | 1.6 | 0.55 | 232470 | 1600000 | 0 | 1 |
| 24.55 | 4 | 1.31 | 11.82 | 4.87 | 12495 | 1600000 | 0 | 2 |
| 13.8 | 365 | 22.8 | 37.08 | 36.06 | 26779 | 1600000 | 0 | 2 |
| 4.22 | 450 | 25.4 | 5.23 | 4.64 | 50071 | 1700000 | 0 | 1 |
| 7.71 | 380 | 26.79 | 11.22 | 10.05 | 33618 | 1700000 | 0 | 1 |
| 12.83 | 101 | 5.29 | 23.62 | 23.62 | 42863 | 1700000 | 0 | 1 |
| 7.82 | 587 | 18.08 | 32.9 | 32.02 | 81077 | 1700000 | 0 | 1 |
| -1.12 | 408 | 8.46 | -44.22 | -15.74 | 193191 | 1800000 | 0 | 1 |
| 8.27 | 276 | 24.11 | 4.06 | 2.78 | 17024 | 1800000 | 0 | 2 |
| 10.49 | 271 | 48.15 | 6 | 5.68 | 17942 | 1800000 | 0 | 2 |
| 2.52 | 191 | 5.76 | 10.81 | 9.97 | 106897 | 1800000 | 0 | 1 |
| 2.83 | 1037 | 17.91 | 48.52 | 14.01 | 140863 | 1800000 | 0 | 1 |
| 8.54 | 431 | 8.13 | 59.23 | 54.71 | 97244 | 1800000 | 0 | 1 |
| -7.49 | 300 | 32.29 | -4.41 | -4.26 | 23761 | 1900000 | 0 | 2 |
| 9.63 | 28 | 6.27 | 11.61 | 11.4 | 43159 | 1900000 | 0 | 1 |
| 7.39 | 194 | 15.53 | 13.02 | 12.13 | 36644 | 1900000 | 0 | 1 |
| 32.2 | 63 | 10.93 | 14.88 | 13.08 | 11172 | 1900000 | 0 | 2 |
| 3 | 2228 | 41.52 | 23.61 | 4.19 | 72715 | 1900000 | 0 | 1 |
| 4.55 | 722 | 10.47 | 37.67 | 32.25 | 161046 | 1900000 | 0 | 1 |
| -13.68 | 406 | 20.75 | -21.48 | -13.61 | 84069 | 2000000 | 0 | 1 |
| 10.89 | 119 | 22.63 | 4.54 | 3.96 | 17229 | 2000000 | 0 | 2 |
| 1.59 | 757 | 9.19 | 8.51 | 7.78 | 213836 | 2000000 | 0 | 1 |
| 1.96 | 2627 | 24.76 | 8.79 | 8.58 | 213606 | 2000000 | 0 | 1 |
| 5.9 | 691 | 13.03 | 23.59 | 21.95 | 95646 | 2000000 | 0 | 1 |
| 0.43 | 1168 | 19.29 | 3.05 | 2.1 | 164485 | 2100000 | 0 | 1 |
| 1.02 | 1126 | 16.61 | 4.15 | 2.91 | 235662 | 2100000 | 0 | 1 |
| 48.09 | 243 | 33.13 | 31.92 | 30.83 | 19845 | 2100000 | 1 | 2 |
| 4.62 | 392 | 11.36 | 14.32 | 13.19 | 142441 | 2200000 | 0 | 1 |
| 14.35 | 113 | 9.51 | 14.94 | 11.47 | 39036 | 2200000 | 0 | 1 |
| 8.16 | 116 | 4.64 | 18.87 | 17.05 | 98814 | 2200000 | 0 | 1 |
| 5.91 | 324 | 10.99 | 19.44 | 16.14 | 110143 | 2200000 | 0 | 1 |
| 14.5 | 116 | 9.69 | 21.21 | 21.21 | 48155 | 2200000 | 0 | 1 |
| -1.39 | 769 | 7.88 | -6.77 | -6.33 | 273577 | 2300000 | 0 | 1 |
| -0.63 | 589 | 22.64 | -1.15 | -1.04 | 66818 | 2300000 | 0 | 1 |
| 0.33 | 991 | 9.26 | 1.99 | 1.61 | 307139 | 2300000 | 0 | 1 |
| 1.15 | 1175 | 9.11 | 6.56 | 6.41 | 361088 | 2300000 | 0 | 1 |
| 8.09 | 237 | 14.95 | 7.41 | 7.37 | 51595 | 2300000 | 0 | 1 |
| 4.71 | 1013 | 13.73 | 19.32 | 18.39 | 158282 | 2300000 | 0 | 1 |
| -3.31 | 592 | 26.26 | -3.82 | -3.82 | 58516 | 2400000 | 0 | 1 |
| 0.74 | 948 | 8.18 | 4.59 | 4.54 | 327154 | 2400000 | 0 | 1 |
| 29.12 | 165 | 17.13 | 17.69 | 17.41 | 15450 | 2400000 | 0 | 2 |
| 26.32 | 41 | 7.93 | 15.67 | 14.39 | 22591 | 2500000 | 0 | 2 |
| -10.34 | 851 | 45.94 | -5.1 | -4.9 | 47659 | 2600000 | 0 | 2 |
| 3.73 | 763 | 11.52 | 16.44 | 14.93 | 171707 | 2600000 | 0 | 1 |
| 7.6 | 486 | 17.82 | 21.45 | 18.52 | 70109 | 2600000 | 0 | 1 |
| 6.91 | 215 | 6.95 | 31.36 | 30.54 | 79859 | 2600000 | 0 | 1 |
| 15.98 | 82 | 8.99 | 57.33 | 57.33 | 45006 | 2700000 | 0 | 1 |
| -4.98 | 1470 | 27.99 | -13.19 | -8.97 | 124547 | 2800000 | 0 | 1 |
| 0.46 | 958 | 7.6 | 3.02 | 2.26 | 461292 | 2800000 | 0 | 1 |
| 4.7 | 1085 | 17.98 | 13.28 | 10.43 | 150329 | 2800000 | 0 | 1 |
| 25.02 | 98 | 8.59 | 15.68 | 15.39 | 28217 | 2800000 | 0 | 2 |
| 6.14 | 225 | 3.17 | 19.18 | 18.36 | 192687 | 2800000 | 0 | 1 |
| 0.74 | 1498 | 20.63 | 1.94 | 1.73 | 157469 | 2900000 | 0 | 1 |
| 11.53 | 667 | 25.12 | 9.33 | 8.03 | 43688 | 2900000 | 0 | 1 |
| 3.8 | 777 | 12.68 | 15.18 | 13.9 | 170779 | 3100000 | 0 | 1 |
| 2.95 | 515 | 6.67 | 16.71 | 12.25 | 293012 | 3100000 | 0 | 1 |
| 12.17 | 194 | 9.48 | 27.14 | 27.14 | 78843 | 3100000 | 0 | 1 |
| 10.24 | 1265 | 28.13 | 45.38 | 32.14 | 98322 | 3100000 | 0 | 1 |
| 0.85 | 1697 | 15.57 | 2.61 | 2.07 | 274605 | 3200000 | 0 | 1 |
| 0.84 | 1504 | 20.94 | 3.13 | 2.61 | 157469 | 3200000 | 0 | 1 |
| 1.62 | 899 | 6.96 | 7.11 | 6.64 | 370630 | 3200000 | 0 | 1 |
| 1.75 | 204 | 8.28 | 2.39 | 2.21 | 107559 | 3300000 | 0 | 1 |
| 0.94 | 3177 | 28.51 | 2.92 | 1.74 | 210881 | 3300000 | 0 | 1 |
| 2.37 | 2361 | 22 | 12.03 | 10.67 | 153901 | 3300000 | 0 | 1 |
| 3.16 | 1210 | 13.2 | 10.67 | 7.42 | 343381 | 3400000 | 0 | 1 |
| 1.75 | 1161 | 7.01 | 23.48 | 11.18 | 646200 | 3500000 | 0 | 1 |
| 4.83 | 312 | 15.41 | 4.87 | 2.89 | 73036 | 3600000 | 0 | 1 |
| 19.09 | 85 | 4.05 | 24.3 | 20.72 | 71919 | 3700000 | 0 | 1 |
| 7.33 | 218 | 7.18 | 26.05 | 25.39 | 79859 | 3800000 | 0 | 1 |
| 5.51 | 352 | 12.12 | 5.46 | 5.28 | 69021 | 4100000 | 0 | 1 |
| 22.85 | 323 | 20.78 | 10.61 | 9.25 | 37536 | 4100000 | 0 | 1 |
| -16.72 | 7861 | 29.84 | -10.3 | -5.05 | 80644 | 4500000 | 0 | 1 |
| 1.27 | 746 | 6.13 | 13.57 | 9.96 | 381261 | 4500000 | 0 | 1 |
| 1.43 | 1368 | 19.33 | 4.42 | 1.87 | 209325 | 4600000 | 0 | 1 |
| 1.43 | 1368 | 19.33 | 4.44 | 1.88 | 211086 | 4600000 | 0 | 1 |
| 2.06 | 2107 | 14.98 | 10.03 | 9.81 | 402986 | 4700000 | 0 | 1 |
| 8.81 | 236 | 17.38 | 4.64 | 4.59 | 42457 | 4800000 | 0 | 1 |
| 12.23 | 463 | 13.89 | 27.19 | 26.15 | 130249 | 5200000 | 0 | 1 |
| -7.22 | 1599 | 24.87 | -7.32 | … |
Some things to consider for your discussion for the client in CW2
I know that some of you are starting your CW2 so here is some general ideas to think about when you get to the point of writing discussion around your tables, charts, hypotheses tests, etc.
1. Think about your client as an investor, they may have many strategies, don’t assume anything, and don’t tell them what their investment approach should be. An investor might want to pick winners, like an Angel Investor, who puts all their money into one company and wants to work closely with the company. An investor might want to spread their money widely by buying shares in companies across the whole industry. An investor might be looking for riskier investments or safer investments, you don’t know what they want. Don’t assume anything.
2. When you use a variable, make sure you tell the client how it is measured and why it might interest them. For example, clearly both profit margin and shareholder return are measures of potential gains or losses for the investor so they should consider these carefully and that is why they have asked you to look at them. But tell them how these are measured by looking at the notes on the data set.
3. When you are looking at the distribution of any variable, you will be using descriptive statistics and a histogram. So here are some things to consider when looking at any descriptive stats table for profit margin. When you are looking at the ‘mean’ value of profit margin you need to say why it might interest the client. The population mean for profit margin represents the average return an investor might expect if they spread their investment across all firms the sector. Use the confidence interval estimate for this. It is clearly a measure of performance. Whether the value is high or low, depends on what it is compared with, leaving your money in the bank? Investing in another sector? Etc. You also need to say something about the data as a sample from the population. If the client invested in only your sample companies in this sector, they might expect something like the sample mean return, but what if they pick other companies in the sector? Think about what the median shows. Half of the sample firms earn less than median profit margin and half more than that. Is the median the same as the mean? If not, it shows skew. The skew value may shows bunching of profit margin at one end of the distribution. Think about this. If the client only picks a few companies to invest in, are they are likely to get a much lower or higher margin than the average. The sample standard deviation will be useful here. What if the investor wants to try to ‘cherry pick’ very high profit margin firms? Should they expect profits to be the same in every year? This is just one year of data. When you look at the standard deviation, don’t forget to add the coefficient of variation as this is a way of judging whether the variation around the mean is high or low. What would high or low variation imply for an investor? Think about discussing the risk the investor might want to take. Low variation around the mean profit margin implies the investor is more likely to get a return closer to the mean, it is more predictable, lower risk. So, say that the client should consider whether they prioritise looking for low risk with possibly lower return. Explain the client is less likely to achieve the mean return if the standard deviation is high when they pick only a few firms. Maybe the client is looking for this type of higher risk strategy. Don’t make assumptions. Don’t tell the investor what to invest in. That is not your job. Explain what the numbers mean, depending on what type of strategy the client wants to adopt.
4. You can use a confidence interval to estimate the population mean whenever you do descriptive stats. Explain the limitations of making decisions based only on the sample data you have got and why the client needs to think about the pattern in the population of data from the whole sector, which is not available.
5. When you are comparing descriptive statistics by a characteristic like size, you need to explore the differences of central value, spread and skew and what these differences might imply for the client (as above). The client might be considering targeting SME manufacturers or only large corporations. One profit margin might appear higher than the other using the mean and or median, so consider the implications for the client as state earlier. This is a sample, so you must use a t – test to test the difference of means and explain simply why the test is needed, what is tests (hypothesis) and what the result shows for the client. Is the apparent difference in the sample means across these groups likely to be found in the population of data? If you cannot reject the Ho, then you must explain to the client what it means in terms of investing in the sector. Is there likely to be a difference in the spread in the population across these 2 groups and hence what conclusion can they draw about risk of achieving the mean return for their investment if they target one group rather than another. If one group is left and the other is right skew for example, then consider what this says about the chance of getting high or low profit margins in the two sectors.
6. If you find a pattern or if you find no pattern in a cross tab, explore what that means for the client. No pattern is just as interesting as a pattern. Is size related to export activity? Find out and explain to the client why it might be of interest. The investor might prefer large well-known companies, or they might be looking to invest in SMEs. They might like focused companies or companies which export or those that are UK focused. It depends on what they are looking for in their investment portfolio. You don’t know what they want, but clearly, they want to know if these are related or not as they have asked for the analysis.
7. When you look at correlation values (positive or negative) you need to discuss for the client what you find. Is there a simple reason why two variables are correlated positively or negatively? Are the correlations significant. Do the correlation results tell us what affects profit margin? If so, how could the client use that information, if not what does that mean for the client if they are looking for high profit firms?
8. When you look at bivariate regression you need to say something about the method and why you are using it. You need to explain the regression model, say clearly which variable is the dependent variable, and which is the independent variables (with appropriate labels) and look at the data notes and think about what information it gives to the client. You should set these out for the client with a clear statement identifying the variables. When you have your results, you must explain the coefficients of the predicted regression equation, you must explore the equation in full, tell the client how to interpret coefficient values in context in each case and how it might be useful for them. You must test your coefficient values using one of three methods of hypothesis testing (t tests, p-value, or confidence interval) in the results and explain what the conclusion of the test is in each case. You must test the model overall using the adjusted R2. How can the model be used in forecasting profit margin for the client?
9. You need to put ‘fit for purpose’ charts and tables in the body of the report. You can put snapshots from your EXCEL file as evidence of what you did in the appendix. Your report should have a standard business report structure, content page, with numbered sections, numbered and titled charts and tables, (you don’t need an executive summary for this) with appropriate citations to techniques. Follow the instructions in the brief. Read the brief carefully.
Sensitivity: Internal
