Statistical analysis in Google Sheets, with functions matching the Analysis ToolPak in desktop Excel.
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2024๋…„ 5์›” 21์ผ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
356๋งŒ+
๊ฐœ์š”
With the XLMiner Analysis ToolPak Add-on, you can easily perform statistical analyses of the same types available in the Analysis ToolPak add-in that has been part of Microsoft Excel for over 20 years, and has been featured in large numbers of textbooks, videos, statistics courses and the like.

The add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression.  Sidebar input fields and output on the spreadsheet will be very familiar to Excel Analysis ToolPak users.

The 20 functions are:
ANOVA: Single Factor
ANOVA: Two-Factor with Replication
ANOVA: Two-Factor without Replication
Correlation
Covariance
Descriptive Statistics
Exponential Smoothing
F-Test Two-Sample for Variances
Fourier Analysis
Histogram
Linear Regression
Logistic Regression
Moving Average
Random Number Generation
Rank and Percentile
Sampling
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Paired Two-Sample for Means

Results will generally match the Excel Analysis ToolPak, as seen in many textbooks, screen images and videos.  The add-on's Random Number Generation function uses the Mersenne Twister algorithm.
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ๋ฌด๋ฃŒ
๊ฐœ๋ฐœ์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
XLMiner Analysis ToolPak์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
XLMiner Analysis ToolPak์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด XLMiner Analysis ToolPak์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
๋Œ“๊ธ€ ์—†์Œ
๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
Google ์•ฑ
๊ธฐ๋ณธ ๋ฉ”๋‰ด