- How to increase sig figs in excel trendline movie#
- How to increase sig figs in excel trendline manual#
- How to increase sig figs in excel trendline download#
I can go ahead and login to print out the pre and post labs before I fill things in, right? Then what? Instead of hitting "Submit" can I just close the window? Or will that end up in "spurious results" as my grade for the lab?ĭon't hit "Submit." Just close the window. Is it possible to log into the quiz and print it and exit without submitting it, without losing your one try at it? For this lab, I think you took five measurements.ĭouglas, just had a quick question about post lab quizes. K is the number of data points used in the regression. You'll know if he said that in class.) On the cover page for your write-up is information about the k for least squares fit. (But, Peter may want you to turn in the hand-graphs. 31, Jan 2003, You may turn in your printed-out spreadsheet graphs in place of the hand-written graph paper. Additionally, when the write up asks us to fill in the "k for the least squares fit," where could I find that? I've made all three graphs and have them plotted with equations and trendlines on excel but where can I find "k"?įri.
How to increase sig figs in excel trendline manual#
There are experiments in the lab manual that we won't be doing this semester, such as "Resonance."Īs far as our lab reports go ought we to include excel graphs in our turned in work or simply our graphs that we filled out in the write up literature. You should find "Resistivity" and "Ohms Law" as they were last week's lab and this week's lab respectively. Look again for the Table of Contents in the front of the lab manual. What's up with that? Is it a wrong manual? I bought MSCD&UCD LAB II Manual 20 (all sections), but instead of resistance there is section on resonance. Hey, check this out (&sigma ) gives a sigma symbol (σ) on a web site. I fixed it and your answer is recorded properly. That creates problems (so I have discovered). I normally use three significant figures. I am getting an incorrect answer for problem # 9, even though I am using the rho=(1/sigma) equation mentioned in the book, and the previous post. Try again.ĭon't apologize for asking questions. Q#9: My algorithm was incorrect for rounding. In that is a data table that you will use in class. In the lab manual exists a write-up for each lab. Never had any problems with the pre-lab quizzes for Lab I. So, if rho=.95, then sigma = 1/.95 = 1.052.which is 1.1 with two significant figures (with the appropriate units). Concerning question #9.I am understanding from the lab manual that rho=(1/sigma). The lab book just says that the areas are listed on the resistivity board. Question #8 asks for the area of the largest wire we will be using. Go to lab 1 schedule and see Spreadsheets link.īegin Q&A Forum for "RESISTIVITY" Questions concerning the first pre-lab quiz:ġ.
How to increase sig figs in excel trendline movie#
If you need a longer movie on spreadsheets and plots, What about a plot? If you need a semi-quick review, watch this movie.ħ.5 minutes will get you enough. Find the HD version using the gear icon.ĭMM-01- Inputs and Selector for Amprobe 37XR-A Digital MultimeterĭMM-02- Measure Resistance with DMM Amprobe 37XR-A Please watch via youtube using the YOUTUBE button on bottom right of each video.Īnd, some videos have much higher quality.
How to increase sig figs in excel trendline download#
Here is the MSExcel File (be sure to right click this link to download the file.) There is also a movie below dealing with the details for the uncertainties. See the Diameter to see where to place these uncertainties. There is also a new row allowing you to record the uncertainty values. The new data table gives values for Wire Diameter, rather than wire area. There is a new version of the data table in Spring 2013. The length is a calculationīecause it is the sum of all the screw pair distances up to that point. The second column calls for the length of the wire. The first data table requires that the student measure the short distance (The only exception might be to convert the measurement ie. It is crucial in a laboratory setting to record all data in its most rawįorm. Whever you see a column with solid borders, this means data should Look at 3rd column) this means that a calulation In general, whenever you see a column with dotted borders (See the pictureīelow. Of sounding trivial (or maybe mudding the waters even more), here is an attempt
The data table is called "Resistance Versus Length." At the expense
Measurements and Uncertainty Lecture RESISTIVITYĬonfusion existed in the past regarding the first data table on the data sheet.
0 kommentar(er)
