8. Using the appropriate equation for the magnetic field of a solenoid, rearrange the equation so that you solve for the Permeability of Free Space constant, J.. You will create an Excel graph with the permeability constant as the slope. In variable terms, show what the Rise and Run of this graph will be, including appropriate units. (2 points) NOTE: The table and graph explained in steps 9 and 10 may be printed out on the same page, but be sure the graph fills the page under the table..make the graph as big as possible. 9. Create an Excel Table that includes all the information you need to create the graph described in step 8. This table should have a minimum of six (6) columns of (recorded or calculated) data and should include column headings with appropriate units. (3 points) 10. Create the Excel Graph that has the permeability constant as the slope. (Recall that the permeability value should NOT be calculated for every data point; it should only be determined from the slope of your graph!) The graph should be a scatter plot with a trend line added. The intercept of the trend line should be set to zero, the equation for the trend line should be included on the graph and the trend line equation should be formatted as scientific notation with 3 digits after the decimal point. Remember to include a descriptive title and axis labels (WORDS not variable letters!) with appropriate units. (10 points) 11. Using the slope of your graph as the Observed value for permeability of free space, look up the Accepted value and calculate your percent error using E. = _(100) . Show your work below for this calculation. (3 points) 12. Knowing what you now know about how to use the Gauss meter to measure the magnetic field of a solenoid, determine the number of windings (N) in the ideal solenoid at your lab station. Take at least four (4) measurements of the magnetic field at different current levels, and solve for N for each of the four trials. Take the average of the four N-values as your final answer. SHOW ALL WORK BELOW for this calculation! Note: The length of the solenoid is 15.0 cm (5 points) Current (A) Mag Field (G)
