## Description

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Explanation & Answer

Here you go.

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.

nswer Q. 7)

to Sheet5)

to use Excel. They will be highlighted in green.

far! All of the material is inside of these bars.

mentation!

Below is data showing the value of Lin Financio's

bond as the months go by.

Month

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

Bond Amount

$500.00

$525.00

$550.00

$575.00

$600.00

$625.00

$650.00

$675.00

$700.00

$725.00

$750.00

$775.00

$800.00

$825.00

$850.00

$875.00

$900.00

$925.00

$950.00

$975.00

$1,000.00

$1,025.00

$1,050.00

$1,075.00

$1,100.00

Step 1:

Recognizing that our d

Go to Sheet2 and view

Create a scatterplot to

Turn on the "trendline

If you are on a MAC or

Answer questions 2, 3

Place your graph in this box:

$1,200.00

$1,000.00

$800.00

$600.00

$400.00

$200.00

$0.00

0

Tips for Step 1:

first:

To create the scatterp

Highlight your data; a...