Assignment Outcomes: After completing the module, you should be able to:
1) Use basic numerical operations with whole numbers, integers, fractions and decimals.
2) Calculate and compare measures of central tendency.
3) Calculate compound interest.
4) Construct and use appropriate graphical techniques to present simple data.
5) Construct and use a spread sheet application to record numerical data and use appropriate formula functions.
6) Design numerical analyses in response to given problem situations.
Assignment Part I:
Problem 1: What is the result of the following calculation? Leave your answer in a tally format.
Problem 2: What percentage of 70 do 49 equate to?
Problem 3:
a) Complete the table to show equivalent fractions and percentages.
|
Fraction
|
Percentage
|
|
|
45%
|
|
02-Mar
|
|
|
|
22.50%
|
|
07-May
|
|
A carton contains 150 cereal bars. What fraction of this number will each person get when distributed to a class of 20 students?
Problem 4: Samuel paid cash for 3 discount-priced football tickets. He was given £4.20 change from the three £50 notes he tendered. What was the price of each ticket? Show your working.
Problem 5:
a) Solve this binary arithmetic: 10011 +10101
b) Write the number 0.0101 as a power of 10.
Problem 6: As a promotional offer, a new hair salon offered its services at 20% discount for the first 2 weeks. Janice and her friends took advantage of the bargain and had their hair done for a total amount of £100. Show your working.
a) What were the total savings made?
b) Work out the average savings amount if 4 hairdos were done?
Problem 7: Here are seven numbers.
5 12 12 8 4 10 5
a) Work out the mean of the seven numbers.
b) What is the mode of the seven numbers?
Problem 8: 80 men and 120 women were asked if they enjoyed watching football. Altogether 3 / 5 of the people said yes.
9 / 10 of the men said yes.
What fraction of the women said yes? (Show your working)
Problem 9: The table shows information about the marks of 20 students in a test.
|
Mark
|
Frequency
|
|
14
|
2
|
|
15
|
5
|
|
16
|
4
|
|
17
|
4
|
|
18
|
5
|
|
|
Total = 20
|
Students who scored less than the mean mark have to retake the test. How many students have to retake the test? You must show your working.
Problem 10: Which fraction is bigger - 3/5 or 5/9?
Assignment Part II:
Given below is the payroll for a particular week for GGG Consulting.
|
GGG Consulting
|
|
Weekly Payroll
|
|
First Name
|
Surname
|
Gender
|
Hourly Rate
|
Hrs Worked
|
Gross Amount
|
Deductions
|
Net Amount
|
|
Andy
|
Brayton
|
M
|
£15.00
|
30
|
£450.00
|
E67.50
|
£382.50
|
|
8ronwyn
|
Dykes
|
F
|
£22.00
|
20
|
£440.00
|
£66.00
|
£374.00
|
|
Candice
|
Marfouche
|
F
|
£18.00
|
25
|
£450.00
|
£67.50
|
£382.50
|
|
Richard
|
Clement
|
M
|
E30.00
|
30
|
£900.00
|
£135.00
|
£765.00
|
|
Denise
|
Holten
|
F
|
E21.03
|
35
|
£735.00
|
£110.25
|
£624.75
|
|
Tanika
|
Hall
|
F
|
E12.00
|
28
|
£336.00
|
E50.40
|
£285.60
|
|
Sandra
|
Smith
|
F
|
E14.00
|
26
|
£364.00
|
E54.60
|
£309.40
|
|
Fred
|
Patridge
|
M
|
E18.00
|
40
|
£720.00
|
£108.00
|
£612.00
|
|
Patrice
|
Neville
|
F
|
E20.00
|
35
|
£700.00
|
£105.00
|
£595.00
|
|
Everett
|
Castlemain
|
M
|
£25.00
|
30
|
£750.00
|
£112.50
|
£637.50
|
|
Sunil
|
Praveen
|
M
|
£23.00
|
28
|
£644.00
|
£96.60
|
£547.40
|
|
Julia
|
Morkoe
|
F
|
£25.00
|
28
|
£700.00
|
£105.00
|
£595.00
|
|
Charlotte
|
Mess(
|
F
|
£17.00
|
30
|
£510.00
|
£76.50
|
£433.50
|
|
Brendan
|
Philips
|
M
|
£24.00
|
32
|
£768.00
|
£115.20
|
£652.80
|
|
Harry
|
Charleston
|
M
|
E30.00
|
30
|
£900.00
|
£135.00
|
£765.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Grand Total
|
£5,292.95
|
|
|
|
|
|
|
|
Average Amount
|
£530.80
|
a) What actions or steps will you need to take to sort the given spreadsheet in alphabetical and ascending order of Firstname.
b) Write the command(s) to list/display only those who worked less than 35 hours in the week.
c) How many people earn above the given Average Amount?
d) Which type of graph will be suitable for representing the Net Amounts?
e) In which column(s) might replication have been used?
f) What formula results in the value in cell H20?
Problem 11: Write the functions or commands for the following:
a. Give the total number of females.
b. Give the total number of records with hourly rate less than £25?
c. Give the total number of surnames with the letter 'p' in them
d. Sum the Net Amount for the females who earned a Net Amount greater than or equal to £495.
e. Search the database (the whole spreadsheet) to find 'Messi' and the corresponding Deductions.
Assignment Part III:
This part of the assessment covers Learning Outcomes 2, 3 and 4 and is worth 80% of the total marks for the module.
Students Monthly Spending, excluding accommodation, bills and transportation Monthly Expenditure (in pounds sterling)
|
Name
|
Campus
|
Marital Status
|
Food
|
Clothing
|
Entertainment
|
Charitable Giving
|
|
Jenny
|
London
|
S
|
160
|
230
|
80
|
0
|
|
Annie
|
Manchester
|
S
|
180
|
220
|
50
|
10
|
|
Haddy
|
Manchester
|
M
|
255
|
145
|
45
|
15
|
|
Martin
|
Birmingham
|
S
|
240
|
165
|
100
|
0
|
|
Ahmed
|
London
|
M
|
375
|
195
|
140
|
10
|
|
Sean
|
London
|
S
|
185
|
135
|
130
|
20
|
|
Alice
|
London
|
M
|
260
|
260
|
70
|
20
|
|
Belinda
|
London
|
M
|
320
|
140
|
105
|
15
|
|
Benjie
|
Birmingham
|
S
|
245
|
230
|
60
|
40
|
|
Barbara
|
Manchester
|
M
|
305
|
150
|
100
|
0
|
|
Liam
|
Birmingham
|
M
|
400
|
80
|
100
|
20
|
Managerial Report (max: 2000 words)
Comment on the spending information presented in the table above. Include the following in your report:
a. Totals, mean, median and standard deviation, together with a discussion of what these descriptive statistics tell us about their spending.
b. Graphical summaries for each of the four items.
c. Scatter diagrams to explore the relationship between marital status and each of the four spending items. Discuss.
d. What is the probability that a student spending more than £500 monthly would be both married and based in London?
It is prudent to take online assistance from the Numeracy, Data and IT Assignment Help service for excelling your academic grades. We are the leading online service provider organizations in the industry and are mostly preferred by the university students.
Tags: Numeracy, Data and IT Assignment Help; Numeracy, Data and IT Homework Help; Numeracy, Data and IT Coursework; Numeracy, Data and IT Solved Assignments; Measures Of Central Tendency Assignment Help; Measures Of Central Tendency Homework Help