lab 9.docx | bartleby

ENR 161 Unit 1 Engineering with Excel Lab Details 10 Points Lab Number 9 Name Lab Title Abstract 20 Points An abstract discusses the purpose of the paper and outcome of your research. A polynomial order of 5 would not give acceptable results for our thermocouple terp predictions because for small temp ranges the relationship between temp and voltage is nearly linear. This Lab (problem 6.2) asked me to plot three different data sets and see if it was reasonable to have a straight line through the graphs for each one. As you can see in figure 1 the first data set has a linear trend, as seen in figure two data set 2 has a 6 th degree polynomial trend line that is very accurate but a straight trendline is also fairly accurate. Data set three does not have a straight trendline but rather an exponential trendline as seen in figure 3. Support Materials 20 Points Provide screen captures of what you created in Excel by using the Snipping Tool app or the Snip and Sketch app. Use captions below each one to identify what the reader is looking at. Lab Report Template 1 | P a g e

ENR 161 Unit 1 Engineering with Excel Lab Report Template 2 | P a g e Figure 1, The graph for the first set of data points, as you can see a linear trend line works very well because r^2 is 1. Figure 2, the graph for the second set of data points, a linear trend line is alright but a 6 th degree polynomial is much more accurate because r^2 is almost 1.

ENR 161 Unit 1 Engineering with Excel Discussion 20 Points What did you do to find your answer? List the formulas or tools you used in Microsoft Excel to accomplish the required task. 1. I used graphs to help visualize the data sets and help me understand the relationship between the Y and X values. 2. I went into the graph options section to put a trendline on the graph to see what type of function the data set is most similar to. 3. As shown in figure 2.0 different trendlines are more accurate for different data sets this one being a polynomial of order 6. You can tell this by the R^2 number under the function. Comments 30 Points List at least three things you think are worth remembering. Discuss why it was useful and were you might use it again. 1. When changing the options on the graph you have the ability to show the equation which is helpful identifying the equation. 2. When changing the options on the graph you can show the R^2 value on the graph which is helpful because that value shows how accurate the data sets are to the trendline. Lab Report Template 3 | P a g e Figure 3, A linear trend doesn’t work very well because the r^2 value is low (compared to 1) which means not many points are close to that trendline. An exponential trendline is a lot better since r^2 value is closer to 1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help