HI

linear equation help please...

I have plotted known numbers into an excel spreadsheet and it shows the formula as:

I am struggling to find the answer to x..??

could you go through it step by step please.....am trying to find ppm of a concentration of iron in test sample....

Concentration (ppm=mg/L) were 0 1 2 3 and 5
absorbance was 0 0.190 0.411 0.590 0.975

I graphed these in excel and these results came up y=0.1954x +0.0033

the example given at school had y=0.1954x +0.0033 (r squared =0.9993) and they came up with 2.08 ppm ......

I fail to get how they got that answer...:)

Thanks so much in advance..:)

1 answer

it seems that you generated an equation for finding ppm if you know the absorbance

in the school example, there must have been an absorbance for an unknown ppm

you seem to be missing a piece of data
Similar Questions
  1. How to do Excel Spreadsheet- Formulas?I have to do an excel spreadsheet for my computer class. Problem is my professor didn't at
    1. answers icon 1 answer
    1. answers icon 1 answer
  2. 15.Priya has written a custom function for her excel spreadsheet. What tab does she need to add to her Excel spreadsheet so that
    1. answers icon 1 answer
  3. What is the purpose of the AutoSum feature in Microsoft® Excel?to automatically add all numbers in all cells in a workbook to
    1. answers icon 3 answers
more similar questions