# Excel graph exercises for 3-1 investigation (xlsx files)

Created for Baradene College Physics Department by K.Barrett

Warnings:  Formatting and functions will not work if you try opening and using these Microsoft Excel files using Google Sheets.                                         You may find that Greek letters and mathematical symbols become the victims of a font replacement when you                 download! e.g.  A 'D'  might need to be changed to the greek letter delta !

Just to annoy you :   The Answers are in there but hidden!! L3 Excel graphs ball on ramp.xlsx

Excel for the 3-1 Exemplar Ball Down a Ramp

1  Format the data table to calculate averages and half-range uncertainties.

2  Process the data to fine square root values, plot the data as an X-Y scattergram and    modify the graph to acceptable NCEA standards.

3  Extrapolate the best fit trendline to the graph origin, insert the generic equation then modify the equation to include the appropriate variables

4  Modify a basic graph to include add custom error bars.

5  Insert an error line and calculate gradient uncertainty. L3 Excel graphs part 1.xlsx

Excel for the 3-1 Investigation PART ONE

1  To plot a basic line graph (x-y scattergram) from two columns of data.

2  Modify a basic graph to include the detail and axis labelling required for NCEA.

3  Modify an existing graph to include vertical, fixed value error bars.

4  Use a formula to average a range of data and format the answer to 2d.p.

5  Use the MAX and MIN functions to find the half-range of a set of data and complete a data table.

6  Enter a formula to convert absolute uncertainty to percentage uncertainty.

7  Use the SQRT function to reprocess values L > L  and calculate the uncertainty of the processed data. L3 Excel graphs part 2.xlsx

Excel for the 3-1 Investigation PART TWO

1  Modify a basic graph to include the detail and axis labelling required for NCEA and identify the relationship

2  Reprocess the independent variable data appropriately to the relationship

3  Complete a data table to find the absolute uncertainty of the reprocessed (squared) variable

4  Plot an x-y scattergram to get the straight line graph from the relationship.

5  Modify a graph of the data to show a trendline, equation and produce customise error bars from the data table L3 Excel graphs part 3.xlsx

Excel for the 3-1 Investigation PART THREE