+ Reply to Thread
Results 1 to 12 of 12

How good is Google Translate?

  1. #1
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,639

    How good is Google Translate?

    A new thread to divert the hijack in another thread.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,639

    Re: How good is Google Translate?

    If we put in the phrase

    It can, 99.9% of the time if you use proper English that is stored in their databases, instead of new-age slang that we are so used to.

    and translate to Spanish, then take that result and translate back to English, we get:

    You can, 99.9% of the time, if you use the proper English that is stored in your databases, rather than the new age jargon we are so used to.

    It gets the idea across but makes a critical error in the possessive changing from their to your. This is a common error in machine translation from English to romance languages because the possessive in English agrees with the possessor, where in romance languages it agrees with the thing that is possessed. In romance languages one gets the meaning from context, but AI translators like Google Translate can't match a human for that.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    25,371

    Re: How good is Google Translate?

    It's fine for casual stuff, where 100% accuracy is not required. I wouldn't want my surgeon to use it to translate instructions on where to insert the scalpel, which way to turn it, and how far to slice !!
    Glenn



  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,455

    Re: How good is Google Translate?

    This being said, what one mostly encounters on the Net is more Globish than English proper, so let's not be "more Catholic than the Pope"
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: How good is Google Translate?

    'creamier than the pope' I'd formulate.



  6. #6
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    Re: How good is Google Translate?

    Quote Originally Posted by Pepe Le Mokko View Post
    so let's not be "more Catholic than the Pope"
    hey now! don't make fun of my catholic life, dude! by the way, you guys seen this!?

    https://www.cnn.com/2020/11/20/europ...cli/index.html

    hackers!!! there are no better ones than those in Italy. But then again, Israel has got their fair share. see here:

    https://www.theguardian.com/technolo...i-crown-prince

    https://en.wikipedia.org/wiki/Hack_o...ezos%27s_phone
    -Adam (please don't call me ""sir"" or ""vba_php"")!

  7. #7
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,455

    Re: How good is Google Translate?

    hey now! don't make fun of my catholic life, dude!
    I suppose that is intended as a joke?

  8. #8
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    Re: How good is Google Translate?

    Quote Originally Posted by Pepe Le Mokko View Post
    I suppose that is intended as a joke?
    rarely am I serious in this ridiculous place we call Earth.

  9. #9
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    Re: How good is Google Translate?

    ENGLISH INPUT:
    this is a proper sentence in the english language.

    GERMAN OUTPUT:
    Dies ist ein richtiger Satz in der englischen Sprache.

    GERMAN INPUT:
    Dies ist ein richtiger Satz in der englischen Sprache.

    ENGLISH OUTPUT:
    This is a correct sentence in the English language.

    not too bad, it doesn't seem to me!

  10. #10
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    855

    Re: How good is Google Translate?

    Unfair to use it in a romance language without a neuter pronoun.

    English -> German -> English: It can happen 99.9% of the time that you are using correct English stored in the databases instead of the New Age slang we are used to.

    English -> Russian -> English: This is possible 99.9% of the time if you use the correct English that is stored in their databases, instead of the new era slang we are so used to.

    English -> Arabic -> English: It can, 99.9% of the time if you use the correct English stored in their databases, rather than the modern colloquial we are used to.

    English -> Korean -> English: 99.9% of the time is possible if we use the proper English stored in our database instead of the new era slang we are used to.

    Which is closer?

    It seems it helps for different languages to have similar pronoun structures, e.g., English, which is in some ways still Saxon, and German not so distant cousins. Interesting that Arabic is close to English and German in this respect but with a vocabulary which seems to lack slang. Not surprising to me that Korean is furthest off due to grammar and vocabulary.

    I figure there's also a problem translating modern English in which damn few native speakers remember it possesses a subjunctive mood into languages whose native speakers do a much better job incorporating the subjunctive. That'd be my guess for why the German route eliminated the if. Then again, German being German may note the 99.9% EMPLOYS probability rather than IMPLYING a hypothetical, thus if is ill-considered in this instance. What I mean is that different languages WILL reflect different cultural perspectives, so Germans may well view probability differently than English or Americans, Russians, Arabs, Koreans, maybe others, maybe even everyone else.

  11. #11
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    855

    Re: How good is Google Translate?

    I'd expect greater accuracy for technical vocabulary coupled with simple grammar than everyday vocabulary coupled with tortured grammar.

    Consider the classic example of English abhorring ending clauses with a preposition: This is behavior up with which I will not put.

    English -> German -> English: This is behavior I will not deal with. Interesting that this drops either 'which' or 'that'.

    English -> Spanish -> English: This is behavior that I will not deal with.

    English -> Russian -> English: This is a behavior that I will not speak to. Note the appearance of the indefinite article 'a' which doesn't exist in Russian.

    English -> Arabic -> English: This is behavior I will not deal with.

    English -> Korean -> English: This is an action I won't cover.

    Interpretation: Google doesn't have many Korean speakers working on Google Translate. Fascinating that the German and Arabic routes produce the same exact result.

    Now for some technical writing (math/stats rather than medicine, what I have on hand): This family of distributions contains the multivariate normal, Studentís t, exponential power, and Pearson type II, but with an extra parameter to regulate skewness.

    English -> German -> English: This distribution family includes the multivariate normal, Student-t, exponential, and Pearson Type II distributions, but with an additional parameter to regulate skewness.

    English -> Spanish -> English: This family of distributions contains the multivariate normal, Student's t, exponential power and Pearson's type II, but with an additional parameter to regulate skewness.

    English -> Russian -> English: This family of distributions contains multivariate normal, Student's t, exponential, and Pearson type II, but with an additional parameter to adjust skewness.

    English -> Arabic -> English: This set of distributions contains multivariate normal variables, Student's t, Exponential power, and Pearson Type II, but with an additional parameter for regulating declination.

    English -> Korean -> English: This distribution group includes multivariate normal, Student's t, exponential power, and Pearson type II, but has additional parameters that control skewness.

    Interesting that German and Russian change 'exponential power' to 'exponential'. This may be convention in German and Russian math/stats because the exponential distribution is the exponential power distribution with shape parameter = 1. In a similar sense, the Pareto distribution is the Burr distribution with 2nd shape parameter 0. If it's the case that German and Russian mathematicians and statisticians make no distinction between what English speaking mathematicians and statisticians distinguish as exponential and exponential power distributions, that implies a lack of 1-to-1 correspondence of technical terms between English and German or Russian which could be a problem. However, that's common between English and continental European languages. Consider the English billion and the French or German Milliard[e].

    Also note that the Arabic route translates family to set, which in math/stats is OK, but the Korean route translates family as group, and group has special meaning in algebra, so should be avoided as a general synonym for family/set/collection in other branches of mathematics.

    Verdict: don't rely on Google Translate for translations between Asian and non-Asian languages.

  12. #12
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,678

    Re: How good is Google Translate?

    Well I think that's a given. Asian languages are extremely complex when compared to english, but English compared to other derivatives like Spanish or Italian or Portuguese or French that would be a different story. But then again I think the derivative nature goes in reverse English was derived more or less from all the foreign languages so essentially yeah it goes Spanish, french, german, Italian, and then comes English a long time later.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro: translate text from cell using google translate
    By Marc_excel_tips in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-24-2020, 12:13 AM
  2. [SOLVED] Get google translate result from vba?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-25-2020, 02:52 PM
  3. Translate English to French without using Google Translate
    By shaunafink in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2019, 12:08 PM
  4. Translate text from cell using Google translate (2)
    By Andreea1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2019, 07:36 AM
  5. Google Translate VBA Function
    By beardguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2018, 06:17 PM
  6. How to catch errors from Google Translate
    By MrsMac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2014, 09:18 AM
  7. need Google Translate in Excel 2003
    By appu_gusai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 08:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1