Using Excel
In order to be successful on the AS Use of Mathematics course, it is essential that you are confident in using spreadsheets (Excel). Set up a Use of Maths folder and work through the following exercises. Make sure you keep all completed documents.
Lesson 1:
How to draw a line graph in excel
Lesson 2:
How to draw a pie chart in excel
Lesson 3:
How to draw a box and whisker diagram using excel
Lesson 4:
How to draw scatter diagrams and find the line of best fit.
Lesson 5:
How to draw a histogram and frequency polygon in excel
Lesson 6:
How to draw a cumulative frequency graph in excel
Lesson 7:
How to draw graphs of different functions using excel
Using Your Calculator
Instruction sheet for using Casio fx85WA
.
Finding Sxy on the Calculator
Finding the standard deviation and Mean
Finding the regression line y = a + bx
Finding the standard deviation and Mean
Finding the regression line y = a + bx
Subscribe to:
Posts (Atom)