Google Workspace Marketplace
Descriptive statistics, correlation, regression, t-tests, ANOVA and histograms in Google Sheets™, each as a table in a new sheet, like the classic data analysis add-in. Free, only the open file.
بواسطة:
تم تحديث البيانات في:10 نوفمبر 2026
يتوافق مع:
ليست هناك مراجعات
136
نظرة عامة
Select your data with its headers, open Extensions › Statistics Tools and pick the analysis: the result appears in a new sheet as a finished table, with the same rows and labels as the classic data analysis add-in (Analysis ToolPak), so the numbers can be compared line by line with a textbook, a course or a colleague's spreadsheet. Results are written as fixed values: change the data and run the tool again.

The tools
• Descriptive statistics: one block per column (mean, standard error, median, mode, standard deviation, variance, kurtosis, skewness, range, sum, count, confidence level).
• Correlation and covariance: the matrix of the selected columns. Rank and percentile: each value with its rank and percent.
• Regression: the first column is Y, the others are X (one or several), with Multiple R, R Square, ANOVA table and coefficients with standard errors, t Stat, P-value and 95% limits.
• t-Test: paired two sample, two-sample equal variances, two-sample unequal variances, and one sample against a value you type.
• F-Test two-sample for variances.
• ANOVA single factor (one group per column) and ANOVA two-factor, with or without replication (rows × columns, balanced design).
• Histogram: frequency table with your bin limits or automatic bins, cumulative %, Pareto order and a chart.
Need data to try it? Create example sheet, in the same menu, adds a sheet with sample data ready to analyse. Not included yet: z-Test, moving average, sampling, exponential smoothing, random number generation, Fourier analysis.

Blank cells and text are ignored; the headers become the labels of the tables. The formulas are the standard ones (sample variance, Student's t and Fisher's F distributions) and the results are checked against published reference values.

Private and free: everything happens inside your spreadsheet. No servers of ours, no tracking, no account to create, no access to your other files. It only asks for permission to edit the spreadsheet it is open in.

Handy for quality control, surveys, lab reports, coursework, theses and any analysis that used to be done with the data analysis add-in of a desktop spreadsheet.
Menus, tables and messages in English, Spanish, Portuguese, French, German and Italian.

Support: support@singletasktools.com · https://singletasktools.com/statistics-tools/
Single Task Tools is a small independent studio from Spain. Each tool does one job and asks for the minimum access possible.
Google Sheets™ is a trademark of Google LLC. Analysis ToolPak is a feature of Microsoft Excel; Single Task Tools is not affiliated with Microsoft.
معلومات إضافية
الأسعارمجانًا
مطوّر برامج
غير تاجر
الدعم
سياسة الخصوصية
بنود الخدمة
سيطلب منك التطبيق Statistics Tools: t-Test, ANOVA & Regression الأذونات المُوضَحة أدناه. مزيد من المعلومات
سيحتاج التطبيق Statistics Tools: t-Test, ANOVA & Regression إلى الدخول إلى حسابك على Google.
سيسمح ذلك لتطبيق Statistics Tools: t-Test, ANOVA & Regression بما يلي:
عرض جداول البيانات التي تمّ تثبيت هذا التطبيق فيها، وإدارتها
الاطّلاع على عنوان البريد الإلكتروني الرئيسي لحسابك على Google
الاطّلاع على بياناتك الشخصية، بما في ذلك أيّ بيانات شخصية قد جعلتها متاحة للجميع
التعليقات
اللغة:
ترتيب بحسب:
لا تتحقق Google من المراجعات أو التقييمات. مزيد من المعلومات حول المراجعات
لا تعليقات
بحث
محو البحث
إغلاق البحث
تطبيقات Google
القائمة الرئيسية