What is the function for R-SQuare in Excel?

Posted on 2007-10-03
Last Modified: 2011-10-03
Hi Experts,

What is the function for R-square in Excel? I have a function for slope and intercept but I am missing R-square to test a set of data for trend.

Question by:indyng
    LVL 10

    Accepted Solution

    RSQ(known_y's, known_x's)
    LVL 33

    Expert Comment

    You also might take a look at this article:
    You will receive an incorrect R-squared value in the chart tool in Excel 2003

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Fix45 challenge 15 66
    bigHeights  challenge 13 43
    stringclean challenge 26 43
    nestparen challenge 4 36
    This is about my first experience with programming Arduino.
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
    Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now