Results 1 to 3 of 3

Calculating R-squared for selective data

Threaded View

  1. 12-23-2016, 10:21 PM #1
    L.LEE
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    238

    Calculating R-squared for selective data

    Hi

    I have a range of numbers that sometimes have zero values in between. Is there a formula or automatic method to calculate R-squared only for the non-zero values? I attach my file. Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data layout and plot velocity squared displacement on a graph for physics?
    By ecoimpact in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-21-2015, 09:45 AM
  2. [SOLVED] Calculating Sum of count of 2 variables squared per row
    By ChemistB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2015, 11:50 AM
  3. Calculating selective data
    By karakachanec in forum Excel General
    Replies: 5
    Last Post: 05-30-2015, 04:11 PM
  4. Urgent help needed : combine selective Sheet and selective information in each sheet
    By kennix in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2012, 05:04 AM
  5. [SOLVED] Selective drop down data depending on target cells' data - Help
    By stiganovski in forum Excel General
    Replies: 2
    Last Post: 04-17-2012, 09:35 PM
  6. [SOLVED] linest r-squared bug when calculating forced through zero?
    By Filtration Guy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2005, 09:50 PM
  7. Selective Data
    By MattD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2005, 03:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1