Using Excel to make a plot of the Position vs Time given in the following table.  The dependent variable is the position (y-axis) and the independent variable is the time (x-axis).  This is the measured position of a rock as it falls from the top of a very high cliff and obeys the equations y = 1/2gt2.  Make sure you label the plot properly.  Label the plot and the plot axes with the appropriate labels.   Measurement Time (s) Position (m) 1 0 0 2 1 5 3 2 21 4 3 46 5 4 82 6 5 129 7 6 185 8 7 252 9 8 330 10 9 417   Right click on a data point in the graph and add a “Trend line.”  Select a polynomial of order 2. This is a parabolic equation and describes an object falling under constant acceleration.  Also check the box that says ‘Display equation on the graph.” Since the acceleration of gravity is 2 times the coefficient of the x2 term, what do you find for the acceleration of gravity.  Copy and paste your graph in the given space below.  (50 points) Coefficient of the x2 Term =  ____________________  ( 5 points)    Calculate the acceleration due to gravity (g) using your equation (do not forget the units)    ( 15 points)      “g” =  ____________________      Working with shapes.  (30 points)      Follow the instructions carefully and the draw the figure in the given space at the end of the        instructions.    Select the tab “Insert>Shapes” in Microsoft office word Select a black arrow (with arrow tip) and draw it vertically in the center of this page 2 to 4 inches tall.  Don’t be tempted to make it fancy. Just a plain black arrow will do. Select a second black arrow (with arrow tip) and draw it horizontally centered on the first arrow so that it looks like a coordinate system.   Select a circle and draw it centered on the coordinate system about 1 inch in diameter.   Select a box and draw it centered on the circle with the circle fully contained in it.   Add a text box and type “I did it” in the text box. Adjust the size so it can be read.  You may have to select each object and move to get the desired figure.

College Physics
11th Edition
ISBN:9781305952300
Author:Raymond A. Serway, Chris Vuille
Publisher:Raymond A. Serway, Chris Vuille
Chapter1: Units, Trigonometry. And Vectors
Section: Chapter Questions
Problem 1CQ: Estimate the order of magnitude of the length, in meters, of each of the following; (a) a mouse, (b)...
icon
Related questions
icon
Concept explainers
Question
100%
  1. Using Excel to make a plot of the Position vs Time given in the following table.  The dependent variable is the position (y-axis) and the independent variable is the time (x-axis).  This is the measured position of a rock as it falls from the top of a very high cliff and obeys the equations y = 1/2gt2.  Make sure you label the plot properly.  Label the plot and the plot axes with the appropriate labels.

 

Measurement

Time (s)

Position (m)

1

0

0

2

1

5

3

2

21

4

3

46

5

4

82

6

5

129

7

6

185

8

7

252

9

8

330

10

9

417

 

  1. Right click on a data point in the graph and add a “Trend line.”  Select a polynomial of order 2. This is a parabolic equation and describes an object falling under constant acceleration.  Also check the box that says ‘Display equation on the graph.” Since the acceleration of gravity is 2 times the coefficient of the x2 term, what do you find for the acceleration of gravity.  Copy and paste your graph in the given space below.  (50 points)










Coefficient of the x2 Term =  ____________________  ( 5 points) 

 

Calculate the acceleration due to gravity (g) using your equation (do not forget the units)    ( 15 points) 




   




“g” =  ____________________   






  1.   Working with shapes.  (30 points)

     Follow the instructions carefully and the draw the figure in the given space at the end of the  

     instructions. 

 

  1. Select the tab “Insert>Shapes” in Microsoft office word
  2. Select a black arrow (with arrow tip) and draw it vertically in the center of this page 2 to 4 inches tall.  Don’t be tempted to make it fancy. Just a plain black arrow will do.
  3. Select a second black arrow (with arrow tip) and draw it horizontally centered on the first arrow so that it looks like a coordinate system.  
  4. Select a circle and draw it centered on the coordinate system about 1 inch in diameter.  
  5. Select a box and draw it centered on the circle with the circle fully contained in it.  
  6. Add a text box and type “I did it” in the text box. Adjust the size so it can be read.  You may have to select each object and move to get the desired figure.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Estimate of calculation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, physics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Physics
College Physics
Physics
ISBN:
9781305952300
Author:
Raymond A. Serway, Chris Vuille
Publisher:
Cengage Learning
University Physics (14th Edition)
University Physics (14th Edition)
Physics
ISBN:
9780133969290
Author:
Hugh D. Young, Roger A. Freedman
Publisher:
PEARSON
Introduction To Quantum Mechanics
Introduction To Quantum Mechanics
Physics
ISBN:
9781107189638
Author:
Griffiths, David J., Schroeter, Darrell F.
Publisher:
Cambridge University Press
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Lecture- Tutorials for Introductory Astronomy
Lecture- Tutorials for Introductory Astronomy
Physics
ISBN:
9780321820464
Author:
Edward E. Prather, Tim P. Slater, Jeff P. Adams, Gina Brissenden
Publisher:
Addison-Wesley
College Physics: A Strategic Approach (4th Editio…
College Physics: A Strategic Approach (4th Editio…
Physics
ISBN:
9780134609034
Author:
Randall D. Knight (Professor Emeritus), Brian Jones, Stuart Field
Publisher:
PEARSON