# Lynn University Graphing Lines Linear Equations Excel Mini Project 2

User Generated

Nablzbhk

Mathematics

Lynn University

## Description

### Unformatted Attachment Preview

Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

## 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...

### Review

Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4