• 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
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  • Level: GCSE
  • Subject: ICT
  • Word count: 4509

Excel user guide

Extracts from this document...

Introduction

Contents Bar charts Simple Bar Chart In order to construct a simple bar chart using Excel you will have to follow the following steps. A bar chart would be nothing without data in order to base the bar chart on. Create a table with the following data below. Day Armando's Wages Monday 8,892 Tuesday 5,092 Wednesday 3,072 Thursday 8,972 Friday 13,603 Saturday 15,754 Total 55,371 Once you have inputted data in the spreadsheets highlight the data and click on the bar chart icon Once you have selected the bar chart icon a dialog box will appear with the title chart wizard. This Wizard will take you through 4 stages in order to construct the bar chart. Steps to simple bar chart First step - Select column for the chosen bar type. You will be presented with a chart sub type on the right hand side of the dialog box, select the standard format which has been automatically been chosen. Then select Next. Second step - The second step will illustrate the chart source data within the bar chart. This will allow you to arrange or edit your data. Once you had double-checked your data select Next. Third step - The chart option will now appear in the third step. Here you will be able to name your Y and X-axis. Once you have named your axis select Next. Fourth step - The fourth step will allow you to locate your chart either within the spreadsheet you entered your data in or in a new spreadsheet. Then select finish. Once you have selected finish you should have a simple bar chart like the one shown below. Multiple Bar Chart In order to construct a multiple bar chart using Excel you will have to follow the following steps. A multiple bar chart is very similar to a simple bar chart. The procedures are the same but with the exception of additional data. ...read more.

Middle

Do not delete the bottom cell, which should contain the number 0. This is there for calculation purposes. Steps to construct a Histogram Now that you have found the frequency of the lower and upper class boundaries you will need to create a histogram to go with it. We will be creating a histogram within the format of bars. Before you create your histogram you will need to enter the lower and upper class boundaries in the spreadsheet like shown below. Upper and Lower class boundaries 143 - 144 144 - 145 145 - 146 146 - 147 147 - 148 148 - 149 149 - 150 150 - 151 151 - 152 152 - 153 Highlight the frequency data and once again click on the bar chart icon Steps 1 - Follow the same step as the previous simple bar chart for step 1 Step 2 - click on series, this section will allow you to label the X axis of the histogram bars. In order to do this click here Once you have clicked here you will then have to highlight the lower and upper class boundaries that you just entered in the spreadsheet. Step 3 - The chart option will now appear in the third step. Here you will be able to name your Y and X-axis. Once you have named your axis select Next. Step 4 - The fourth step will allow you to locate your histogram either within the spreadsheet you entered your data in or in a new spreadsheet. Then select finish. Once you have selected finish you should have a histogram like the one shown below. Editing the histogram To emphasise the continuity of the variable axis, the gaps must not be left between the bars in a histogram. 1) As you can see there are gaps in between the bars of the histogram in order to get rid of these gaps you will have to double click the bar. ...read more.

Conclusion

f0 149 f1 10 f2 151 mode 49.49642857 Standard Deviation Standard deviation is a measure of the range of values in a set of numbers. Standard deviation is a statistic used as a measure of the dispersion or variation in a distribution, equal to the square root of the arithmetic mean of the squares of the deviations from the arithmetic mean. The formula for standard deviation is shown below Standard deviation = Efx2/Ef - (Efx /Ef)2 The table below will provide you with data which will enable you to calculate the standard deviation. LCB UCB frequency Mid point (x) fx fx2 143 144 2 143.5 287 41184.5 144 145 1 144.5 144.5 20880.25 145 146 2 145.5 291 42340.5 146 147 3 146.5 439.5 64386.75 147 148 5 147.5 737.5 108781.25 148 149 7 148.5 1039.5 154365.75 149 150 10 149.5 1495 223502.5 150 151 6 150.5 903 135901.5 151 152 3 151.5 454.5 68856.75 152 153 1 152.5 152.5 23256.25 0 5944 ?F 40 5944/40 = 148.6 x*fx=fx2 standard deviation = Efx2/Ef - (Efx /Ef)2 = 882981.2 Simple and compound interest Simple In order to find a simple 5% interest cost of �1000 within the time of 8 years you will have to do the following: The simple formula is A= P (1+ni) In the spreadsheet type in the following data Interest � (p) Percentage (i) Years (n) 1000 0.05 8 Once you have entered the data into the spread sheet select a cell and enter the simple formula which should be like the one below. A = 1000 (1+8*0.05) Now you should have the results for the simple interest Simple A = 1400 Compound Using the same data you will be able to calculate the compound interest of 5% of �1000. The compound formula is A= P (1+i)n Enter the following data into the spreadsheet. Begin End �1000 1050 Once you have entered this data you will have to enter the compound formula in the cell under End 1050. A = 1000(1+0. ...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. GCSE Excel Project ICT

    Data input explained with details of validation. The information about the products sold will be written into tables, which will then be inserted into a respective spreadsheet. The table will have the product name, the Features, Size (be it physical or data storage), speed (if needed)

  2. ICT - User Guide

    The message will stay in the recipients mail until the person logs in to see their mail. This communications process is carried out via TCP or IP (Transmission Control Protocol/Internet Protocol).

  1. task2-report-template 3

    He needs to be able to answer this question without leaving his desk and quickly. For each laptop he needs to see list of these: * Model * Brand * Processor Type * Memory Size * Memory Type *

  2. Design Section

    as Macro's, List boxed, combo boxes, Option buttons, Sliders, Scroll bars, Indexes, Check boxes, and Pivot tables. * List user requirements - Microsoft will allow me to meet the user requirements because I can use Comment boxes + Input and output message and error alerts.

  1. The new system is required to calculate the costs of a new car as ...

    After conducting an initial interview with Mr. Cruiser, I can deduce that the current system in use would be too slow to meet the demands of the business while it is expanding, as such, it does seem that an automated system would be more appropriate. It also appears that the paper-based method means that the customer base

  2. The end user of my program is for the people applying for the insurance ...

    want the database to store around 150 Me: Again I thank you for taking time out of your busy schedule I am going to do what I can and start on the database straight away Doyle: Thanks for your time, good bye Me: Bye Identifying the Problem The system that

  1. Statistics Study Guide

    Independent variable is a value determined by the experimenter not subject. Dependent variable is the variable that is measured in a study the idea being it depends on the level /existening of IV. Demand characteristics are cues inadvertently provided by the researcher or research untext concerning the purposes of the study or the behavior expect from the part.

  2. ICT (double award) - Business systems portfolio.

    * There are 3 laptops which have been upgraded to the spec of the desktops; they also have an Ethernet adapter and a 56k modem which enables them to connect to the network from an outside line. * There is a server rack which controls the computers connected to the

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