1 / 17

TurnItIn class: 5128261 TurnItIn pa$$: 2013sl

November 5, 2012 – Assign Yourself. TurnItIn.com class: 5128261 TurnItIn.com pa$$: 2013sl. Today’s Objective and Agenda. Objective : Make scatterplots, graph functions and find regression curves using Excel Agenda Work through an example together as you ask questions throughout .

andren
Télécharger la présentation

TurnItIn class: 5128261 TurnItIn pa$$: 2013sl

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. November 5, 2012 – Assign Yourself TurnItIn.com class: 5128261TurnItIn.com pa$$: 2013sl

  2. Today’s Objective and Agenda • Objective: Make scatterplots, graph functions and find regression curves using Excel • Agenda • Work through an example together as you ask questions throughout. • You will have worktimeonly to: • A. Work on your portfolio on these computers • B. Study for your probability test for Wednesday

  3. Copy down this data!!!(it is all one table but could not fit)

  4. First, let’s put the data in Excel. • Open Excel. You should be in a blank workbook. • Type in your data with x and y at the top. • Save the file. (flash drive or on computer)

  5. Second, let’s make a scatterplot. • Click on the “Charts” menu. • Click “Insert Chart” and scroll down to “Marked Line”. A scatterplot should appear! Yay! Now right-click on it and click “Format Data Series…”

  6. Still scatterplotting… Go to “Line” and change “Color” to “No Line” because we just want scatterplot.(If you want, you can delete the legend so it looks like mine. To delete, click the legend, then hit the “delete” key.) To add into Word, simply click the graph box, copy, then paste into Word. (I copied into PowerPoint!)

  7. Third, we’ll develop a function! • Find the right parent function… it doesn’t have to fit every single point perfectly! • Use Google Image search to glance through pictures of parent functions. • Hint: don’t make your first part too hard since you are doing this analytically at first: the IB loves these by hand: quadratic, cubic, sine • Transform! You need to do this analytically…

  8. (still 3) Transformations! • Choose the parent function. • It is totally OK if you say it only works for most of the graph! • In this case, we could choose sin orcos. I pick sin. • Developing the equation for quadratic or cubic. • To solve two lines, you need 2 equations. • To solve a quadratic, you need 3 equations. • To solve a cubic, you need 4 equations…

  9. Analytically solving a cubic:Either try stretching/shifting or use matrices! • To solve a cubic, we need 4 equations to solve ax3 + bx2 + cx + d = y • First make the equations, then put into matrix form: a(2)3 + b(2)2 + c(2) + d = 16.4 a(8)3 + b(8)2 + c(8) + d = 15.8 a(14)3 + b(14)2 + c(14) + d = 19.36 a(20)3 + b(20)2 + c(20) + d = 21.65 • Next slide: matrix form!

  10. Matrix form! (Again, you could be doing transformations instead. But this looks more impressive.) • Set up a matrix equation in the form: AX = Y A = X = Y = • A-1AX = A-1Y => X = A-1Y • You can solve that on your GDC. (technology!)

  11. Matrix form finished… • You should get: • A = -0.004189814815 • B = 0.1583333333 • C = -1.331388889 • D = 18.46296296 • For a final equation of y = -0.00419x3 + 0.158x2 – 1.33x + 18.5 • Now let’s get back to graphing…

  12. Graphing these points… • Add a third column called Y2 (this will be your data points from your equation), and fill in using a FORMULA: =-0.00419(A2)^3+0.158(A2)^2-1.33(A2)+18.5 • Drag the bar down so it adjusts to each x. • Right-click graph and click “Select Data…”

  13. Continuing the Graph… • Under Series, hit “Add” • Then by Y-values, delete the “{1},” hit the funny-looking button, select our new data (just the numbers) and hit the funny button again. • Then hit OK and you should have this… which is so close it overlaps the scatterplot!

  14. Reflecting on the Graph • If it’s close, just make minor adjustments using your knowledge of shifts/stretches and transformations in general. • If it’s not close, you should try another graph analytically – for example, we might try a quadratic for this one instead. You still have to justify the new graph (for example, part of this graph looks like a parabola).

  15. Regression in Excel!!! • Make another copy of your graph, then right-click and choose “Select Data…” on the new graph, then delete Series 2. • Then right-click chart, hit “format data series,” click “line,” then change color to “no line.” • Go to “Chart Layout” and then “Trendline” -> “Trendline options”.

  16. Regression in Excel!!! • Go to “options.” Check “display eq” and “display R2”. • Go to “type” and click around. • Try out different ones and pick the best 3 to show in your portfolio! Justify why those make sense (parent functions!) For this one, I would use polynomial order 2, order 3 and exponential. DO NOT use “moving average.” • Comment on similarities/differences from your graph. • Ask Studies about R2. 

  17. Worktime: Two Options • Study for probability test where you are. • Work on your portfolio.

More Related