Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

STA 1 5 0 1 / 0 1 1 / 0 QUESTION 2 Suppose you are given the following sample of STA 1 5 0

STA1501/011/0
QUESTION 2
Suppose you are given the following sample of STA1506 students.
Spreadsheet 2: Sample of STA1506 student performance.
(a) Which graphical display would you use to display the variables Gender and Race of the entire sample? Explain why you would use this graphical display.
(b) Display variable Gender using the answer in question 2(a). Use the appropriate labels on the graph.
(c) Suppose you are told that there was an omission of three students in the sample. The data editor asks you to add Percy Chukwu, an African female who obtained 50%. The entry is to be added between Pertunia and Allowance in the database. Add the information as instructed by the editor to the sample and explain how you added Percy Chukwu who currently resides in Madagascar but Percy is Nigerian by nationality.
(d) Now add Excellent Naidoo. Excellent is a Male, who obtained 81% and he is Indian by race. Add Candice Mooiloop, a Female, who obtained 66% from a coloured race, as student number 8. Display the updated STA1506 sample following the instructions given in questions 2(c) to (d) by highlighting the new information.
(e) Sort the sample by surname in ascending order and explain or write down each step on how you sorted the sample in ascending order. Clearly show the display of the current sample spreadsheet after sampling.
(f) After communicating with the assignment department, the editor was updated about the corrupt files of Petunia van der Merve (whom the name was spelled incorrectly as Pertunia) and Feng Hu (whom her identity was incorrectly placed as Hu instead of Feng Hu with race Other. The assignment department also updated that these students each obtained 38% and 71% in general. Another update says that Grace Baloyi is black in race. Furthermore, display the final sample of the STA1506 students after updating the given information arranged in ascending order by variable Surname. Moreover, use a pie chart to display the information related to variable Race. Lastly, between a bar chart and a pie chart, which one looks more appropriate to display variable Race information? Motivate your answer.
(g) Name the procedure used to solve problems posted in questions (c) to (f) under the instruction of the editor.
(2)
41
3
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Fundamentals Study Guide

Authors: Dr. Sergio Pisano

1st Edition

B09K1WW84J, 979-8985115307

More Books

Students also viewed these Databases questions