Question

I need help graphings this in Excel, I am not getting the right best fit line...

I need help graphings this in Excel, I am not getting the right best fit line equation.

It needs to be cell voltage (Ecell) as a function of Log[Cu+2]

Ecell Log(Cu+2)
1.034 0
1.204 -2
1.017 -3
1.1 -4
1.011 -5
0.992 x
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ecell Vs Log[Cu2+] -6 -5 -4 2

First, plot the given points in Excel. Then right click on any one of the points and select the add trendline option. Automatically a linear trendline would be added.

Identify the encircled points (in black) in the graph, to find the equation of the line y = mx + C

The encircled points (x,y) are (-5, 1.06) and (0,1.09)

Solving for m and C,

For (0, 1.09) , 1.09 = m(0) + C => C = 1.09

For (-5, 1.06), 1.06 = m(-5) + 1.09 => m = 0.006

Thus, the equation of the line is y = 0.006x + 1.09

Solve, this equation for y = 0.992

0.992 = 0.006(x) + 1.09 => x = -16.34

Add a comment
Know the answer?
Add Answer to:
I need help graphings this in Excel, I am not getting the right best fit line...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need help with part 2. I keep getting 137 and that is not the right...

    I need help with part 2. I keep getting 137 and that is not the right answer . Part 1 answer is 2.09 nN For best viewing, set zoom level to 'Fit Width' Ar 002 (part 1 of 2) 10.0 points Three charges are arranged as shown in the figure. 2.1 nC 3.7 m -1.8 m O 0.47 nC Find the magnitude of the electro- static force on the charge at the origin. The value of the Coulomb constant is...

  • I need help with this. I am unfamiliar with Ltspice and want to make sure I...

    I need help with this. I am unfamiliar with Ltspice and want to make sure I am doing this right. Please be thorough with your explanations. . Design a high pass filter (Fig. 1) which has a break point fo 1 kHz at 3dB below the midband level (the -3dB point) Uses a C01uF capacitor, and calculate the value for R Vout C 0.1uF、 Vin 5Vac OVdc 2. Use LTspice to perform an AC sweep of your designed circuit from...

  • Need to confirm solution in Multisim. Any help would be greatly appreciated. I am getting R_D=7Kohm...

    Need to confirm solution in Multisim. Any help would be greatly appreciated. I am getting R_D=7Kohm and R_S=3Kohm is this correct ? D 5.44 Design the circuit of Fig. P5.44 to establish a drain current of 0.1 mA and a drain voltage of +0.3 V. The MOSFET has V,-0.5 V, μ"C.-400 μ A/V, L-0.4 μ m. and W-5 μ m. Specify the required values for Rs and RD. +1 V Figure P5.44

  • Please use excel, need help with functions because I am only used to using a financial...

    Please use excel, need help with functions because I am only used to using a financial calculator, thanks! The following cash-flows have two IRRs. Draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRs. Would you invest in this project if the opportunity cost were 20%? Year Cash Flow 0 -500 1 600 2 300 3 300 4 200 5 -1,000

  • I am having trouble getting the right answer to these few questions and I am very much in need of...

    I am having trouble getting the right answer to these few questions and I am very much in need of someone to kindly answer these questions for me correctly please. Thanks. Question 3 0/15 pts Cakculate the change in energy for the transition of the electron from the n 2 level to then 1 level in kJ/mol, using the values of the energy levels calculated above 984.8 Question 4 0/15 pts Find the wavelength in nm of the line emitted...

  • Animal physiology help. I need help with part a and part b. for part a, this...

    Animal physiology help. I need help with part a and part b. for part a, this is as far as I've gotten. The numbers on the left are the contents inside the cell and the numbers on the right are contents outside of the cell. I have converted everything to mM. H+ is hard to see becuase only 10 um passed through the membrane to go outside of the cell. (i dont know how to show this line better on...

  • i need help getting the answer pls All the command line arguments are provided as a...

    i need help getting the answer pls All the command line arguments are provided as a by sys.argv An in-place method is one that returns a new object Select one: O True False

  • I am getting the last one wrong and I don't know why. Help with the 3rd...

    I am getting the last one wrong and I don't know why. Help with the 3rd question please. Мар hile studying a coil of unknown inductance, you connect it in series with an ideal 25.0 V battery and a 1.50 x 102 Q resistor. You then place an oscilloscope across one of these circuit elements and use the oscilloscope to measure the voltage across the circuit element as a function of time. The result is shown in the figure Across...

  • I am getting an error in R and am unsure how to correct it. I am getting an error from the r2 line, "Error in xc[1:(...

    I am getting an error in R and am unsure how to correct it. I am getting an error from the r2 line, "Error in xc[1:(n - 2)] : only 0's may be mixed with negative subscripts." tmpFn <- function(xVec) { xc <- xVec - mean(xVec) denom <- sum(xc^2) n <- length(x) r1 <- sum( xc[2:n] * xc[1:(n-1)] )/denom r2 <- sum( xc[3:n] * xc[1:(n-2)] )/denom list(r1 = r1, r2 = r2) } tmpFn(seq(2, 56, 3)) 10. (a) Given a...

  • I need some help on these two proofs... I know for the first question I am...

    I need some help on these two proofs... I know for the first question I am meant to prove it using the definition of a left/right limit. The second proof I am not too certain. Any help is much appreciated. Thank you! 1. Let f be a function defined on an interval I. Let a be an interior point of I Show that f is continuous at a if and only if both left limit and right limit of f...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT