Sheet1

Group members:
Part I: do some basic operations on a given data set. Then plot a specific part of the data set.
ABCA+B
Neeharika Thakur: Neeharika Thakur: In cell D4 type =a4+b4 and then Enter. You will see the result in cell D4. Does this value make sense? It is important to assess your calculations or measurements every time. This means: check that (1) your work is indeed fine because you get the expected results or (2) all your calculations and measurements are fine/correct but somehow you still get a result that is far from what you expected, (3) If the result is different from expectation: can you explain the discrepancy by considering factors that may have affected your measurements/calculations/results?, and (4) even if all of your work is correct but you still can’t explain the discrepancy great or small, that is also superb because there is a chance that you have some new results that you and/or others must explore to prove/disprove! After you have considered (at the least) the aforementioned steps, you can proceed to the next step. In this case Copy this down to the very last cell of this set. So copy through D11.
A-B
Neeharika Thakur: Neeharika Thakur: In cell E4 type =a4-b4 and then Enter. Copy this down to the very last cell of this set. So copy through E11
2A (same as 2 x A)
Neeharika Thakur: Neeharika Thakur: In cell F4 type =2*a4 and then Enter. Copy this down to the very last cell of this set. So copy through F11
A x B
Neeharika Thakur: Neeharika Thakur: In cell G4 type =a4*b4 and then Enter. Copy this down to the very last cell of this set. So copy through G11
A / B
Neeharika Thakur: Neeharika Thakur: In cell H4 type =a4/b4 and then Enter. Copy this down to the very last cell of this set. So copy through H11
X = A
Neeharika Thakur: Neeharika Thakur: In cell J4 type =a4 and then Enter. Copy this down to the very last cell of this set. So copy through J11
Y= 3X+2
Neeharika Thakur: Neeharika Thakur: In cell J4 type =3*I4+2 and then Enter. Copy this down to the very last cell of this set. So copy through J11
Plot Y vs. X and then fit a mathematical function to it (regression analysis).
042
123
264
-111
374
5-25
-3-16
-561
Part II: write an equation of a straight line of your choice:
Then graph it as a scatter plot with dots (do not join the dots with a line).
Hint: you will need to have points that fall on your straight line. Just for practice, find 8 such points.
To get these points: chose any values for x below. Then follow the method used in cell J5 above.
Once you have graphed your straight line, do a regression analysis to get an equation for that line. How does
this equation compare with what your original equation? Comment on your findings.
XY
Part III: You are given a data set. Graph it (DO NOT join the data points with a line) and find the mathematical relation that best represents your data.
XY
Neeharika Thakur: Neeharika Thakur: a=1, b=2, c=3
-1009803
-806243
-603483
-401523
-20363
03
20443
401683
603723
806563
10010203
Clearly write down each group member’s name and what that person contributed to this lab activity. This part is also graded.
Once you are done, upload your lab report to be graded.

top essay writers

Order your essay today and save 30% with the discount code ESSAYHELP