1 / 23

EGR 105 Foundations of Engineering I

EGR 105 Foundations of Engineering I. Excel Part II More on Plotting Section 8 Fall 2013. Excel Part II Topics. Data (engineers collect and use) Viewing What is in the data? Plotting Data…some ways to look at data Backgrou nd on Plot Types Transforming data to Log 10

patience-casey
Download Presentation

EGR 105 Foundations of Engineering I

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EGR 105 Foundations of Engineering I Excel Part II More on Plotting Section 8 Fall 2013

  2. Excel Part II Topics Data (engineers collect and use) Viewing What is in the data? Plotting Data…some ways to look at data Background on Plot Types Transforming data to Log10 Using Log10 Scales Homework Assignment

  3. Engineering and Data For Engineers, Data… is useful often routinely collected requires interpretation is used in a variety of ways can be complex and difficult to work with

  4. Data Can Be Complicated

  5. Viewing Data Recorded data can show a variety of important trends and patterns Plotting can provide insight There are different ways to view the data It is important how data are presented Often want to see data details on one plot Useful for developing equations Will cover this topic next time in Excel Part III

  6. What is in the Data? When you have a set of data, ask… What do these data tell me? Is there a trend…a relationship….? How do the data describe reality? Not always obvious Sometimes requires different looks Plotting of data can be very useful

  7. Presentation of x-y Data Independent versus dependent variables y y = f(x)x dependent independent

  8. Simple Plotting Generate X and Y data to Plot

  9. Common Types of Plots Example: f(x)= y = 3x2(plots for equations and/or data) Cartesian Semi-log : Log (Y) Log-Log : Log (X)-Log (Y) Semi-log : Log (X)

  10. Excel Part II Topics Data (engineers collect and use) Viewing What is in the data? Plotting Data…some ways to look at data Background on Some Useful Plot Types Transforming data to Log10 Using Log10 Scales Homework Assignment

  11. Lets Review These Plots How were they created? What is a linear plot a semi-log plot a log-log plot a logarithmic scale Note that here we use Log10

  12. Linear Scale Note: Cannot see details of these points

  13. Take Log10of x-data Observe: Log (0) undefined Semi-Log Plot Note: Cannot see details of these points

  14. Take Log10 of y-data Observe: Log (0) undefined Semi-Log Plot

  15. Take Log10of x-data and y-data Observe: Log (0) undefined Log-Log Plot Note: Now can see details of these points

  16. Excel Part II Topics Data (engineers collect and use) Viewing What is in the data? Plotting Data…some ways to look at data Background on Plot Types Transforming data to Log10 Using Log10 Scales Homework Assignment

  17. Easier Way Create plots using Log10 scales No need to convert any of the data By hand on paper (available in stores) Semi- Log10paper Log10-Log10paper Software packages Excel MatLab(in EGR 106 next semester) other

  18. Plot Using Log10 Scale for x Semi-Log Plot Observe: No zero on Log scale - Log (0) undefined Note: Scale variation is logarithmic

  19. Plot Using Log10 Scale for y Note: Scale variation is logarithmic Semi-Log Plot Observe: No zero on Log scale - Log (0) undefined

  20. Plot Using Log10 Scale for x and y Note: Scale variation is logarithmic Log-Log Plot Observe: No zero on Log scale - Log (0) undefined Note: Scale variation is logarithmic

  21. Excel Part II Topics Data (engineers collect and use) Viewing What is in the data? Plotting Data…some ways to look at data Background on Plot Types Transforming data to Log10 Using Log10 Scales Homework Assignment

  22. Homework Assignment #4 See HW4 on course web site Import historical data for computer memory prices into spreadsheet Determine cost in $s/megabyte for each year Plot data two different ways Linear scale Semi-log scale Discussion of details found in results

  23. Homework Assignment #4 Submission Procedures Submit your Excel Spreadsheet with: all imported and calculated data each of the two plots discussion embedded in a text box Send as an email attachment to Prof. Sadd with the subject line egr105_4(no spaces). Due Date: October 24.

More Related