*label*Science

### Question Description

**Instructions: Complete exercises 1 and 2. Follow all steps for each exercise. Record answers where instructed to. Staple all graphs to this assignment.**

**please check the file for the details **

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Tutor Answer

See attached

Potential

Difference, V (V)

0,12

1,3

0,25

2,8

0,3

3,4

0,45

4,9

0,52

5,7

Ohm’s Law

6

5

Potential Difference, V (V)

Current, I

(A)

4

3

2

1

0

0

0,1

0,2

0,3

Current, I (A)

0,4

Ohm’s Law

6

y = 10,878x + 0,0522

Potential Difference, V (V)

5

4

3

2

1

0

0,5

0,6

0

0,1

0,2

0,3

Current, I (A)

0,4

y = 10,878x + 0,0522

0,4

0,5

0,6

Potential

Time (s)

Difference

(V)

5

1,5

L

i

n

e

0,405465108

15

0,92 -0,083381609

30

0,39

-0,94160854

40

0,24 -1,427116356

60

0,083 -2,488914671

75

0,037 -3,296837366

90

0,02 -3,912023005

Time vs Potential Difference (V)

1,6

1,4

Potential Difference(V)

1,2

1

0,8

0,6

0,4

0,2

0

0

10

20

30

40

50

60

70

80

90

Time (s)

Time vs Linearized potential difference

1

0,5

tential Difference ln(V)

0

0

-0,5

-1

10

20

30

40

50

60

100

Linearized Potential Difference ln(V)

-1

-1,5

-2

-2,5

-3

-3,5

-4

-4,5

Time (s)

Time vs Linearized potential difference

1

0,5

Linearized Potential Difference ln(V)

0

0

10

20

30

40

50

-0,5

-1

-1,5

-2

-2,5

-3

-3,5

-4

100

-4,5

70

80

Time (s)

90

100

tential difference

60

70

80

y = -0,0517x + 0,6465

90

100

Name:_______________________ Section:_________

Graphing and Excel Homework

These exercises contain examples of data you will encounter during Phys204L/206L. If some terms are

unfamiliar right now, that’s fine. The purpose of this homework is to practice using doing linear fits with

Microsoft Excel (or Google Sheets) and to gain experience with interpreting best-fit equations. You may

use Microsoft Excel or Google Sheets to do the fit.

NOTE: If you need help creating a scatter plot and inserting a linear trendline, use google to find a tutorial,

ask a peer or help, or feel free to see me during my office hours.

Instructions: Complete exercises 1 and 2. Follow all steps for each exercise. Record answers where

instructed to. Staple all graphs to this assignment.

Exercise 1: Ohm’s Law

In this exercise you will practice plotting data, adding a linear trendline and interpreting the data.

According to Ohm’s Law, the potential difference ΔV is related to the current I by the equation

Δ𝑉 = 𝐼𝑅

(Eq 1)

where R stands for resistance. Potential difference is measured in the unit volts, current in amperes (or

amps) and resistance in ohms (using the Greek symbol omega: Ω).

Part A: Making a Scatter Plot

1. Using your favorite spreadsheet program, make a scatter plot of the following dataset:

Use current as the independent (x) variable and potential difference as the dependent (y) variable.

Current, I (A)

Potential Difference, V (V)

0.12

1.3

0.25

2.8

0.30

3.4

0.45

4.9

0.52

5.7

2. Give your graph the title “Ohm’s Law.”

3. Label the x and y axes with the appropriate data labels.

Ohm’s Law

6

Potential Difference, V (V)

5

4

3

2

1

0

0

0.1

0.2

0.3

0.4

0.5

0.6

Current, I (A)

Part B: Linear Regression

1. Fit a linear trendline to the data.

2. Display the equation on your graph.

3. Write the equation from the line...

*flag*Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors