• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4
5. 5
5
6. 6
6
7. 7
7
8. 8
8
9. 9
9
10. 10
10
11. 11
11
12. 12
12
13. 13
13
14. 14
14
15. 15
15
16. 16
16
17. 17
17
• Level: GCSE
• Subject: Maths
• Word count: 3657

Microsoft Excel Driving Tests Coursework

Extracts from this document...

Introduction

DRIVING TESTS

INTRODUCTION

I will investigate how well 240 people perform in their driving test. There is a mixture of male and female drivers and there are four instructors that teach them. I will investigate how many minor mistakes these driver’s make in their test. The information I have been given consists of:

• the driver’s gender
• the number of one hour lessons they have received
• the number of minor mistakes made during the test
• the instructor who gave the driver lessons
• the day they took the test
• the time of day that they took the test

The software I will be using to store this information will be Microsoft Excel. I will house the information in spreadsheets and here I will be able to select random samples and sort my data.

I will also be using a program called Autograph. This program will enable me to draw graphs and do important calculations. Without this software it would take me a long time to draw out the diagrams I need for the investigation.

During the investigation I will be using sampling. This is where I will be taking a portion of the population to gather my results, instead of using all 240 people. This means that the data will be easier to handle and I will have less points to plot on my graphs but still keep accurate results.

HYPOTHESIS ONE – MALES ARE BETTER DRIVERS THAN FEMALES

For my first hypothesis I will be answering the question “Are male drivers better than females.” To do this I will record the number of minor mistakes made during the driving test.

I will take a random sample of 30 males and 30 females and compare the results.

...read more.

Middle

10

14

A

31

7

A

13

14

A

15

12

A

22

14

A

25

6

A

11

14

A

30

12

A

6

27

A

15

11

A

11

3

A

20

14

A

10

1

A

Here are the data I will be using for my graphs for Instructor A. I will construct a scatter graph for each driving instructor showing mistakes against lessons, one graph for males and one for females. This will show me if the instructor prefers to take male drivers, and is he more effective at teaching males.

We have a complete set of data here with no missing values, this helps us to make more accurate conclusions. There are 29 pieces of data for males and 30 for females.

Remember that number of mistakes are on the y axis and number of lessons are on the x axis.

Here we can see that instructor A treats female and male drivers the same. The lines of best fit go in the same direction at almost the same angle. The best fit line seems to go through a number of points, showing us that it is accurate.

The correlation coeff shows us that for females it is -0.401 and for males is is -0.629. This shows us that the lines are very similar meaning that the instructor teaches men and women equally.

INSTRUCTOR B

MALE DRIVERS                          FEMALE DRIVERS

 No. of Lessons No. of mistakes Instructor 30 3 B 16 21 B 39 9 B 25 10 B 32 B 24 11 B 14 22 B 32 6 B 31 4 B 39 B 23 12 B 10 30 B 34 6 B 40 11 B 40 15 B 30 3 B 16 22 B 17 19 B 31 1 B 15 21 B 14 22 B 23 8 B 25 5 B 15 24 B 19 16 B 13 28 B 29 1 B 40 7 B 20 15 B 32 B No. of Lessons No. of mistakes Instructor 18 19 B 26 32 B 17 28 B 38 26 B 31 32 B 29 5 B 26 19 B 19 29 B 24 B 23 20 B 11 17 B 20 28 B 30 24 B 31 33 B 23 3 B 23 10 B 22 30 B 10 22 B 31 19 B 14 17 B 17 5 B 32 20 B 25 32 B 27 5 B 34 16 B 12 33 B 26 26 B 14 17 B 36 28 B 21 14 B

I do not have complete data for instructor B.

...read more.

Conclusion

FEMALE DRIVERS

When I compare the female box and whisker to the male box and whisker, the first thing that catches my eye is that for females all the average number of mistakes are above the male average number of mistakes. This shows me that every instructor gives females more mistakes than they do males.

Instructor C is the least consistent with his results as his inter-quartile ranges are the largest. He gives a wide range of results compared to instructor A and D who has the majority of their drivers in the same area.

The box and whisker diagrams are very helpful in exploring my hypothesis. I said that instructors prefer male drivers to females and I have proven this with my analysis.

CONCLUSION

My three hypothesis’s are linked together. In my first hypothesis I said that male drivers were better than females. I found this to be correct. I than asked if the number of lessons would affect the number of mistakes in the test. I found that they affected males but not females. I believed this to be unreliable data and a way of making it more accurate would have been to repeat the investigation. My third hypothesis was if the instructor made a difference on the number of mistakes you made and if the instructor preferred taking male drivers to females. I found that this was correct and that different instructors marked differently.

I would say that my investigation was a successful one and my hypothesis’ were correct. The software I used was accurate and gave me reliable results. Overall male drivers were better than females!

...read more.

This student written piece of work is one of many that can be found in our GCSE Miscellaneous section.

Found what you're looking for?

• Start learning 29% faster today
• 150,000+ documents available
• Just £6.99 a month

Not the one? Search for your essay title...
• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month

Related GCSE Miscellaneous essays

1. For our GCSE statistics coursework, we were given the question Where are houses most ...

/ 20(number of counties approx) = 1.5. 30/20=1.5. This meant I took 1 postcode from every county and an extra postcode from every second county. To find the house prices I would use, I just used a random sample; I generated the numbers I would use for the random sample using the random number generator on a calculator.

2. Maths driving test

is not much traffic, they will not stress and make fewer mistakes. * Area that the test is taken in- if the candidate takes their test in a place that they are quite familiar with, they may make less mistakes as they know there way around.

1. The aim of the project is to investigate the correlation between multiple sets of ...

The new version of the graph, similarly to the last edited version of a graph, very clearly shows a downward slant, this time being even more conclusive in proving that the hypothesis was indeed correct. Adding some trend lines to this graph - complete with R-squared values - shows even

2. Maths Coursework

We also notice that the increase in sales between each year gets slowly steeper, which means more albums are sold the older the band gets. However, I also noticed that the last album, Stadium Arcadium, experienced a drop in sales, despite the band being older, the price being highest and it having the highest average chart ranking.

1. Mathematics Handling Data Coursework: How well can you estimate length?

1.40, 1.60, 1.36, 1.50, 1.50, 1.00, 1.50, 1.50, 1.50, 1.15, 1.60, 2.00, 1.75, 1.63, 1.30, 1.66, 1.80, 1.20, 1.40, 1.80, 1.75, 1.65, 1.90, 1.60, 1.80, 1.30, 1.54, 1.55, 1.25, 1.25. In my Year Seven data set I found two rogue values (11.75m and 12.13m).

2. maths estimation coursework

Overall - 111 Year 12 population: Female - 65 Male - 50 Overall - 115 Total population: 226 Firstly, for a stratified sample I will need to calculate haw many year 8s and year 12s I will need. Year 8 Year 12 From my calculations I have determined that I

1. Investigation into 100m times and long jump distances

21.5 462.25 17.1 3.15 29 13 30 13 17 289 17.1 3.1 29 14 30 14.5 15.5 240.25 17.1 3.7 29 4 30 4.5 25.5 650.25 17.2 2 28 36 28 38 -10 100 17.4 3.8 27 3 27 3 24 576 17.8 2.75 25 24 25.5 24.5 1 1

2. Statistical Experiment Plan to investigate the ability to estimate 30 and 60 seconds.

group of data (IQR), the average of a group of data (median), and the spread of a group of data (skew). I want each box plots to be on the same scale so I am able to directing compare the two box plots.

• Over 160,000 pieces
of student written work
• Annotated by
experienced teachers
• Ideas and feedback to
improve your own work