Excel Mini-Project 2: Graphing Lines Name: Overview Directions Instructor: We are going to learn how to graph linear data on Excel. We will also learn about b We will see how to turn data into a graph a Step 1: Recognizing that our data is linear: Go to Sheet2 and view the data and answer question 1 on Sheet4. Create a scatterplot to view the data graphed as a linear equation. Turn on the "trendline" and turn on the "show equation on chart"(not on If you are on a MAC or iPad you will need to get the equation by hand. Answer questions 2, 3, and 4 on Sheet4. Step 2: Creating a linear equation to model a problem: Go to Sheet3. Calculate the simple interest. (answer Q. 5) Calculate the next 5 values in the table. (answer Q. 6) Identify the independent and dependent variables. (answer Q. 7) Come up with an equation to model the data. (answer Q. 8) Test the equation by plugging in some values. (answer Q. 9) Step 3: Make sure you answer all the questions on Sheet4. We are done! (unless you want a challenge … then go to Sheet5) Tips! Look for color-coded tips on each step if you are stuck on how to use Excel. They w If you venture outside these thick blue bars you have gone too far! All of the mater But feel free to use this area for notes or calculations or experimentation! Date: will also learn about bonds and simple interest as an example of a linear equation. n data into a graph and into an equation. 1 on Sheet4. ar equation. on on chart"(not on MAC). quation by hand. ...
Purchase document to see full attachment