Hello all,
I just joined this forum and looking forward to get to know more about the users and Excel program.
I have plotted a chart and have R squared value of .9993. My collected data is almost perfectly linear to the nominal value.
I would like to add a Pass or Fail to the spreadsheet that if R^<.980 FAIL and if R^>=.980 PASS
How do I allocate R^ value (The chart) to a cell so I can have a Pass or Fail field somewhere in the spreadsheet? Or is there a way at all?
I can attach this file for you guys to see if you think it helps.
Looking forward to hear from someone with a solution.
Regards
Bookmarks