+ Reply to Thread
Results 1 to 1 of 1

how to display RSQ function automatically for each sample data

  1. #1
    Registered User
    Join Date
    03-04-2021
    Location
    france
    MS-Off Ver
    2010
    Posts
    3

    how to display RSQ function automatically for each sample data

    Hello,

    I'd like to do a linear regression for each different samples that i have. To save time i was thinking about using RSQ function and see if points seems linear or not. In total i have around 700 samples with uniqual data points. I'd like to have the RSQ from linear regression of thermal conductivity=(f) of temperature (K) and extracting for each sample the slope y-intercept and RSQ values.

    Basically i want something like this. So each value for each compound and doing it automatically. So the strategy could be everytime that compound change take into account the new values...
    test.PNG

    Please find attached the complete table.

    I hope I was clear enough.

    Thank you for your help!
    Attached Files Attached Files

+ 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. [SOLVED] Automatically Search for Excel Data, Display and Print Using VBA
    By Oli641 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2020, 08:37 PM
  2. Help Automatically Selecting Sample
    By Average in forum Excel General
    Replies: 0
    Last Post: 03-07-2017, 11:24 PM
  3. Automatically Display New Chart Data Every Week
    By ericrichard25 in forum Excel General
    Replies: 2
    Last Post: 01-10-2015, 10:04 AM
  4. Running excel macro always display this message "A file named 'sample.xlsm' already exist
    By Jovillanueva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 12:43 AM
  5. Replies: 2
    Last Post: 10-31-2012, 02:52 PM
  6. Replies: 9
    Last Post: 07-31-2012, 04:37 PM
  7. [SOLVED] Function that will automatically display the User Name?
    By ~C in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2006, 09:15 AM

Tags for this Thread

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