1、LET DATA TELL YOUStatistics, Data analysis, And decisionG5 groupFor QTM PresentationG5 Industry Co., Ltd.HERE IS A COMPANYIts business scope isAll kinds of metal stampings22.1%53.6%11.4%12.2%The main productsNotebookCar components Smart phoneSeverTHERE IS A CONTRACTNOW:BUT, IT REQUIRE THE PRICETO RE

2、DUCE FOR 15%.DO YOU SIGNTHE CONTRACTTHEN, YOU NEED THE DATATO COMPILE STATISTICSTO ANALYSETO MAKE THE DECISIONPart I:TO COMPILE STATISTICSWe collect the forty-two days data from the factoryDayAmount defectsDDPMExpensesper unitCost perunitSallpriceContractpriceGrossprofitqualified1166,2326,08736,617.

3、50100103.80121102.85-0.95160,1452159,2586,01237,750.07100103.92121102.85-1.07153,2463137,3095,76541,985.59100104.38121102.85-1.53131,5444143,9985,53238,417.20100104.00121102.85-1.15138,4665136,2115,32439,086.42100104.07121102.85-1.22130,8876146,2935,43937,178.81100103.86121102.85-1.01140,8547134,261

4、5,41940,361.68100104.21121102.85-1.36128,8428126,6925,32942,062.64100104.39121102.85-1.54121,3639135,9875,45740,128.84100104.18121102.85-1.33130,53010121,0295,23943,287.15100104.52121102.85-1.67115,79011116,0285,29845,661.39100104.78121102.85-1.93110,73012124,2635,49844,244.87100104.63121102.85-1.78

5、118,76513129,9845,40941,612.81100104.34121102.85-1.49124,57514132,3715,58742,207.13100104.41121102.85-1.56126,78415146,6844,86433,159.72100103.43121102.85-0.58141,82016149,8724,51930,152.40100103.11121102.85-0.26145,35317164,0094,72828,827.69100102.97121102.85-0.12159,28118172,8764,93928,569.6110010

6、2.94121102.85-0.09167,93719169,9735,45432,087.45100103.32121102.85-0.47164,51920170,5645,30431,096.83100103.21121102.85-0.36165,26021178,6695,55531,091.01100103.21121102.85-0.36173,11422186,7984,62724,770.07100102.54121102.850.31182,17123202,0635,95629,475.96100103.04121102.85-0.19196,10724211,6496,

7、16329,118.97100103.00121102.85-0.15205,48625213,7206,35629,739.85100103.07121102.85-0.22207,36426207,0085,09824,627.07100102.52121102.850.33201,91027206,6315,18225,078.52100102.57121102.850.28201,44928198,7205,07825,553.54100102.62121102.850.23193,64229178,7064,85427,161.93100102.79121102.850.06173,

8、85230141,5924,32830,566.70100103.15121102.85-0.30137,26431123,2214,06933,021.97100103.41121102.85-0.56119,15232102,9983,78136,709.45100103.81121102.85-0.9699,21733104,6673,80236,324.73100103.77121102.85-0.92100,86534103,9793,85637,084.41100103.85121102.85-1.00100,12335101,1253,73436,924.60100103.831

9、21102.85-0.9897,39136108,2474,29439,668.54100104.13121102.85-1.28103,95337121,3784,99741,168.91100104.29121102.85-1.44116,38138142,0095,27937,173.70100103.86121102.85-1.01136,73039154,0755,58436,242.09100103.76121102.85-0.91148,49140167,8675,78734,473.72100103.57121102.85-0.72162,08041178,4925,89233

10、,009.88100103.41121102.85-0.56172,60042184,2615,97432,421.40100103.35121102.85-0.50178,287In this situation, it seems that the project will be loss if you accept the contract.Summary measures for selected variablesSummary measures for selected variablesDPPM: The number of defects in million of produ

11、cts.Amount_DefectsDPPMCost_per_unitGross profitCount42.00042.00042.00042.00042.000Mean152423.0715177.35734902.448103.620-0.770Median146488.5005314.00036283.407103.765-0.915Standard deviation32504.848683.0645786.5950.6210.621Minimum101125.0003734.00024627.068102.525-1.935Maximum213720.0006356.0004566

12、1.392104.7850.325From the data, we can get the following information So, we should use these information to further analyze the issue.Part II:DATA ANALYSISAccording to the data, the diagram can be draw 90%91%92%93%94%95%96%97%98%99%100%Cost Grossprofit0%1%2%3%4%5%6%7%8%9%10%1357911131517192123252729

13、313335373941Defectives From the diagram we can find the gross profit ratio is inverse relative with the defects ratio.Then, We will through the regression analysis to find the linear equationFrom the F-test and T-test , we get the p-value Significant Level 0.05 and the R-square=0.9435,all these indi

14、cate the DPPM and the profit is significant correlation.From the Scatter diagram we can find the DPPM and the profit is linear correlation.Now, we can get the linear equation.Profit = 1.9951-0.0001*DPPMSo ,DPPM should down to 19951 and below. The DPPM is normal distribution. The biggest value of fre

15、quency appear near the mean.NOW, WE WILL ANALYSE THE DATA OF DPPM Hypothesis Testing The DPPM data as independent samples were analyzed by T test.Assumption: H0 19951For 19951 is the break-even point PSignificant Level 5%We reject H0 and accept Ha ,so for the population DMMP will more than 19951.If

16、accept the contract we must improve the project.SOLUTION 1SOLUTION 3SOLUTION 2IMPROVEMENTThere are three solutions to be choose for the improvementSOLUTION 1SOLUTION 3SOLUTION 2We test three solutions respectively, and obtain the relevant dataThrough ANOVA ,we get the p-value Significant level 0.05,

17、 so the H0 will be rejected ,then three solution is significant difference .And the DMMP sample means of every solution are all under the break-even point 19951. All solution is feasible.How to choose the solution, we need decisionsPart III:MAKE THE DECISIONIt is estimated by expert, We got the expe

18、cted returns of each solution SucceedFailureSolution 181Solution 2143Solution 3102The expected returns of each solutionWE MAKE THE DECISION TREETHE optimal decision isSign the contract and choose the solution 2 to make improvement.After improvement, we collected about thirty days data to check.Use the thirty days data ,we draw the P-control chartFrom the P- chart we know the productive process is in the control.Results for one-sample analysis for DPPMResults for one-sample analysis