WorksheetsIvy Internship Assessment
Total questions: 45
Worksheet time: 26mins
A survey includes a question regarding marital status that has the following responses: single, married, divorced, separated, or widowed. What is the scale of measurement for this question?
Ratio
Interval
Ordinal
Nominal
To test if an individual βi coefficient in the population multiple regression model is significantly different from zero, a hypothesis test is conducted on the bi coefficient in the regression equation of the sample data. This test is a __________.
nonparametric test
z- test
t-test
F-test
What is the median of 22, 5, -7, 11, 2, 11?
7.3
11.0
8.0
10
Which of the following is an example of a continuous variable?
Time taken by a train to reach its destination
Zip codes of shoppers
Number of students in a statistics class
Tons of concrete to complete a parking garage
If we select 100 persons from 25,000 registered voters and question them about candidates and issues, the 100 persons are referred to as the __________
Population
Sample
Proportion
Statistic
Which of the following is an accurate definition of a Type I error?
Rejecting a true null hypothesis
Accepting a false null hypothesis
Accepting a true alternative hypothesis
Rejecting a false alternative hypothesis
Which of the following samples would have the smallest standard error?
n = 25 scores from a population with σ = 10
n = 25 scores from a population with σ = 20
n = 100 scores from a population with σ = 10
n = 100 scores from a population with σ = 20
What type of chart is useful for comparing parts of a whole?
Pie Chart
Line Chart
Column Chart
Dot Graph
What does COUNTA () function do?
Counts selected cells
Count cells having alphabets
Counts empty cells
Counts non-empty cells
Which of the following measures of central tendency will always change if a single value in the data changes?
Mean
Median
Mode
All of these
The numerator of the z-score test statistic measures _______
The average distance between sample mean M and population mean μ that would be expected if H0 was true
The actual distance between sample mean M and Popluation Mean μ
The position of the sample mean relative to the critical region
Whether or not there is a significant difference between sample mean M and population mean μ
You can check the conditions against _____________when applying conditional formatting
Formula
Cell Value
Both Formula and Cell value
None of the above
What type of chart will you use to compare performance of sales of two products ?
Column Chart
Line Chart
Pie Chart
Both Column and Line Charts
If a positively skewed distribution has a median of 50, which of the following two statements are true
Mean is greater than 50
Mean is less than 50
Mode is less than 50
Mode is greater than 50
In a Linear regression equation, the Ordinary Least Square (OLS) attempts to_________?
Pass through as many points as possible.
Pass through as few points as possible
Minimize the number of points it touches
Minimize the squared distance from the points
What is the relationship between significance level and confidence level?
Significance level = Confidence level
Significance level = 1- Confidence level
Significance level = 1/Confidence level
Significance level = sqrt (1 – Confidence level)
Which test is used for testing relationships between categorical variables?
Z- test
T-test
Chi-square Test
ANOVA
To return the remainder after a number is divided by a divisor in excel, we use the function:
ROUND()
MOD()
FACT()
None of the above
What is the shortcut key to insert current date in a cell?
Ctrl + ;
Ctrl + D
Ctrl + T
Ctrl + .
Long cells can be broken down into many lines within a cell. You can do this through?
Justify
Wrap Text
Merge
None of the above
Which of the following is correct syntax in Excel?
= IF ( Logical Test, True Result), IF (Logical Test, False Result)
= IF ( Logical Test, True Result), (Logical Test, False Result)
=IF ( Logical Test, True Result, False Result)
= IF ( Logical Test, (True Result, False Result))
Which of the following you can paste selectively using Paste special command?
Format
Validation
Formulas
All of the above
Is WHERE clause mandatory when using the SELECT command.
Yes
No
If the correlation coefficient (r) between scores in a math test and hours of study by a student is 0.60, what percentage of variability in math test is explained by the hours of study?
60%
36%
40%
64%
In Vlookup, the first argument is the ___________
Lookup value
Table array
Column Index
Range Lookup
How many arithmetic operators are there in excel?
6
5
4
3
A Fraud has taken place but the researcher accepted a null hypothesis stating that there is no fraud. What type of error is he making?
Type I error
Type II error
Both Type I and Type II errors
No error
The command used to delete a particular column from a table ____________
Update table
Truncate column
Alter, drop
Delete column
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot
And, Or, and Not are called __________ operator.
Comparison
Logical
Arithmetic
Connector
What is a composite key?
its is a key that is defined as the primary key in another table
is a key that uniquely identifies a record in a database
its is an optional key and allows null values
it is a primary key that consists of more than one field that uniquely identifies a record
What type of join is needed when you wish to include rows that do not have matching values?
Equi-Join
Natural Join
Outer Join
All of the above
Which of the following is not true about the COUNT function?
COUNT(*) returns the number of rows in the table
COUNT(exp) returns the number of rows with non-null values for the exp.
COUNT(DISTINCT exp) returns the number of unique, non-null values in the column.
All are true
Which data manipulation command is used to combines the records from one or more tables?
Select
Product
Join
Merge
Suppose cell B2 in a spreadsheet contains the formula:
=if(A1>100,"Bazinga","Zippo") If cell A1 contains the value 425, what value appears in cell B2?
Zippo
425
100
Bazinga
What is an advantage, if any, to using cell references instead of just typing in values?
It will automatically create a sparkline in the next cell
It will allow you to format your spreadsheet quicker
If the cell is changed, your formula will automatically update
There is no advantage
Is the below query correct?
SELECT custid, YEAR(ref_date) AS ref_year
FROM custmart
WHERE ref_year >= 2015;
YES
NO
Cannot Say
Which code snippet will alter the table LOCATIONS and add a column named Address, with datatype VARCHAR2(100)?
ALTER TABLE locations ADD (address varchar2(100));
ALTER TABLE locations ADD COLUMN(address varchar2(100));
MODIFY TABLE locations ADD COLUMN (address varchar2(100));
None of the above.
Which of the following query(s) will result in a successful insertion of a record in the STUDENT table?
Query1: INSERT INTO student (sid, name, login, age, gpa) VALUES (53888, ‘Drake’, ‘drake@cs’, 29, 3.5)
Query2: INSERT INTO student VALUES (53888, ‘Drake’, ‘drake@cs’, 29, 3.5)
Both queries will insert the records successfully
Query 1 will insert the record successfully and Query 2 will not
Query 2 will insert the record successfully and Query 1 will not
Both queries will not be able to insert the record successfully
Wildcards are___________
not supported by MySQL
Used to perform pattern matches
use characters such as $ to perform pattern matches
use characters such as % to perform single character matching
A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns..
Combines the output from multiple queries and does not include the same number of columns
Which of the following commands will run successfully?
SELECT 'customer name' FROM customers;
SELECT FROM `customers` 'customer name';
SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
SELECT customer name FROM customers WHERE cat_id = 12 ORDER BY cat_id;
Which command is used to permanently remove an existing table in a database?
DROP
REMOVE
DELETE
CUT
What is returned by MOD(1000,30)?
33
30
3
10
Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query
Uses the result of an outer query to determine the processing of an outer query.
