Loading
Home › Mathematics Help › Using numeracy and data & It
Status: Completed
 View Work

Using numeracy and data & It

Date Posted: 19/10/2020
Category: Mathematics
Due Date: 21/10/2020
Instruction
I will attach the Sheet and the question relating it . Part 3 – Using IT This part requires the use of Microsoft Excel. Covers Learning Outcomes 3 & 4 12. Create the spreadsheet below using Excel. Include the rows and columns identifiers, text formatting and column highlighting as shown. (15 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) 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 total medals awarded? (3 marks) 14) Write the Excel functions for the following: (5 Marks each) Give the total number of medals for Germany and Great Britain. b. Give the average number of silver medals for a European country, c. Sum the Medals Total for Gold for those countries with less than 20 games involvement. d. Search the database (the whole spreadsheet) to find ‘Italy’ and also the corresponding Medals Total. 15) a) Calculate the median number of medals for each medal type, stating the formula you would use for determining the median for the gold medals. (5 marks) b) Calculate the mean number of medals for each of the 3 medal types, stating the formula you would use for determining the mean for the bronze medals. (5 marks) 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)
Attached
Download File 1 (jpg)
Download File 2 (rtf)
Tutor Uploads
Download File 1 (docx)
Download File 2 (docx)
Bidders
COMMITEDTUTOR 5 years, 11 months ago
Rated 9.18 earned 5387.52 around 193 assignments.
Hello client, I am a tutor, COMMITTED to guarantee you an outstanding and professional assignment that is free from PLAGIARISM and GRAMMATICAL ERRORS before its DUE TIME. I'm reliable and flexible with budget. kindly assign me this project and I will deliver a quality work on time. Thank you in advance.
$100.00
  • Hello dear, I will deliver excellent results for this assignment. Please assign me, I will be honored. Thanks
    COMMITEDTUTOR | Oct 19, 2020, 17:40 PM
  • Are you familiar with the work
    User_31824 | Oct 19, 2020, 17:48 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
tutorforyou 5 years, 11 months ago
Rated 9.04 earned 17105.49 around 504 assignments.
I have read and understood the instructions of this order and I assure you that I will dedicate all my time and effort to deliver a high-quality paper that you need. I have all the necessary materials needed required to successfully complete this order. As you can see in my profile, I am HIGHEST RATED writer. If you approve my bid, I guarantee quality work that is 100% unique and plagiarism free. Thanks in advance
$80.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
expert4u 5 years, 11 months ago
Rated 9.0 earned 77109.21 around 2331 assignments.
Hi, this is my area of expertise. Award me this project and you will be assured of quality work. Thank you
$40.00
  • are you familiar?
    User_31824 | Oct 19, 2020, 18:13 PM
  • Yes. I will do it perfectly. Kindly assign me.
    expert4u | Oct 19, 2020, 18:16 PM
  • Great will you do for cheaper as my limit is 20
    User_31824 | Oct 19, 2020, 18:24 PM
  • 40 is the most fair price for this assignment.
    expert4u | Oct 19, 2020, 18:26 PM
  • of your willing to take 30 thats my max budget do let me know
    User_31824 | Oct 19, 2020, 18:32 PM
  • 30 is still low my dear.
    expert4u | Oct 19, 2020, 18:33 PM
  • okay thanks anyways
    User_31824 | Oct 19, 2020, 18:34 PM
  • Okay welcome.
    expert4u | Oct 19, 2020, 18:35 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
phoniextutor 5 years, 11 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
hello, friend, I am a well-experienced writer who will work on your paper with the needed professionalism. I promise you a quality paper that has passed the Turnitin test. I will deliver the Turnitin report for your work as proof of originality. kindly assign me your order and I assure you of timely delivery. thank you.
$80.00
  • hello, friend, I am a well-experienced writer who will work on your paper with the needed professionalism. I promise you a quality paper that has passed the Turnitin test. I will deliver the Turnitin report for your work as proof of originality. kindly assign me your order and I assure you of timely delivery. thank you.
    phoniextutor | Oct 19, 2020, 17:43 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
smartestwriter 5 years, 11 months ago
Rated 9.54 earned 25983.04 around 898 assignments.
Hello dearest customer, I have gone through the instructions on your assignment and understood them. I will follow the instructions keenly and support the paper with credible in-text citations and references. I will deliver the homework in a timely manner with zero plagiarism. Kindly assign the homework to me and I will not let you down. Thank you in advance.
$80.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
kingz 5 years, 11 months ago
Rated 9.4 earned 52183.12 around 1434 assignments.
Hello dear client assign this one to me and i will give you a 100% score.
$32.00
  • Are you filmier?
    User_31824 | Oct 19, 2020, 17:53 PM
  • ???????????
    User_31824 | Oct 19, 2020, 18:13 PM
  • Hello yes I will do this assignment for you
    kingz | Oct 19, 2020, 18:35 PM
  • great I have attached both The Olympic sheet and the question for it have you had a look and if your okay I will go ahead and pay now
    User_31824 | Oct 19, 2020, 18:36 PM
  • Yes go ahead and assign it to me
    kingz | Oct 19, 2020, 18:39 PM
  • Oh I thought the price you stated was $20 now its gone higher?
    User_31824 | Oct 19, 2020, 18:41 PM
  • Yes the system updated it to $45
    kingz | Oct 19, 2020, 18:42 PM
  • Oh Thats to high for me
    User_31824 | Oct 19, 2020, 18:43 PM
  • I can ask them to make it $40
    kingz | Oct 19, 2020, 18:43 PM
  • I can do a max $32
    User_31824 | Oct 19, 2020, 18:45 PM
  • okey
    kingz | Oct 19, 2020, 18:46 PM
  • Okay i made the payment
    User_31824 | Oct 19, 2020, 18:53 PM
  • good I will start working on it right away
    kingz | Oct 19, 2020, 18:54 PM
  • Thanks so much so you have everything the chart and the question.?
    User_31824 | Oct 19, 2020, 18:59 PM
  • Im a bit stressed how is it going?
    User_31824 | Oct 20, 2020, 02:05 AM
  • Am on it everything is okay
    kingz | Oct 20, 2020, 02:07 AM
  • check on it and release the payment
    kingz | Oct 20, 2020, 22:40 PM
  • Hi Question 15 = D is missing. is that one done? and also 12 is missing too.
    User_31824 | Oct 21, 2020, 00:00 AM
  • I will check on it and let you know
    kingz | Oct 21, 2020, 00:02 AM
  • ok do let me know
    User_31824 | Oct 21, 2020, 01:26 AM
  • check on it now and release the payment
    kingz | Oct 21, 2020, 07:17 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
committedwriter 5 years, 11 months ago
Rated 9.14 earned 89563.32 around 3017 assignments.
I am an expert in this subject with enormous experience Kindly consider my bid and I will timely deliver quality work that meets your expectation.
$80.00
  • Are you fimiler?
    User_31824 | Oct 19, 2020, 17:48 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}
 
 
Excellentessays 5 years, 11 months ago
Rated 9.72 earned 56371.38 around 2080 assignments.
Hi client, Kindly assign me for an EXCELLENT assignment. I'm flexible, reliable and I strictly follow instructions. Thank you.
$80.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[7] $}

{$ showNewChatSuccessMsg[7] $}
Unable to send Message: {$ showChatProcessErrorMsg[7] $}
 
 
TalentedTeacher 5 years, 11 months ago
Rated 9.33 earned 18202.75 around 525 assignments.
Hi client, I’m an expert in this assignment and I am really interested in helping you. Kindly consider my bid for an excellent result. Thank you.
$90.00
  • Are you familiar?
    User_31824 | Oct 19, 2020, 17:46 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[8] $}

{$ showNewChatSuccessMsg[8] $}
Unable to send Message: {$ showChatProcessErrorMsg[8] $}
 
 
exclusivewriter 5 years, 11 months ago
Rated 9.41 earned 74860.53 around 2443 assignments.
Hello Dear, I have checked your instructions and I can deliver. Thanks
$70.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[9] $}

{$ showNewChatSuccessMsg[9] $}
Unable to send Message: {$ showChatProcessErrorMsg[9] $}
 
 
surrogatewriter 5 years, 11 months ago
Rated 9.31 earned 75264.37 around 2854 assignments.
Hello Dear, I have checked your instructions and I can deliver. Thanks
$70.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[10] $}

{$ showNewChatSuccessMsg[10] $}
Unable to send Message: {$ showChatProcessErrorMsg[10] $}
 
 
aggrey 5 years, 11 months ago
Rated 9.47 earned 33434.92 around 816 assignments.
Hello! I can work on this task asap. I can also help you with the whole class at a discount!
$65.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[11] $}

{$ showNewChatSuccessMsg[11] $}
Unable to send Message: {$ showChatProcessErrorMsg[11] $}
 
 
queen 5 years, 11 months ago
Rated 9.56 earned 68909.63 around 2359 assignments.
I am well experienced and dependable tutor in your field of study who will always give you quality work that is FREE FROM GRAMMATICAL ERRORS and PLAGIARISM. I am online and ready to start working on your assignment.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[12] $}

{$ showNewChatSuccessMsg[12] $}
Unable to send Message: {$ showChatProcessErrorMsg[12] $}