[HOME][ASSIGNMENT][COURSE INFORMATION][PHY221]

  To Educator Assignment Submission

 

GRAPHING I

INTRODUCTION

The relationships (formula) between variables that we study this semester come, primarily, from three places. The first are defined relationships, the second is from experimental data, and the third would be mathematical combinations of the first two. Graphical analysis is one of the primary ways that experimental results are interpreted. In this exercise we will begin examining how data can be used to find functional relationships.

Note: you will need a media player and sound for some links below.

OBJECTIVES:

  • OPEN A WORD DOCUMENT AND BEGIN YOUR PAPER
    YOU SHOULD INCLUDE THE ITEMS BELOW
    (SEE THE GENERIC GUIDELINE FOR THE FORMAT).
      • title page
      • the objectives (above)
      • the data (below)
      • your excel graph (inserted in the word document)
      • your conclusion/discussion of the activity
  • OPEN AN EXCEL DOCUMENT AND GRAPH
    VELOCITY VS TIME     (which means graph velocity on
    the y-axis and time on the x-axis)
        • First (original) graph of your data
          • enter your data in columns, first column x-axis values, second column y-axis values
          • drag to select the data and then click the chart icon.
          • Select (xy) scatter
          • select scatter with data points connected by smooth lines
          • select next
          • enter titles and labels for your graph
          • deselect "show legend"
          • click "finish"
          • drag graph to where you wish it to appear on your page
        • Second (Analysis) graph of your data
          • If the graph appears linear FIT A LINEAR TRENDLINE
            • click a data point on the graph to select
            • select chart->add trendline --> select linear --> select options-->select show equation and R-squared-->ok
            • translate the excel equation to a functional relationship of your variables

             

        Data:

        A.

        Time(sec) 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5  
        Velocity(m/s) 70 60 50 45 32 30 22.8 14.5  

        B.

        Pressure(N/m^2) 1218 845 609 487 405 305 202 153  
        Volume(m^3) 2.0 3.0 4.0 5.0 6.0 8.0 12.0 16.0  

         

          • If the graph does not appear linear
            • regraph as instructed and follow the procedure above
              • Try a second graph of Pressure Vs (1/Volume) -- pressure on the y-axis
            • translate the Excel equation to the functional relationship of your variables
              • -do this by substituting for x, y, m, and b (remember you graphed 1/V, not V this time!)

                example: if excell equation is y = 30 x + 10 when you graph force Vs 1/distance, your functional relationship would be F = (30/d) + 10

COPY AND PASTE YOUR EXCEL GRAPHS INTO YOUR WORD DOCUMENT

ASSESS YOUR REPORT USING THE RUBRIC

FINISH YOUR REPORT AND SUBMIT IT USING EDUCATOR (find the assignment by clicking the "assignment tab").


hfish
8/27/04
©2001