摘要： A variety of user-friendly spreadsheet templates have been developed for geoscience studies. However, the use of the built-in matrix functions within spreadsheet programs, such as Excel, is not particularly straightforward, lowering the value of spreadsheet programs for matrix-based computations, such as multiple regression analyses. Therefore, this study first developed two applications for Excel to perform multiple regression analyses in a much more user-friendly manner. Then using earthquake time histories from a reputable database, a series of regression analyses were performed. A new framework for on-site earthquake early warning based on multiple regression analyses is presented as an alternative to conventional models which were developed with single regression analyses. •A new empirical relationship developed for on-site earthquake early warning.•Application of multiple regression analysis to earthquake early warning.•Two Excel applications for performing multiple regression analysis effectively. 出版者： Elsevier Ltd 出版日期： 2013-08-01 出處： Computers & geosciences, 2013-08, Vol.58, p.1-7 資源來源： Elsevier ScienceDirect Journals Complete 版權： 2013 Elsevier Ltd 識別號： ISSN: 0098-3004 識別號： EISSN: 1873-7803 識別號： DOI: 10.1016/j.cageo.2013.04.018
