RExcel:修订间差异
删除的内容 添加的内容
无编辑摘要 |
补救6个来源,并将0个来源标记为失效。) #IABot (v2.0.9.3 |
||
第17行: | 第17行: | ||
== 参考资料 == |
== 参考资料 == |
||
* Baier T., Neuwirth E., De Meo M: [http://journal.r-project.org/archive/2011-2/RJournal_2011-2_Baier~et~al.pdf Creating and Deploying an Application with (R)Excel and R] R Journal 3/2, December 2011 |
* Baier T., Neuwirth E., De Meo M: [http://journal.r-project.org/archive/2011-2/RJournal_2011-2_Baier~et~al.pdf Creating and Deploying an Application with (R)Excel and R] {{Wayback|url=http://journal.r-project.org/archive/2011-2/RJournal_2011-2_Baier~et~al.pdf |date=20221106204318 }} R Journal 3/2, December 2011 |
||
* Baier T. and Neuwirth. E. Excel :: COM :: R. Computational Statistics 22 (2007) |
* Baier T. and Neuwirth. E. Excel :: COM :: R. Computational Statistics 22 (2007) |
||
* Heiberger R. and Neuwirth E. [https://www.springer.com/statistics/computational/book/978-1-4419-0051-7 R Through Excel], Springer Verlag 2009. |
* Heiberger R. and Neuwirth E. [https://www.springer.com/statistics/computational/book/978-1-4419-0051-7 R Through Excel] {{Wayback|url=https://www.springer.com/statistics/computational/book/978-1-4419-0051-7 |date=20090419163650 }}, Springer Verlag 2009. |
||
* Neuwirth, E. [http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf R meets the Workplace] - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund |
* Neuwirth, E. [http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf R meets the Workplace] {{Wayback|url=http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf |date=20221006053742 }} - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund |
||
* Narasimhan, B. [http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Disseminating Statistical Methodology and Results via R and Excel: Two Examples.] Paper presented at the Interface 2007, Philadelphia |
* Narasimhan, B. [http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Disseminating Statistical Methodology and Results via R and Excel: Two Examples.] {{Wayback|url=http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf |date=20120213003722 }} Paper presented at the Interface 2007, Philadelphia |
||
* Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W. [http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Using R for teaching statistics to nonmajors: Comparing experiences of two different approaches.] Paper presented at the UseR 2006, Vienna. |
* Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W. [http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Using R for teaching statistics to nonmajors: Comparing experiences of two different approaches.] {{Wayback|url=http://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf |date=20120213003722 }} Paper presented at the UseR 2006, Vienna. |
||
* Konnert, A. [http://www.r-project.org/useR-2006/Abstracts/Konnert.pdf LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel] Paper presented at the UseR 2006, Vienna. |
* Konnert, A. [http://www.r-project.org/useR-2006/Abstracts/Konnert.pdf LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel] {{Wayback|url=http://www.r-project.org/useR-2006/Abstracts/Konnert.pdf |date=20140103044640 }} Paper presented at the UseR 2006, Vienna. |
||
[[Category:R語言]] |
[[Category:R語言]] |
2023年1月22日 (日) 13:58的版本
本條目存在以下問題,請協助改善本條目或在討論頁針對議題發表看法。
|
RExcel是Microsoft Excel的插件。它允許從Excel中訪問R语言。
主要特點是:
- R和Excel之間雙向數據傳輸(矩陣和數據框)
- 直接從Excel範圍運行R代碼
- 編寫調用R的宏來執行計算而不將R暴露給用戶
- 直接從單元格公式調用R函數,使用Excel的自動更新機制觸發R重新計算
- 使用Excel作為R的GUI,使R功能可通過菜單和對話框訪問,而不是面向命令行的編程風格。使用此範例,廣泛使用的GUI包RCommander可用作Excel菜單欄。
- RExcel適用於Microsoft Windows(XP、Vista或7)以及Excel 2003、2007、2010和2013。它使用statconnDCOM服務器,對於某些配置,還使用rcom包從Excel中訪問R。
参考资料
- Baier T., Neuwirth E., De Meo M: Creating and Deploying an Application with (R)Excel and R (页面存档备份,存于互联网档案馆) R Journal 3/2, December 2011
- Baier T. and Neuwirth. E. Excel :: COM :: R. Computational Statistics 22 (2007)
- Heiberger R. and Neuwirth E. R Through Excel (页面存档备份,存于互联网档案馆), Springer Verlag 2009.
- Neuwirth, E. R meets the Workplace (页面存档备份,存于互联网档案馆) - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund
- Narasimhan, B. Disseminating Statistical Methodology and Results via R and Excel: Two Examples. (页面存档备份,存于互联网档案馆) Paper presented at the Interface 2007, Philadelphia
- Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W. Using R for teaching statistics to nonmajors: Comparing experiences of two different approaches. (页面存档备份,存于互联网档案馆) Paper presented at the UseR 2006, Vienna.
- Konnert, A. LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel (页面存档备份,存于互联网档案馆) Paper presented at the UseR 2006, Vienna.