• 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

Middle

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

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

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