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

image13.png

image14.png

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

image08.png

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

See related essaysSee related essays

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

  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

    With the age of the artist I realised that the older the artist gets the more CD's are sold (positive correlation), I presume this is because the artists fan base gets bigger as the band gets older. The cumalative frequency graph shows us that as the band gets older the sales of each of the albums increase.

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

    I do not know precise details about the experiment, such as where and how it took place. If some pupils saw the stick in a large room and others saw it in a smaller room, it may affect how small or large pupils perceive the stick's length.

  2. maths estimation coursework

    In order to attain a representative stratified sample for all gender and year groups, I will take a sample of 140 people. 140 I will now calculate my stratified sample for 140 results. Remembering my populations of year 8 and year 12: Year 8: Female - 53 Male - 58

  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