@@ -17,7 +17,7 @@ discard block |
||
17 | 17 | * |
18 | 18 | * @param mixed ...$args Data values |
19 | 19 | */ |
20 | - public static function sumSquares(mixed ...$args): string|float |
|
20 | + public static function sumSquares(mixed ...$args): string | float |
|
21 | 21 | { |
22 | 22 | $aArgs = Functions::flattenArrayIndexed($args); |
23 | 23 | |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * |
58 | 58 | * @param array ...$args Data Series |
59 | 59 | */ |
60 | - public static function kurtosis(...$args): string|int|float |
|
60 | + public static function kurtosis(...$args): string | int | float |
|
61 | 61 | { |
62 | 62 | $aArgs = Functions::flattenArrayIndexed($args); |
63 | 63 | $mean = Averages::average($aArgs); |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | * |
103 | 103 | * @return float|int|string The result, or a string containing an error |
104 | 104 | */ |
105 | - public static function skew(...$args): string|int|float |
|
105 | + public static function skew(...$args): string | int | float |
|
106 | 106 | { |
107 | 107 | $aArgs = Functions::flattenArrayIndexed($args); |
108 | 108 | $mean = Averages::average($aArgs); |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | * |
19 | 19 | * @param mixed ...$args Data values |
20 | 20 | */ |
21 | - public static function min(mixed ...$args): float|int|string |
|
21 | + public static function min(mixed ...$args): float | int | string |
|
22 | 22 | { |
23 | 23 | $returnValue = null; |
24 | 24 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | * |
56 | 56 | * @param mixed ...$args Data values |
57 | 57 | */ |
58 | - public static function minA(mixed ...$args): float|int|string |
|
58 | + public static function minA(mixed ...$args): float | int | string |
|
59 | 59 | { |
60 | 60 | $returnValue = null; |
61 | 61 |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | * @param mixed $yValues array of mixed Data Series Y |
66 | 66 | * @param null|mixed $xValues array of mixed Data Series X |
67 | 67 | */ |
68 | - public static function CORREL(mixed $yValues, $xValues = null): float|string |
|
68 | + public static function CORREL(mixed $yValues, $xValues = null): float | string |
|
69 | 69 | { |
70 | 70 | if (($xValues === null) || (!is_array($yValues)) || (!is_array($xValues))) { |
71 | 71 | return ExcelError::VALUE(); |
@@ -91,7 +91,7 @@ discard block |
||
91 | 91 | * @param mixed[] $yValues array of mixed Data Series Y |
92 | 92 | * @param mixed[] $xValues array of mixed Data Series X |
93 | 93 | */ |
94 | - public static function COVAR(array $yValues, array $xValues): float|string |
|
94 | + public static function COVAR(array $yValues, array $xValues): float | string |
|
95 | 95 | { |
96 | 96 | try { |
97 | 97 | self::checkTrendArrays($yValues, $xValues); |
@@ -178,7 +178,7 @@ discard block |
||
178 | 178 | * @param mixed[] $yValues Data Series Y |
179 | 179 | * @param mixed[] $xValues Data Series X |
180 | 180 | */ |
181 | - public static function INTERCEPT(array $yValues, array $xValues): float|string |
|
181 | + public static function INTERCEPT(array $yValues, array $xValues): float | string |
|
182 | 182 | { |
183 | 183 | try { |
184 | 184 | self::checkTrendArrays($yValues, $xValues); |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | * |
206 | 206 | * @return array|string The result, or a string containing an error |
207 | 207 | */ |
208 | - public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array |
|
208 | + public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array |
|
209 | 209 | { |
210 | 210 | $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const); |
211 | 211 | $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats); |
@@ -266,7 +266,7 @@ discard block |
||
266 | 266 | * |
267 | 267 | * @return array|string The result, or a string containing an error |
268 | 268 | */ |
269 | - public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array |
|
269 | + public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array |
|
270 | 270 | { |
271 | 271 | $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const); |
272 | 272 | $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats); |
@@ -377,7 +377,7 @@ discard block |
||
377 | 377 | * @param mixed[] $yValues Data Series Y |
378 | 378 | * @param mixed[] $xValues Data Series X |
379 | 379 | */ |
380 | - public static function STEYX(array $yValues, array $xValues): float|string |
|
380 | + public static function STEYX(array $yValues, array $xValues): float | string |
|
381 | 381 | { |
382 | 382 | try { |
383 | 383 | self::checkTrendArrays($yValues, $xValues); |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | * |
38 | 38 | * @param mixed ...$args Data values |
39 | 39 | */ |
40 | - public static function STDEVA(mixed ...$args): float|string |
|
40 | + public static function STDEVA(mixed ...$args): float | string |
|
41 | 41 | { |
42 | 42 | $result = Variances::VARA(...$args); |
43 | 43 | if (!is_numeric($result)) { |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * |
58 | 58 | * @param mixed ...$args Data values |
59 | 59 | */ |
60 | - public static function STDEVP(mixed ...$args): float|string |
|
60 | + public static function STDEVP(mixed ...$args): float | string |
|
61 | 61 | { |
62 | 62 | $result = Variances::VARP(...$args); |
63 | 63 | if (!is_numeric($result)) { |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | * |
78 | 78 | * @param mixed ...$args Data values |
79 | 79 | */ |
80 | - public static function STDEVPA(mixed ...$args): float|string |
|
80 | + public static function STDEVPA(mixed ...$args): float | string |
|
81 | 81 | { |
82 | 82 | $result = Variances::VARPA(...$args); |
83 | 83 | if (!is_numeric($result)) { |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | * |
19 | 19 | * @param mixed ...$args Data values |
20 | 20 | */ |
21 | - public static function max(mixed ...$args): float|int|string |
|
21 | + public static function max(mixed ...$args): float | int | string |
|
22 | 22 | { |
23 | 23 | $returnValue = null; |
24 | 24 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | * |
56 | 56 | * @param mixed ...$args Data values |
57 | 57 | */ |
58 | - public static function maxA(mixed ...$args): float|int|string |
|
58 | + public static function maxA(mixed ...$args): float | int | string |
|
59 | 59 | { |
60 | 60 | $returnValue = null; |
61 | 61 |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | * |
24 | 24 | * @param mixed ...$args Data values |
25 | 25 | */ |
26 | - public static function geometric(mixed ...$args): float|int|string |
|
26 | + public static function geometric(mixed ...$args): float | int | string |
|
27 | 27 | { |
28 | 28 | $aArgs = Functions::flattenArray($args); |
29 | 29 | |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | * |
50 | 50 | * @param mixed ...$args Data values |
51 | 51 | */ |
52 | - public static function harmonic(mixed ...$args): string|float|int |
|
52 | + public static function harmonic(mixed ...$args): string | float | int |
|
53 | 53 | { |
54 | 54 | // Loop through arguments |
55 | 55 | $aArgs = Functions::flattenArray($args); |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | * |
91 | 91 | * @param mixed $args Data values |
92 | 92 | */ |
93 | - public static function trim(mixed ...$args): float|string |
|
93 | + public static function trim(mixed ...$args): float | string |
|
94 | 94 | { |
95 | 95 | $aArgs = Functions::flattenArray($args); |
96 | 96 |
@@ -28,7 +28,7 @@ discard block |
||
28 | 28 | * @param null|array|string $condition the criteria that defines which cells will be checked |
29 | 29 | * @param mixed $averageRange Data values |
30 | 30 | */ |
31 | - public static function AVERAGEIF(mixed $range, null|array|string $condition, mixed $averageRange = []): null|int|float|string |
|
31 | + public static function AVERAGEIF(mixed $range, null | array | string $condition, mixed $averageRange = []): null | int | float | string |
|
32 | 32 | { |
33 | 33 | if (!is_array($range) || !is_array($averageRange) || array_key_exists(0, $range) || array_key_exists(0, $averageRange)) { |
34 | 34 | throw new CalcException('Must specify range of cells, not any kind of literal'); |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | * |
50 | 50 | * @param mixed $args Pairs of Ranges and Criteria |
51 | 51 | */ |
52 | - public static function AVERAGEIFS(mixed ...$args): null|int|float|string |
|
52 | + public static function AVERAGEIFS(mixed ...$args): null | int | float | string |
|
53 | 53 | { |
54 | 54 | if (empty($args)) { |
55 | 55 | return 0.0; |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | * @param mixed[] $range Data values |
80 | 80 | * @param null|array|string $condition the criteria that defines which cells will be counted |
81 | 81 | */ |
82 | - public static function COUNTIF(array $range, null|array|string $condition): string|int |
|
82 | + public static function COUNTIF(array $range, null | array | string $condition): string | int |
|
83 | 83 | { |
84 | 84 | // Filter out any empty values that shouldn't be included in a COUNT |
85 | 85 | $range = array_filter( |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | * |
104 | 104 | * @param mixed $args Pairs of Ranges and Criteria |
105 | 105 | */ |
106 | - public static function COUNTIFS(mixed ...$args): int|string |
|
106 | + public static function COUNTIFS(mixed ...$args): int | string |
|
107 | 107 | { |
108 | 108 | if (empty($args)) { |
109 | 109 | return 0; |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * |
128 | 128 | * @param mixed $args Pairs of Ranges and Criteria |
129 | 129 | */ |
130 | - public static function MAXIFS(mixed ...$args): null|float|string |
|
130 | + public static function MAXIFS(mixed ...$args): null | float | string |
|
131 | 131 | { |
132 | 132 | if (empty($args)) { |
133 | 133 | return 0.0; |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | * |
150 | 150 | * @param mixed $args Pairs of Ranges and Criteria |
151 | 151 | */ |
152 | - public static function MINIFS(mixed ...$args): null|float|string |
|
152 | + public static function MINIFS(mixed ...$args): null | float | string |
|
153 | 153 | { |
154 | 154 | if (empty($args)) { |
155 | 155 | return 0.0; |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | * |
172 | 172 | * @param array $range Data values |
173 | 173 | */ |
174 | - public static function SUMIF(array $range, mixed $condition, array $sumRange = []): null|float|string |
|
174 | + public static function SUMIF(array $range, mixed $condition, array $sumRange = []): null | float | string |
|
175 | 175 | { |
176 | 176 | $database = self::databaseFromRangeAndValue($range, $sumRange); |
177 | 177 | $condition = [[self::CONDITION_COLUMN_NAME, self::VALUE_COLUMN_NAME], [$condition, null]]; |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | * |
190 | 190 | * @param mixed $args Pairs of Ranges and Criteria |
191 | 191 | */ |
192 | - public static function SUMIFS(mixed ...$args): null|float|string |
|
192 | + public static function SUMIFS(mixed ...$args): null | float | string |
|
193 | 193 | { |
194 | 194 | if (empty($args)) { |
195 | 195 | return 0.0; |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | * |
21 | 21 | * @return float|string (string if result is an error) |
22 | 22 | */ |
23 | - public static function averageDeviations(mixed ...$args): string|float |
|
23 | + public static function averageDeviations(mixed ...$args): string | float |
|
24 | 24 | { |
25 | 25 | $aArgs = Functions::flattenArrayIndexed($args); |
26 | 26 | |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | * |
70 | 70 | * @return float|int|string (string if result is an error) |
71 | 71 | */ |
72 | - public static function average(mixed ...$args): string|int|float |
|
72 | + public static function average(mixed ...$args): string | int | float |
|
73 | 73 | { |
74 | 74 | $returnValue = $aCount = 0; |
75 | 75 | |
@@ -108,7 +108,7 @@ discard block |
||
108 | 108 | * |
109 | 109 | * @return float|int|string (string if result is an error) |
110 | 110 | */ |
111 | - public static function averageA(mixed ...$args): string|int|float |
|
111 | + public static function averageA(mixed ...$args): string | int | float |
|
112 | 112 | { |
113 | 113 | $returnValue = null; |
114 | 114 | |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | * |
148 | 148 | * @return float|string The result, or a string containing an error |
149 | 149 | */ |
150 | - public static function median(mixed ...$args): float|string |
|
150 | + public static function median(mixed ...$args): float | string |
|
151 | 151 | { |
152 | 152 | $aArgs = Functions::flattenArray($args); |
153 | 153 | |
@@ -181,7 +181,7 @@ discard block |
||
181 | 181 | * |
182 | 182 | * @return float|string The result, or a string containing an error |
183 | 183 | */ |
184 | - public static function mode(mixed ...$args): float|string |
|
184 | + public static function mode(mixed ...$args): float | string |
|
185 | 185 | { |
186 | 186 | $returnValue = ExcelError::NA(); |
187 | 187 | |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | * Special variant of array_count_values that isn't limited to strings and integers, |
212 | 212 | * but can work with floating point numbers as values. |
213 | 213 | */ |
214 | - private static function modeCalc(array $data): float|string |
|
214 | + private static function modeCalc(array $data): float | string |
|
215 | 215 | { |
216 | 216 | $frequencyArray = []; |
217 | 217 | $index = 0; |
@@ -27,7 +27,7 @@ |
||
27 | 27 | * @return array|float|string If an array of numbers is passed as an argument, then the returned result will also be an array |
28 | 28 | * with the same dimensions |
29 | 29 | */ |
30 | - public static function distribution(mixed $value, mixed $lambda, mixed $cumulative): array|string|float |
|
30 | + public static function distribution(mixed $value, mixed $lambda, mixed $cumulative): array | string | float |
|
31 | 31 | { |
32 | 32 | if (is_array($value) || is_array($lambda) || is_array($cumulative)) { |
33 | 33 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $lambda, $cumulative); |