home / homework help / questions and answers / science / chemistry / solution co

Question

home / homework help / questions and answers / science / chemistry / solution concentration absorbance 1 ml 64.82 mg/ml ...

Question

Based on this table i need help with excel

1. Enter your data in worksheet. Enter exact concentrations in the first column and absorbance values in the second. Be sure to include the origin (0, 0) as a data point(from calibration of water) for a total of 6 data points

How would i enter this in the table in excel and after I get my scatterplot, how do i add a regression line? Please help

Solution Concentration Absorbance 1 mL 64.82 mg/mL 0.218 2 mL 62.91 mg/mL 0.526 4 mL 66.73 mg/mL 1.005 6 mL 63.66 mg/mL 1.573 8 mL 63.31 mg/mL 1.990

Explanation / Answer

Once you have an excel scatter plot:

- Rigth click any of the points

- Choose add "trend-line"

- From the trend line menu, be sure to choose the model that fits the best:

Once you are done. if you want to include the "origin" be shure to check that as well

Good luck!

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.