Welcome to the School of Data – Data Analysis Second Semester Exam.
Please take the time to read these instructions before you begin the test.
We recommend you have the following ready:
NB: Once you start the exam, you are not to open any other windows. If you do, the assessment will end immediately.
The test duration is 1hr: 30 min. There will be no breaks once you start.
This test comprises 30 questions, you are to answer all questions. If you do not know the answer to a given question, please select a random one and proceed to the next question.
For some questions you will need a data set, Please download it through this link. Go to file, click on download, and download as excel file.
You cannot pause this test once you begin. If you run into internet issues, we will not be liable for any inconveniences you incur. We advise you to use a good and steady internet service. You can run a speed test on FAST.COM to check the speed of your internet provider.
If you do not submit your test before the testing window eclipses, your test will be automatically submitted, and all unanswered questions will be marked 0.
Even though you are reading this now, you do not have to take this test right away if you’re unprepared. You will have access to this test up to Monday 17th July 2023.
Goodluck
0 of 30 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 30 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Suppose the P-value for a hypothesis test is 0.0304. Using a = 0.05, what is the appropriate conclusion?
Which two constraints apply to PRIMARY KEY?
What is Database Management System?
When do you use a t-value instead of a z-value?
A test is made of H0: μ = 50 versus Ha: μ =/= 50 is performed using α = 0.01 significance level. The value of the test statistic is z = -2.68 and it is concluded that we fail to reject H0.
If the true value of μ is 65, is the conclusion a Type I Error, Type II error, or a correct decision?
When p-value is greater than alpha we:
A test is made of Ho: μ = 17 versus Ha: μ < 17 is performed using α = 0.01 significance level. The value of the test statistic is z = -2.68 and it is concluded that Ho is rejected.
If the true value of μ is 10, is the conclusion a Type I Error, Type II error, or a correct decision?
A test is made of Ho: μ = 17 versus Ha: μ < 17 is performed using α = 0.01 significance level. The value of the test statistic is z = -2.68 and it is concluded that Ho is rejected.
If the true value of μ is 17, is the conclusion a Type I Error, Type II error, or a correct decision?
A test is made of Ho: μ = 50 versus Ha: μ =/= 50 is performed using α = 0.01 significance level. The value of the test statistic is z = -2.68 and it is concluded that we fail to reject Ho.
If the true value of μ is 50, is the conclusion a Type I Error, Type II error, or a correct decision?
An entity has set of ………… that describe it.
The Sum function is applied on numeric values by default in a pivot table. How can you change this so that the values are automatically counted and not summed?
SQL query to find all the cities from the weather table whose humidity is 52.
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be less than 20.
How many records would be returned by the following SQL Statement “SELECT * FROM songs WHERE TimesPlayed <=4”?
How many records would be returned by the following SQL Statement “SELECT * FROM songs WHERE Protected = ‘True’ AND TimesPlayed = 0”?
Answer Questions 16 to 30 using the dataset. Please download the dataset through this link: https://docs.google.com/spreadsheets/d/1QT-vfNWsvN10ZZottRhwZAeybjhE8yrx0HMYj2DKkiE/edit?usp=sharing
Go to file, click on download, and download as excel file.
N.B: Please do not remove any blanks in the dataset to get accurate results.
How many parents are divorced?
What is the standard deviation of the math scores?
What is the variance of the reading scores?
What is the range and the lowest value of the writing score respectively?
How many students had a writing score between 61-80?
How many students had math scores between 21-60?
How many Students practice sports regularly?
How many of the students are in the category of being a first child but never practice sport?
How many students scored 100 in reading?
How many students from ethnic group d completed their test preparation?
What is the percentage of the students from ethnic group a?
What percentage of male students are from ethnic group c?
What is the percentage of female students that go to school in school bus?
How many male students go with private transportation?