DMM Introduction

1. Submitting your report:

Please edit the "Submission title" while submitting, Turnitin doesn't assume that the filename is the submission title, so please do the following (especially the group id), otherwise when your data overlaps with others, it may be counted as plagiarism.

Fig 1. Submitting your report

If not, from my view, the files would be like Fig 2.

Fig 2. Filenames viewed from Turnitin

2. Significant digits of Uncertainty

a. For the calculated uncertainty (or the uncertainty from LINEST results), just keep ONE significant digit, unless when the leading digit in the uncertainty starts with 1, then you may keep 2 significant figures, see Section 2.2 in Taylor's book. Example:

If the result is

1.058 ± 0.1380 V, or 1.058 ± 0.3801 V

it should be

1.06 ± 0.14 V, or 1.058 ± 0.4 V

where the number of decimal places is determined from Rule a, which therefore makes the observed value has only one decimal digit.

Note: Keeping only ONE significant digit is ONLY for this course -- in your own research, please do not follow this rule!

b. For the measured uncertainty, it should be half of the precision.

For the analog meter, the precision is 0.5 volts, so half of it is 0.25 volts, which should be rounded to 0.3 volts, since the measured value has only ONE decimal

digit.

3. LINEST:

a. In reporting the LINEST results, don't forget to explain the meaning of the cells. And the error should have only 1 significant figure.

b. the function is "=LINEST(y's, x's, 1, 1)". The first 1 lets you calculate the intercept, the second 1 lets you report the statistics.

c. Use Command+Enter for Office2011 for Mac, Shift+Control+Enter for Office for Windows. If you insist on using Office2015 for Mac, use "=INDEX(LINEST(y's, x's, 1, 1), A, B)", which will return the value of A-th row and B-th col on the LINEST result table.

Update 09/16: Use Shift+Command+Enter for Office2015, and we can get the beautiful LINEST table.