The method of multivariated linear regression analysis is one of more common quantificational analytic methods in ascertaining the volume weight of mineral ores. The software EXCEL, which is generally utilized at present, can be used to actualize the multivariated linear regression analysis and its control check. Thereby, it can steer clear of the sophisticated techniques such as the program development and comes true the quick speed analysis of volume weight of mineral ores.