應用類神經網路於大數據資料挖礦分析研究—以台北市2011年至2015年工程採購決標金額之標案為例

Application of neural network analysis of big data mining—Case study of engineering procurement tenders award amount of the Taipei City in 2011 to 2015

柯坤安(Kun-An Ko)

指導教授 ： 洪士林

國立交通大學/工學院/工學院工程技術與管理學程/碩士(2016年)

摘要

本研究利用政府機關公開、透明的公共工程決標金額之大數據資料挖礦分析其影響變數因子及敏感度分析，以2011年至2015年為樣本區間進行資料分析，本研究蒐集之總案例數為9316例。經由大數據分類整理其決標案例，再透過隨機抽樣方式，挑選出有效資料1295例作為本研究樣本；分別再以亂數抽樣方式，區分為--260例、550例及840例等三組模組做為類神經網路之學習訓練組。另以--87例與130例二組資料做為類神經網路的測試驗證組。研究將針對訓練案例組與測試組進行交叉組合驗證。研究中擬定八項影響變數因子，分別為專案類別、工程種類、工程屬性、履約期限、產業類別、投標家數、底價金額及預算金額。再藉由倒傳遞類神經網路學習演算法(BPN)與迴歸分析因子者間的重要性，探討預測工程決標金額與影響變數因子的關係。研究結果顯示，於BPN神經網路模型中驗證組之準確率(平均相對誤差百分比)優於總平均正確率。BPN之學習效果以260例網路架構為型6-1 <8-30-1>者為最佳。驗證成效則為測試組87例網路架構為型7-1 <8-35-1>者為最佳，其準確率為90.61％。至於迴歸分析模式，驗證成效最佳化模型為--迴歸模型二，預測相對誤差之變異值為5.87％。最終於大數據資料挖礦分析中87例，將影響預測決標金額的影響變數因子進行敏感度分析，其中以因子八--預算金額的敏感度係數值為最高。研究結果顯示，藉由BPN類神經網路之敏感度分析歸納出公共工程決標金額與預算金額有明顯的關聯性。

關鍵字

大數據 ； 資料挖礦 ； 決標金額 ； 底價金額 ； 預算金額 ； BPN倒傳遞類神經網路學習演算法 ； 迴歸分析 ； 敏感度分析

並列摘要

This work presents a study of big data mining via artificial neural network models using the government agencies open and transparent public works bidding data. There are 9316 Taipei City public construction works bidding data from 2011 to 2015 were utilized as training and analyzing data. Among them, 1295 of data were selected randomly as study samples. Following, the sample data were random classed as five groups. Three are training groups with 260, 550, and 840 cases, respectively. Two are analysis groups with 87 and 130 cases. Eight influence factors are considered in this work. They are project category, engineering type, engineering attributes, duration of performance, industry category, bidder numbers, project reserve amount, and budget amount. The goal of the work is to analyze and identify the importance of influence factors and categorize sensitivity among these factors to the amount of the bid. Artificial neural networks with error backpropagation learning algorithm (BPN) and regression analysis are employed respectively to analyze between the predictive engineering award amount and the effect of variable factors. Research results show that learning effect of 260 cases of BPN-network architecture for type 6-1 <8-30-1> is the best. Validation results for test group of 87 cases of network architecture for type 7-1 <8-35-1> is the best, its accuracy is 90.61%. For regression analysis model, model two performed the best result, variation of the relative error of the predicted value is 5.87%. Finally, the group with 87 cases were employed in big data mining analysis to identify the sensitivity among influence factors. Analysis results revealed that the factor, budget-amount of the project, is the uppermost influence factor to the amount of the bid. Research shows that sensitivity analysis of neural network using BPN summed up public works bids amounts with budgeted amounts have obvious relevance.

並列關鍵字

Big data ； data mining ； the amount of the bid ； the amount of the reserve price ； budget ； BPN back-propagation neural network ； regression analysis ； sensitivity analysis

參考文獻

5.王健文，「以適應性類神經模糊推論系統預測公共工程決標金額之研究-以高

31.賴碧瑩，「應用類神經網路於電腦輔助大量估價之研究」，住宅學報，第十

evaluating a software bidding model.Information and Software Technology,47(11),747-760。

2.Chua,D.K.H.,Li,D.(2000).Key Factors in Bid Reasoning Model.Journal

10.李宗霖，「以類神經網路模式探討住宅房價影響因子之研究」，國立交通大