Difference between revisions of "Documentation/How Tos/Calc: RSQ function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{DISPLAYTITLE:RSQ function}}
−
|bookid=1234'''
+
{{Documentation/CalcFunc StatisticalTOC
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_PEARSON_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_SLOPE_function|
+
|NextPage=Documentation/How_Tos/Calc:_SLOPE_function
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_PEARSON_function
+
}}__NOTOC__
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
+
−
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Text_functions
+
−
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of Central Tendency</div>
+
−
* [[Documentation/How_Tos/Calc:_AVEDEV_function|<div style="font-size: 120%;">Avedev]]
+
−
* [[Documentation/How_Tos/Calc:_AVERAGE_function|<div style="font-size: 120%;">Average]]
+
−
* [[Documentation/How_Tos/Calc:_AVERAGEA_function|<div style="font-size: 120%;">Averagea]]
+
−
* [[Documentation/How_Tos/Calc:_COUNT_function|<div style="font-size: 120%;">Count]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTA_function|<div style="font-size: 120%;">Counta]]
+
−
* [[Documentation/How_Tos/Calc:_GEOMEAN_function|<div style="font-size: 120%;">Geomean]]
+
−
* [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%;">Hearmean]]
+
−
* [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;">Median]]
+
−
* [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;">Mode]]
+
−
* [[Documentation/How_Tos/Calc:_TRIMMEAN_function|<div style="font-size: 120%;">Trimmean]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of dispersion / spread</div>
+
−
* [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;">Devsq]]
+
−
* [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;">Kurt]]
+
−
* [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;">Skew]]
+
−
* [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;">Stdev]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%;">Stedeva]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;">Stdevp]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;">Stdevpa]]
+
−
* [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;">Var]]
+
−
* [[Documentation/How_Tos/Calc:_VARA_function|<div style="font-size: 120%;">Vara]]
+
−
* [[Documentation/How_Tos/Calc:_VARP_function|<div style="font-size: 120%;">Varp]]
+
−
* [[Documentation/How_Tos/Calc:_VARPA_function|<div style="font-size: 120%;">Varpa]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Probability and statistics</div>
+
−
* [[Documentation/How_Tos/Calc:_B_function|<div style="font-size: 120%;">B]]
+
−
* [[Documentation/How_Tos/Calc:_BETADIST_function|<div style="font-size: 120%;">Betadist]]
+
−
* [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;">Betainv]]
+
−
* [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;">Binomdist]]
+
−
* [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;">Chidist]]
+
−
* [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;">Chiinv]]
+
−
* [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;">Chisqinv]]
+
−
* [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;">Chitest]]
+
−
* [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;">Confidence]]
+
−
* [[Documentation/How_Tos/Calc:_CRITBINOM_function|<div style="font-size: 120%;">Critbinom]]
+
−
* [[Documentation/How_Tos/Calc:_EXPONDIST_function|<div style="font-size: 120%;">Expondist]]
+
−
* [[Documentation/How_Tos/Calc:_FINV_function|<div style="font-size: 120%;">Finv]]
+
−
* [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;">Fisher]]
+
−
* [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;">Fisherinv]]
+
−
* [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%;">Fdist]]
+
−
* [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;">Ftest]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;">Gamma]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;">Gammainv]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMALN_function|<div style="font-size: 120%;">Gammaln]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMADIST_function|<div style="font-size: 120%;">Gammadist]]
+
−
* [[Documentation/How_Tos/Calc:_GAUSS_function|<div style="font-size: 120%;">Gauss]]
+
−
* [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;">Hypgeomdist]]
+
−
* [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;">Loginv]]
+
−
* [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;">Lognormdist]]
+
−
* [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;">Negbinomdist]]
+
−
* [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;">Norminv]]
+
−
* [[Documentation/How_Tos/Calc:_NORMDIST_function|<div style="font-size: 120%;">Normdist]]
+
−
* [[Documentation/How_Tos/Calc:_NORMSINV_function|<div style="font-size: 120%;">Normsinv]]
+
−
* [[Documentation/How_Tos/Calc:_NORMSDIST_function|<div style="font-size: 120%;">Normsdist]]
+
−
* [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;">Permut]]
+
−
* [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;">Permutationa]]
+
−
* [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;">Phi]]
+
−
* [[Documentation/How_Tos/Calc:_POISSON_function|<div style="font-size: 120%;">Poisson]]
+
−
* [[Documentation/How_Tos/Calc:_PROB_function|<div style="font-size: 120%;">Prob]]
+
−
* [[Documentation/How_Tos/Calc:_STANDARDIZE_function|<div style="font-size: 120%;">Standardize]]
+
−
* [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;">Tdist]]
+
−
* [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;">Tinv]]
+
−
* [[Documentation/How_Tos/Calc:_TTEST_function|<div style="font-size: 120%;">Ttest]]
+
−
* [[Documentation/How_Tos/Calc:_WEIBULL_function|<div style="font-size: 120%;">Weibull]]
+
−
* [[Documentation/How_Tos/Calc:_ZTEST_function|<div style="font-size: 120%;">Ztest]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Correlation and line fitting</div>
+
−
* [[Documentation/How_Tos/Calc:_CORREL_function|<div style="font-size: 120%;">Correl]]
+
−
* [[Documentation/How_Tos/Calc:_COVAR_function|<div style="font-size: 120%;">Covar]]
+
−
* [[Documentation/How_Tos/Calc:_FORECAST_function|<div style="font-size: 120%;">Forecast]]
+
−
* [[Documentation/How_Tos/Calc:_INTERCEPT_function|<div style="font-size: 120%;">Intercept]]
+
−
* [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]]
+
−
* [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Rsq]]
+
−
* [[Documentation/How_Tos/Calc:_SLOPE_function|<div style="font-size: 120%;">Slope]]
+
−
* [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]]
+
−
<div style="font-size: 110%;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div>
+
−
* [[Documentation/How_Tos/Calc:_LARGE_function|<div style="font-size: 120%;">Large]]
+
−
* [[Documentation/How_Tos/Calc:_MAX_function|<div style="font-size: 120%;">Max]]
+
−
* [[Documentation/How_Tos/Calc:_MAXA_function|<div style="font-size: 120%;">Maxa]]
+
−
* [[Documentation/How_Tos/Calc:_MIN_function|<div style="font-size: 120%;">Min]]
+
−
* [[Documentation/How_Tos/Calc:_MINA_function|<div style="font-size: 120%;">Mina]]
+
−
* [[Documentation/How_Tos/Calc:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]]
+
−
* [[Documentation/How_Tos/Calc:_PERCENTRANK_function|<div style="font-size: 120%;">Percentrank]]
+
−
* [[Documentation/How_Tos/Calc:_QUARTILE_function|<div style="font-size: 120%;">Quartile]]
+
−
* [[Documentation/How_Tos/Calc:_RANK_function|<div style="font-size: 120%;">Rank]]
+
−
* [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]]
+
−
}}__TOC__
+
  
 
== RSQ ==
 
== RSQ ==
Line 120: Line 26:
 
: returns the square of the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
 
: returns the square of the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 
* [[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 
* [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
 
* [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]

Latest revision as of 14:45, 2 February 2024



RSQ

Returns the square of the Pearson correlation coefficient of two sets of data.

Syntax:

RSQ(x; y)

where x and y are ranges or arrays containing the two sets of data.
Any text or empty entries are ignored.
RSQ calculates the square of the Pearson correlation coefficient (which is conventionally given the letter r, hence "r squared"). See the * PEARSON function for more details.
RSQ indicates how much of the variance in y is attributable to the variance in x.
Advanced topic:
The parameters x and y are always evaluated as array formulas.

Example:

RSQ(A1:A30; B1:B30)

returns the square of the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_RSQ_function&oldid=260077"
Views
Personal tools
Navigation
Tools