• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1414

I am investigating into Price

Extracts from this document...

Introduction

Firstly I have decided to present my data in Tally Charts, I think this is a clear way to get a feel for the data itself. I have chosen these class intervals because the price of my cars range from �1 100 to �41 500, including petrol and diesel cars. I thought these intervals would also be better because this way there is 9 intervals and I need between 7 and 10 intervals. I also looked at the range of prices for both petrol and diesel so that they have the same class intervals, this will make it easier to compare. I will have to sort and resort my data because at this stage I am investigating into Price, but later I will be looking into Age, so a resort of my data will be necessary. Tally Chart for Price - Diesel Band Of Price (�) To the nearest � Tally Frequency Cumulative Frequency 0 ? � < 4 999 | | | | | | | | | | | | | | | | | | | | | 26 26 5 000 ? � < 9 999 | | | | | | | | | | | | | | | | 20 46 10 000 ? ...read more.

Middle

is the median: The median for Petrol = �7 995 The median for Diesel = �6 495 Mode: The modal value is the most common value that appears in the data. I kept my data in the order from lowest to highest and looked down to see which of the numbers appears more often than the others. The modal value for Petrol = �4 999 The modal value for Diesel = �6 374. 50 Range: The range is simple to work out. All I have to do is take the lowest value form the highest value: The range for Petrol is = �36 350 The range for Diesel is = �40 400 Now I will draw tables to present the information clearly: Petrol Diesel Mean �10 970.17 �10 188.17 Median �7 995 �6 374.50 Mode �4 999 �6 374.50 Range �36 350 �40 400 This doesn't really tell me a lot as for the mode and range, diesel is higher and for the mean, petrol is higher. The means are quite close and the ranges and modes are further apart. This could tell me that diesel is slightly more expensive as the diesel range is and it's mode. ...read more.

Conclusion

When looking at these I realised that because the inter quartile ranges, upper quartiles and lower quartile are all very close, this is the reason that these outlier values are only �500 apart as well. I have decided to discard these outliers they are extremes. The reason I have chosen to carry on this way because I do not want these large values distorting the rest of my data and calculations. I am going to redraw my box plots with these changes. After taking out my outliers I have 67 diesel values and 64 petrol values. Standard Deviation: I am going to work out the standard deviation to take my project one step further. Petrol: The spreadsheet on the next page explains how I did the standard deviation calculations. After finding the variance, I did the square root of it to get standard deviation! Variance = 31314359.46 31314359.46 = 5595.92 (2 dp) Standard Deviation = �5595.92 Diesel: The spreadsheet following the petrol workings will explain the diesel standard deviation. Variance = 47647391.3 47647391.3 = 6902.71 (2 dp) Standard Deviation = 7437.95 The analysis of Standard Deviation for Price has been written with the Age Standard Deviation, further on in the project. ?? ?? ?? ?? Victoria Porter 10 B GCSE Statistics Coursework Candidate Number = 6082 Centre Number = 31015 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 ICT Systems and Application essays

  1. ICT PROJECT

    able to move the buttons or type ink text User is able to delete buttons because sheet protection had not been set up Repeating text Try to delete macro buttons and move them around the sheet on the front end menu To verify sheet protection works correctly User should not

  2. ICT Coursework (MarcoS)

    * Make two combo boxes as show in the picture on page 34; be sure to draw them in the same position as shown in the picture. * On the first one (below "select customer"), for: Input Range: Then open the customer worksheet, and select the name of the first

  1. Ict Powerpoint Coursework

    There should be about 2-3 pictures on each slide, the pictures should have clear backgrounds and be of the best quality possible. 3. Test if all the spelling and grammar is correct on the presentation. There should be no spelling and grammar mistakes and all of the PowerPoint Presentation should be descriptive.

  2. Database Coursework

    The user should be able to print a list of overdue DVDs which are low of stock in less than 1 minute. * The system will automatically tell me which DVD's are overdue. System related objectives * The system will be protected by a password, so that only authorised personnel will be able to access customer, DVD's and Rental details.

  1. GCSE IT Coursework

    ICT Advantages ICT Disadvantages Non-ICT Advantages Non-ICT Disadvantages Saves space Can crash and lose data Cheap Can be destroyed in a fire User can perform more actions such as sorts.

  2. System requirements analysis

    Another drawback to the software that I have created is that it is not very secure, the security level is quite low. There is no password to protect the file but it the file is protected in such a way that it cannot be altered.

  1. a level ict project

    The main output of the system is paper based documents once initial use of the file has passed they will be placed in filing cabinets. The garage has been operational for an extended time period; as a result a lot of space has been taken up with filling archives, thus

  2. Develop a spreadsheet application for the Ibis Hotel.

    * Finding files can be very problematical. * Many files can also be lost or misplaced. * Validation is also a problem. This is because to check many files manually is very difficult. * Security is not very obtainable. * Whilst editing any problems it can be very hard to rearrange any disorders, as the whole page will have to be re-written.

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