## Listing all results (250)

### Inverse Proportion

This interactive excel file has separate sheets which deal with inverse proportion where the functions are linear, quadratic and square root. Each sheet begins with a statement of the proportional relationship and values so that the constant can be calculated and the equation found. The student then substitutes...

### Averages and Moving Averages

This resource contains two excel files dealing with measures of central tendency, trend and spread for sets of discrete data.

**Averages and Range**

The first interactive sheet shows a set of nine data items which can be shown sorted into ascending order. The values of mean,...

### Box and Whisker

The first sheet of this excel file shows a box and whisker diagram where the defining points can be altered. The second sheet shows two box and whisker diagrams to allow comparison between distributions. The next sheet shows a box and whisker diagram for students to read off the lowest value, the median and...

### Correlation

The first sheet of this excel file shows a set of data in a scatter plot. The line of best fit can be drawn and a description of the type of correlation can be revealed along with the equation of the trend line. The other sheet shows the value of cars at various ages. The scatter plot shows the data and there are a...

### Cumulative Frequency

The first two sheets of this excel file shows sets of data about the weight of cows in two herds. The cumulative frequencies can be revealed and the quartiles and median are shown derived from the cumulative frequency graph. The next sheet shows the comparison of the two herds as shown by the box and whisker...

### Data Sets: Calculating an Estimate of the Mean

The first sheet of this excel file shows the number of passengers per flight from London to Paris. The raw data is shown in a grouped frequency table and the midpoint of each group can be revealed as well as each stage in the calculation of the estimate of the mean. The next two sheets each show two sets of data...

### Simultaneous Equations (Non-Linear)

This file provides practice at solving pairs of simultaneous equations where at least one is not linear. The pairs of graphs and the coordinates of the points of intersection can be revealed.

The first sheet deals with the intersection of a straight line with y=x^{2} where all the...

### Transformation of Functions

This interactive excel program allows students to explore the relationship between the transformation of functions and the associated graphs. Functions explored are straight lines, quadratic and cubic functions as well as sine and cosine curves. Each type of function can be fully transformed in stages. The...

### Travel Graphs

This interactive excel program covers distance/time and velocity/time graphs.

The first interactive sheet shows a distance/time graph made of line segments and some questions relating to speed for each segment and the time when velocity is zero.

The second sheet shows the journeys of two people.

...### Gradient

This excel program contains a series of interactive spreadsheets designed to explore the concept of a gradient of a curve.

The first activity illustrates that the gradient of a function, at a point P, is the gradient of a chord PQ as the length of PQ tends to zero. The equation of the quadratic can be...