Using Excel in AH Physics Investigations The aim of this activity is to ensure you can set up a spreadsheet for data entry and automate calculations (such as uncertainties) using formulae. There is an introduction to the LINEST function, which provides information (gradient, y-axis intercept and their associated uncertainties) on lines of best fit. Data for this activity was obtained by finding the period of oscillation for a simple pendulum over a range of pendulum lengths. 1. Enter the data. There are 5 period measurements for each length. Create columns for length and 5 period measurements in your spreadsheet, then copy & paste the following values into your columns: pendulum length l (m) 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 1.3
period of oscillation T (s) period 1 period 2 period 3 0.88 0.83 0.91 1.09 1.07 1.13 1.28 1.19 1.25 1.42 1.56 1.36 1.57 1.45 1.62 1.71 1.82 1.77 1.80 1.88 1.83 1.90 2.00 1.83 2.01 2.05 2.00 2.10 2.04 2.08 2.14 2.10 2.22 2.32 2.21 2.38
2. Add additional columns. At the appropriate position in the table, create columns for; mean period random uncertainty in period scale reading uncertainty in period absolute uncertainty in period %age uncertainty in period T2 %age uncertainty in T2 absolute uncertainty in T2 * absolute uncertainty in length * *absolute values are required to produce independent error bars for each point on your graph. 3. Enter calculations. Use the Excel formula builder to produce calculations for each empty cell in the 1st row of data. Excel’s AVERAGE, MAX, MIN & COUNT functions are useful here. Any other calculation probably requires creation of an expression from scratch. Be careful with brackets! When building expressions, the following functions may be required; multiplication * division / raise to power ^ If you need to use 𝜋 in a calculation, use PI() in the relationship. PI() will require control of significant figures - how could you achieve this in Excel? 4. Plot the chart. Once you are happy with the values obtained, plot a chart to show the results. Highlight the x-axis data (pendulum length) and y-axis data (T2). Include column headings if you want Excel to use these as data labels. Once columns are highlighted, choose Chart > Scatter to produce the graph.
5. Add error bars. Click on any data marker inside your chart. From the options, pick error bars. Choose the custom option and enter the range of cells containing your absolute uncertainty values. (note that % uncertainties do not work with the custom option). The same range should be entered for the positive and negative fields to account for ± in the uncertainty. Repeat this process for the other axis 6. Calculate line of best fit data (gradient, intercept). Highlight a grid of empty cells – 2 columns x 5 rows. Keeping the cells highlighted, choose the LINEST function from the formula bar. LINEST has 4 arguments in the brackets, i.e. LINEST(1,2,3,4). 1 2 3 4
= = = =
range of y-axis values (without column heading) range of x-axis values (without column heading) TRUE TRUE
In practice, your formula will look something like “=LINEST(N5:N10,C5:C10,TRUE,TRUE)” where “TRUE” is just a switch to provide statistical analysis of the specified data ranges. When you have entered the formula, make sure you press SHIFT + CONTROL + ENTER together to fill the highlighted cells with data. The result should look something like this, with the important information shown in the top 2 rows.
You can access tutorials on LINEST on my site via the following link http://mrmackenzie.co.uk/2011/09/27/ah-help-using-excel/ or by typing “linest” in the search box.
Using Excel in AH Physics Investigations - simple ... - with mr mackenzie
uncertainties) on lines of best fit. Data for this activity was obtained by finding the period of oscillation for a simple pendulum over a range of pendulum lengths.
Use the Excel formula builder to produce calculations for each empty cell in the 1st row of ... You can access tutorials on LINEST on my site via the following link.
If you need to use ! in a calculation, use PI() in the relationship. PI() will require control of significant figures - how could you achieve this in Excel? 4. Plot the ...
Page 1 ... uncertainties) on lines of best fit. Data for this activity was obtained using ... Use the Excel formula builder to produce calculations for each empty cell in ...
The aim of this activity is to ensure you can set up a spreadsheet for data entry and automate calculations (such as uncertainties) using formulae. There is an introduction to the LINEST function, which provides information (gradient, y-axis intercep
(ii) green light; ... them) - An electric current (known as a ... light (which contains photons of all 7 colours of the visible spectrum - red, orange, yellow, green, blue,.
ultrasound procedure. Why is this? Good contact is important. ..... For example in a telephone system? .... The distance from the centre of the lens to the principal ...
Page 6 ... A galaxy is a group of stars, gases and dust held together by gravity. ⢠The universe is all existing matter and space considered as a whole.
Page 3 .... A galaxy is a group of stars, gases and dust held together by gravity. ⢠The universe is all existing matter and space considered as a whole.
National 5 Physics Summary Notes. Dynamics & Space. 3. F. Kastelein ..... galaxy. Universe everything we know to exist, all stars planets and galaxies. Scale of ...
beyond the limits of our solar system. Space exploration may also refer simply to the use of satellites, placed in orbit around the. Earth. Satellites. The Moon is a ...
5.4 Angular momentum and kinetic energy . . . . . . . . . . . . . . . . . . . 78 ... 7.2 Gravitational potential and potential energy . ...... order for it to land on the green.
performing a detailed calculation, sketch a graph to show how the force on the third charge varies ...... particles. Discovered in 1958 after the Explorer 1 mission.
There are many practical examples that we will be able to analyse, such as ..... a diagram, list the data and select the appropriate kinematic relationship.
1.5 Summary . ..... Electric forces act on static and moving electric charges. We will be using the ..... Q8: A 50.0 N C-1 electric field acts in the positive x-direction.
F = ma. Example. A toy car of mass 3 kg accelerates at 5 ms-2. Calculate the force acting on the car. Solution: Use F=ma. Know m = 3 kg a = 5 ms-2 so F = 3 x 5.
3. Finally in part 3 we are asked to find s, given u, a and t, so we will again use ...... Q16: A planet in a distant galaxy has mass 6.07 Ã 1025 kg and radius 4.02 ...
The electricity supply to our homes, schools and factories from the National Grid is an ..... In this next online activity, observe the effect on the alternating current through a ...... http://phet.colorado.edu/en/simulation/circuit-construction-kit
Radian measurement of angles (Mechanics topic 3). ⢠Simple harmonic motion (Mechanics topic 8). Learning .... All references in the hints are to online ..... We could, of course, have calculated f using f = v/λ which gives the same answer. ..... T
with d.c. and a.c. sources to compare peak and r.m.s. values; .... would expect a 12 V supply to transform 12 joules of energy for every coulomb of charge that flows through ...... An alternative name for the depletion layer is the junction region.
6. TOPIC 1. VECTORS. Adding collinear vectors. 20 min. Online simulation ...... cliff edge. What is the vertical velocity of the car when it strikes the ground?
S3 Resistance Homework. Answer these questions in your homework jotter, showing full working. 1. The same three resistors are connected in different ways, as.
4) Calculate. Calculate. Calculate the refractive refractive index of a substance substance which has a critical critical critical angle of. 42.5o. (a). (b). (c). (d). (e).
If we supply heat to a solid, such as a piece of copper, the energy supplied is given to the copper particles. These start to vibrate more rapidly and with larger ...
