A113_P09_WS.docx

A113_P09_WS.docx - School of Engineering A113 –...

  • No School
  • AA 1
  • 7

This preview shows page 1 - 3 out of 7 pages.

School of Engineering A113 – Mathematics Worksheet for Problem 09: Player Selection Organising Data 1. PlayerScore.xlsx contains the scores of Andrew, Bernard, Calvin and Dan in the selection trials for one week. The scores are arranged according to the day that they were recorded. One way to display the scores for easier interpretation is to use a frequency table . It is a record of how often each value or a set of values occurs. An example of a frequency table is shown in Table 1 below. Table 1 Score Range Frequency 311 to 315 316 to 320 321 to 325 326 to 330 331 to 335 336 to 340 341 to 345 346 to 350 351 to 355 356 to 360 Tabulate the scores of Andrew, Bernard, Calvin and Dan in a similar way as shown in Table 1. 2. We can represent information from the frequency table in a graphical manner with the use of a histogram . Copyright © 2013 by Republic Polytechnic, Singapore Page 1 of 7
Image of page 1

Subscribe to view the full document.

School of Engineering a) Describe some benefits of representing data in a graphical manner. b) Using MS Excel and the frequency tables in Q1, plot the histograms of the scores of Andrew, Bernard, Calvin and Dan. Analysis of Data based on accuracy of score 3. Let us look at the scores of Andrew, Bernard, Calvin and Dan. a) Determine the individual mean , mode and median scores for each of the four players. b) Which score (mean, mode or median) is the most representative of the players’ performance? Explain. 4. Would the mean, mode or median score alone be sufficient for you to justify which player you would choose to represent the school? Why? Analysis of Data based on variance of score 5. We should also consider the variance or “spread” of the scores of the players when choosing the best player. Study the histograms of the scores of Andrew, Bernard, Calvin and Dan that you have plotted in Q2. Based on the shape of the
Image of page 2
Image of page 3

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern