• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  • Level: GCSE
  • Subject: ICT
  • Word count: 1414

I am investigating into Price

Extracts from this document...


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.


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.


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


    should take the user to chart summary sheet without a problem Macro works as expected Before Sub mcrchart() ' ' mcrchart Macro ' Macro recorded 16/01/2007 by 21bor2413j ' ' Sheets("Pivot Table A").Select ActiveSheet.PivotTables("PivotTable3").RefreshTable Sheets("Chart1").Select End Sub After Sub mcrchart()

  2. ICT Coursework (MarcoS)

    It's the fastest way to make invoices and calculus sheets. New System The objectives of the new system are: - The system has to be easy to set up and to use - The system has to be safety - The system will be accessible from all part of the

  1. a level ict project

    Consequently, they are required to go out and purchase one; the user guide placed later in this project explains the minimum and recommended specifications, which the end user can use to justify the purchase of a selected system. Old System vs.

  2. Develop a spreadsheet application for the Ibis Hotel.

    * Validation checks are carried out automatically by the database. The software that will be used While doing this course I will need many software packages to transcribe all of the data on the computer. The software that is mainly going to be used by me is word processing program

  1. Model Price Chart.

    ==> Cool day: hot drinks - 325, cold drinks - 175 ==> Cold day: hot drinks - 375, cold drinks - 100. With this information, I will be able to predict the amount of sales and therefore the amount of profit expected for each different price or weather condition.

  2. Database Coursework

    Analysis My Chosen Method I think the best method to use would be to use an interview. I would prefer to do this over all the others, because it would definitely give me back the most information compared to any other methods.

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