As a native German speaker I switch between English and German language a lot. Generally for server components like SQL Server and development environments like Visual Studio I find it much easier to use English versions. For frontends like Excel and PowerBI I also prefer English, however the colleagues who work with my applications usually use German versions.
So I use both.
For Excel this means constantly mixing up colon and semicolon in formulas. Plus I always forget that the German formulas even use Umlaute like “GLÄTTEN”.
For Data Analysis functions I created a little sheet with screenshots of the functions I use. Maybe it can be useful for someone else who also uses German and English version. Here it is: screenshots plus a table for easier copy/paste (if necessary).
By the way, a general dictionary for statistical terms can be found here: German-English English-German
English | German |
---|---|
Data Analysis | Analyse-Funktionen |
Analysis Tools | Analyse-Funktionen |
Anova: Single Factor | Anova: Einfaktorielle Vananzanalyse |
Anova: Two-Factor With Replication | Anova: Zweifaktorielle Varianzanalyse mit Messwiederholung |
Anova: Two-Factor Without Replication | Anova: Zweifaktorielle Vananzanalyse ohne Messwiederholung |
Correlation | Korrelation |
Covanance | Kovarianz |
Descriptive Statistics | Populationskenngrdßen |
Exponential Smoothing | Exponentielles Glätten |
F-Test Two-SampIe for Variances | Zwei-Stichproben F-Test |
Fourier Analysis | Fourieranalyse |
Histogram | Histogramm |
Moving Average | Gleitender Durchschnitt |
Random Number Generation | Zufallszahlengenerierung |
Rank and Percentile | Rang und Quantil |
Regression | Regression |
Sampling | Stichprobenziehung |
t-Test: Paired Two Sample for Means | Zweistichproben t-Test bei abhängigen Stichprober |
t-Test: Two-SampIe Assuming Equal Vanances | Zweistichproben t-Test: Gleicher Varianzen |
t-Test: Two-SampIe Assuming Unequal Vanances | Zweistichproben t-Test: Unterschiedlicher Varianzen |
z-Test: Two Sample for Means | Zweistichproben-Test bei bekannten Varianzen |
Hypothesized Mean Difference | Hypothetische Differenz der Mittelwerte: |
Variable Variance (known) | Varianz für Variable (bekannt) |
Labels | Beschriftungen |
Summary statistics | Statistische Kenngrößen |
Confidence Level for Mean | Konfidenzniveau für Mittelwert |
Kth Largest | k-größter Wert |
Kth Smallest | k-kleinster Wert |
Damping factor | Glättungsparameter |
Standard Errors | Standardfehler |
Residuals | Residuen |
Residual Plots | Residuenplots |
Standardized Residuals | Standardisierte Residuen |
Line Fit Plots | Kurvenanpassung |
Normal Probability | Normalverteilte Wahrscheinlichkeit |
Normal Probability Plots | Quantilsplot |