کد مقاله کد نشریه سال انتشار مقاله انگلیسی نسخه تمام متن
417948 681595 2008 9 صفحه PDF دانلود رایگان
عنوان انگلیسی مقاله ISI
On the accuracy of statistical procedures in Microsoft Excel 2007
موضوعات مرتبط
مهندسی و علوم پایه مهندسی کامپیوتر نظریه محاسباتی و ریاضیات
پیش نمایش صفحه اول مقاله
On the accuracy of statistical procedures in Microsoft Excel 2007
چکیده انگلیسی

Excel 2007, like its predecessors, fails a standard set of intermediate-level accuracy tests in three areas: statistical distributions, random number generation, and estimation. Additional errors in specific Excel procedures are discussed. Microsoft’s continuing inability to correctly fix errors is discussed. No statistical procedure in Excel should be used until Microsoft documents that the procedure is correct; it is not safe to assume that Microsoft Excel’s statistical procedures give the correct answer. Persons who wish to conduct statistical analyses should use some other package.

ناشر
Database: Elsevier - ScienceDirect (ساینس دایرکت)
Journal: Computational Statistics & Data Analysis - Volume 52, Issue 10, 15 June 2008, Pages 4570–4578
نویسندگان
, ,