• 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.

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.

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!

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. Statistics coursework

- 124 / 4 = 31 (sample of 31) - 116 / 4 = 29 (sample of 29) I found that I needed to take a sample of 31 females and 29 males for proportional representation. I then selected random samples using the random number generator on my calculator.

1. Maths T-totals coursework

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

2. GCSE STATISTICS/Data Handling Coursework 2008

As it was made using stratified sampling it should give a fair representation of the whole school's data. For the second hypothesis I shall use all of the year nine data for shot putt as they have the most students with a recorded distance for when they were in years 7, 8 and 9.

1. Maths Statistics Coursework

As I expected the highest range of 51.02 belongs to Key Stage 3, with Key Stage 4 having a slightly lower range of 46.26. The lowest range was Key Stage 5 with 41.5, as expected as these are the oldest students and are also all the highest ability.

2. Rollercoasters. I will use the rollercoaster database to answer the following question: ...

The only problem I encountered was the fact that the Scientific Calculator selected random numbers to 2d.p. This meant that I had to round to whole numbers, which sometimes resulted in having two numbers the same. When this happened, I would replace one of them with another randomly selected number.

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

Logarithmic trendlines are lines that use the fewest "squares" possible in order to fit through the equation y=cINx+b, where c and b are constants Power trendlines are lines that use the fewest "squares" possible in order to fit through the equation y=cxb, where c and b are constants.

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

Any number that is beyond these bounds will be deemed as an outlier and on my box plot I will mark the outliers with an X From these two samples I will draw 2 box plots. Box plots are good because they allow me to compare the consistency of a

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