Submission: Be sure to follow the format for you EXCEL tables and graphs. Here is the handout on this. Graphing FormatGraphing Format You will use EXCEL to display your graphical results. This includes both a data table and a graph. Detailed descriptions for both of these are given below. Data Table Format All data must be presented in tables as shown below. Title Simple Harmonic Motion Data mass (kg) T (s) T2 (s 2 ) 0.100 0.561 0.314 0.200 0.745 0.556 Quantity name with units in parenthesis 0.300 0.895 0.801 0.400 1.002 1.0210 0.500 1.130 1.2770 No units needed with individual numbers since units are given at top of column Generating EXCEL Graph Follow these steps to generate the graph. Here is a link for a youtube video as well: https:/www.youtube.com/watch?v=8B8kFVNz1Q8 This link is also on D2L in the EXCEL Graphing module. For the video, start at the 2:15 mark. Select Data Source ? X 1. Insert - Charts - Scatter - no connecting lines Chart data range: (first option) 2. Select Data - Remove any data that may appear. Click Add. Legend Entries (Scries) Horizontal (Category) Axis Labels tim add Z Edit X Bemove 3 Edit Hidden and Empty Cells OK Cancel3. Enter graph Title in "Series name" field Edit Series ? X 4. Click Select Range for X values then highlight the Series name: values in your data to e you want on the x axis. Only Select Range Series X values: highlight number values. Click Select Range for X. elect Range Series Y values: 5. Click Select Range for Y values then highlight the =(1) values you want on the y axis. Only highlight number OK Cancel values. Click Select Range for Y. 6. If the graph looks like a line, click OK. Click OK again. CHART ELEMENTS Axes Axis Titles 7. Click on + icon next to graph and select "Axis Titles" Y Chart Title Data Labels and "Trendline". Hover the cursor over the triangle next Error Bars to "Trendline" and select "More Options" Gridlines Legend Trendline Linear 8. Select "Display Equation on Chart" and "Display R- Exponential squared Value on Chart" . Linear Forecast Two Period Moving Average 9. Click on "Axis" Title" textbooks label both axes. More Options. Include units. 10. A properly formatted graph is show on the next page. Format Trendline - X TRENDLINE OPTIONS Logarithmic O Polynomial Order 2 O Power O Moving Average Period 2 Trendline Name Automatic Linear (sample graph) Custom Forecast Forward 0.0 periods Backward 0.0 periods Set Intercept 0.0 Display Equation on chart Display R-squared value on chartTitle (Period) vs. Mass Equation for best fit 1.400 straight line; units of slope are s'/kg so 1.200 slope = 2.373 s-/kg 1.000 y = 2.373x + 0.0784 0.800 R2 = 0.9985 0.600 Best fit straight line R- squared value 0.400 0.200 0.000 0.000 0. 100 0.200 0.300 0.400 0.500 0.600 m (kg) Axes labels with units in parenthesisCapacitor Lab PHYS 421 Lab Group Members: You will be using this phet simulation: https://phet.colorado.edu/en/simulations/capacitor-lab You can also download the simulation from Canvas. We will be working with the simulation on the "Introduction" tab. View- 10'13 X 10T Plate Charges Capacitance-meter Charge -meterElectric Field Lines Meters- Capacitance Disconnect Battery Plate Charge Stored Energy Capacitance Plate Charge (top) Voltmeter Separation 0.89x10 F 0.13x10 12C 10.0 mm Electric Field Detector Reset All Plate Area ? V 1.5v 100.0 mm 2 Voltmeter OV -1.5 V Note that the simulation uses units of mm for distance and mm for area. You will need to convert to m and m.Preliminaries 1. Find an expression for the slope, s, of the graph of C (on the vertical axis) vs. A (horizontal axis). Start with C : $ . You do not need any data points to do this. This is a theoretical derivation and does not require data points. Show your work: . . . . l . 2. Find an expressron for the slope, s, of the graph of C (on the vertlcal aXis) vs. E (horizontal axis). Start with C : $ . You do not need any data points to do this. This is a theoretical derivation and does not require data points. Show your work: 3. Find an expression for the slope, 5, of the graph of Q (on the vertical axis) vs. V (horizontal axis). Start with Q = CV . You do not need any data points to do this. This is a theoretical derivation and does not require data points. Show your work: Experiment 1. Capacitance and Area C = E a! Set the battery voltage to 1.5 Volts. In this part the distance, d, between the plates is kept constant at =10.0 mm and the area of the plates is changed. You are to record the values for area (in m2) and the capacitance C (in F). Take at least eight values of A and C, and record in an EXCEL Data Table. (a) Use Excel to plot C (on the vertical axis) vs. A (horizontal axis). Use at least 3 data points. (b) Create a trendline and include this with your graph. Adjust the number of decimal places used in the trendline equation so you have numbers that go two past the decimal point, to the hundredths place. (0) Use the slope of the line and your first answer in the preliminaries to nd your experimental value for an. Include the correct units. a. Calculate the percentage difference between your experimental value for a) and the theoretical value of a] = 8.85x 10l2 Ffm. experimental a] = experimental - theoretical percent difference = x 100% theoretical 2. Capacitance and distance C : $ : In this part the area, A, of the plate is kept constant A: 100 mm2 and the distance d between the plates is changed. You are to record the values for distance (in m) and the capacitance C (in F). Take at least eight values of d and C and record in an EXCEL Data Table. (a) Use Excel to plot C (on the vertical axis) vs. l (horizontal axis). Use at least 8 data at points. (b) Create a trendline and include this with your graph. Adjust the number of decimal places used in the trendline equation so you have numbers that go two past the decimal point, to the hundredths place. (c) Use the slope of the line and your second answer in the preliminaries to nd your experimental value for 80. Include the correct units. ((1) Calculate the percentage difference between your experimental value for a; and the theoretical value of a). Show your work: experimental a] 2 percent difference = Capacitance and Charge & Voltage: Q = CV (a) Set the value of the capacitor to C = 0.89x10'13 F. This can be achieved by setting the area to 100.0 mm2' and the plate separation to 10.0 mm. (b) You will vary the battery voltage and record Q (on top plate) and V of the capacitor. Use at least 8 data points in your data table. Include negative values for V. Note that the charge meter only gives the magnitude of Q. Be sure to look at the sign of the charge on the top plate to know when it is negative. ((3) Use Excel to plot Q (on the vertical axis) vs. V (horizontal axis). Use at least 8 data points. ((1) Create a trendline and include this with your graph. Adjust the number of decimal places used in the trendline equation so you have numbers that go two past the decimal point, to the hundredths place. (e) Use the slope of the line and your third answer in the preliminaries to find a value for C , Include the correct units. (f) Calculate the percentage difference between your experimental value for C and the theoretical value of Clh = 0.89x lO'lBF. experimental C 2 percent difference = You will turn in the following: 1. This handout 2. Three EXCEL Data Tables - follow proper format 3. Three EXCEL Graphs - follow proper format