# Explain the terms (a) numerator, (b) denominator [Solved] Use basic numerical operations with whole numbers, integers, fractions and decimals

0% Plagiarism Guaranteed & Custom Written

Student Assignment Guidance – Using Numeracy, Data and IT

 at the following times: 5 minutes past the hour, 25 minutes past the hour and 45 minutes past the hour. The meeting venue in Birmingham is a 5-minute walk from the station. What is the latest time that Annabelle can leave home, if she is to make it on time for the meeting in Birmingham? Show your working. (8 marks) Question 10 A box of Shredded Wheat weighs 0.35 kg and a box of Weetabix weighs 9/25 kg? Which box is heavier? Show your working. (4 marks) . Total Marks for Part 1 is 60. In answering Question 10, please show your working. Part 2 – Using Data (40 Marks) Given below is Medals Table for one of the recent Olympic Games 2 In answering Part 2, use only the given information in the medals table, showing your working wherever possible. Do not reproduce/create the spreadsheet.
 11) a) Which country had the lowest number of overall medals among the ten countries? (2 marks) b) Which country/countries competed in the least number of games? (2 marks) c) What is the mode in the number of games countries participated in? (2 marks) d) What is the range between the gold medals awarded to the 10 countries? (3 marks) e) How many countries got more silver medals than bronze medals? (3 marks)

 13. a) What actions or steps in Excel can you take to rank them from 1st to 10th (4 marks) b) State the specific action(s) or step(s) in Excel that will produce a list/display of those countries with 800 or more medals in total? (4 marks) c) Which type of graph will be suitable for representing only gold medals information? (2 marks) d) In which column(s) might replication have been used? (2 marks) e) What Excel formula can be used to calculate the overall In answering Question 13a, please state the specific steps you would follow, in a bulleted or numbered fashion. This will involve noting the specific column and row labels and the appropriate tools on the Excel toolbars. There is more than one way to accomplish the sorting. Just explain ONE way of doing this. In answering Question 13b, please state the specific steps you would follow, in a bulleted or numbered fashion. This will involve noting the specific column and row labels and the appropriate tools on the Excel toolbars. There is more than one way to accomplish the filtering. Just explain ONE way of doing this. In answering Question 13c, just state a type of graph or chart that will be suitable for representing the Gold medals information (shown in Column C). In answering Question 13d, ask yourself what replication is and why it might be used. With that understanding, you can then identify the

 c) Calculate the standard deviation of the total medals awarded to each country (column F) using the formula below. Show all the steps (full working). You can use the STDEV.P function to cross-check your final answer. (10 marks) d) Using the given spreadsheet as a basis, discuss the usefulness of a standard deviation in a given dataset. You need to cite any literature sources you use. (10 marks) 16. a) Produce an appropriate fully-labeled chart to compare the gold, silver and bronze medals totals of the 10 countries. (10 marks) b) Use a suitable and fully-labeled chart to reflect the contribution of each country to the overall medals total. (10 marks) Total Marks for Part 3 is 100. In answering Question 15c, show all the intermediate steps used to calculate the standard deviation. Then verify your answer using the Excel standard deviation function, STDEV.P           In answering Question 15d, cite credible sources to support your answer. Make sure you use the AU Harvard Referencing format.         In answering Question 16, ensure that the charts are fully-labelled.

Student Checklist – Using Numeracy, Data and IT

100% Plagiarism Free & Custom Written,

## Our Giveaways

Plagiarism Report

for £20 Free

Formatting

for £12 Free

Title page

for £10 Free

Bibliography

for £18 Free

Outline

for £9 Free

Limitless Amendments

for £14 Free

Get all these features for
£83.00 FREE

##### Still Not Convinced?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains