WPC 300 QUIZZES TOGETHER
A manager wishes to predict the annual cost (y) of an automobile based on the number of miles (x) driven. The following model was developed: y = $1500 + 0.6x. If a car is driven 15000 miles, the predicted cost of the car is: $7400 $10500 $13850 $6900
$10500
he value of R-Squared always falls between ___________ and ___________ inclusive. 0 and -1 0 and 1 -infinity to + infinity -1 and +1
0 and 1
What is the confidence interval when the level of significance is 0.06? 7% 0.093 0.930 0.940
0.940
The WPC Sports Company has noted that the size of individual "customer order" is normally distributed with a mean of $100 and a standard deviation of $10. If a soccer team of 25 players was to make the next batch of orders, what would be the standard error of the mean? 3.46 2.00 3.00 10.00
2.00 (sigma/sqrt(n) = 10/sqrt(25) = 2)
The correlation coefficient between the age of an auto and the money spent to repair is 0.8. Which of the following statement is true? 81% of money spent on repairs is explained by the age of an auto 90% of the repair cost will be explained by the age of an auto 81% of the variation in the money spent on repairs is explained by the age of the auto 64% of the variation in the money spent on repairs is explained by the age of the auto
64% of the variation in the money spent on repairs is explained by the age of the auto Feedback: R=0.8, R-squared = 0.64. Remember the definition of R-squared.
Gamblers' fallacy is ______________ Framing effect bias A Zero risk bias A clustering illusion An endowment effect bias
A clustering illusion
A market analyst is developing a regression model to predict monthly household expenditures on groceries as a function of family size, household income, and household neighborhood (urban, suburban, and rural). The "household expenditure" variable in this model is ________. A dependent variable A qualitative variable A continuous variable An independent variable
A dependent variable
Which of the following statement is true based on the following regression equation?IQ = 4.0 + Reading Label * 9.6 A unit point change in IQ will result in 5.6 point increase in reading label A unit point change in reading label will increase IQ by 5.6 point A unit point change in reading label will result in 9.6 point increase in IQ level. Reading label is not a good predictor of IQ
A unit point change in reading label will result in 9.6 point increase in IQ level.
In an ETL process, data is loaded into a final target database such as: Operational dashboard Public database Social media database Data warehouse
Data warehouse
In loading phase of an ETL tool, the transformed data gets loaded into an end target usually the ____________. Master data management Online analytical processing Data warehouse Data Mart
Data warehouse
Deleting the grid lines in a chart Decreases the lie-factor Increases the data-ink ratio Decreases the data-ink ratio Increases the lie-factor
Decreases the data-ink ratio
What are the four types of data analytical method? Descriptive, logical, predictive and prescriptive Descriptive, explanatory, predictive and prescriptive Critical, analytical, predictive and explanatory Descriptive, analytical, predictive and prescriptive
Descriptive, explanatory, predictive and prescriptive
________ refers to a bias that causes an individual to value an owned object higher than its market value. Bandwagon effect Clustering illusion Endowment effect Anchoring bias
Endowment effect
In an agile approach of analytics, what is the last step of the process? Model data Score and deploy Perform business discovery Evaluate and Improve
Evaluate and Improve
Which of the following statements is true? Experimentation is a way of analytical thinking Heuristic thinking is slow Using intuition is a way of analytical thinking Analytical thinking is not based on facts
Experimentation is a way of analytical thinking
When you access information from two different tables connected by an identifier key, the SQL keyword you should use is ____________. COUNT INNER JOIN ORDER BY GROUP BY
INNER JOIN
Which of the following is an example of primary data? Firm's proprietary data Data collected through censuses Interviews data Internet searchers
Interviews data
Which of the following is true about multi-collinearity? Is measured using the statistical variance inflation factor (VIF) Regression coefficients become clearer and are easier to interpret The effect of a dependent variable on another becomes difficult to isolate. P-value reduces significantly leading to rejection of the null hypothesis.
Is measured using the statistical variance inflation factor (VIF)
You need to find out if a customer will buy your product or not. An appropriate sample data is available from your current customer base. Which of the following analysis method will be appropriate for this study? Linear regression Multiple linear regression Logistic regression Clustering
Logistic regression
Which of the following is true focus of Information Architecture? Deliver information to the client where there is a misunderstanding Make the information hard to find Make only irrelevant information easy to find Making all information easy to find
Making all information easy to find
Visualization of spatial data are most illustrative when shown using Bubble graphs Maps Line graphs Bar graph
Maps
Kurtosis of a normal data distribution is a ___________________ Measure of data dispersion Measure of data quality Measure of data centrality Measure of data shape
Measure of data shape
Regular consumptions of organic food will keep you in a good mood. In this example, the confounder could be people's mood work ethics Money organic food
Money
Which of the following assumptions is not true for simple linear regression? Correlations between the dependent and independent variables Residuals are normally distributed Multicollinearity effect between independent variabels Relationship between dependent and independent variable should be linear
Multicollinearity effect between independent variabels
The numbers on the basketball jersey is an example of Ordinal data Interval data Ratio data Nominal data
Nominal data
The average value of nominal data is measured by None of the other answers is true Median Mode Mean
None of the other answers is true
Which of the following proposition describes an existing theory or belief? Standard deviation Null hypothesis Proportion Alternative hypothesis
Null hypothesis
Which of the following tools help in periodic managerial decision-making? OLTP OLAP Database Servers
OLAP
Predictive analytics may be applied to_______________, which is a set of techniques that use descriptive data and forecasts to identify the decisions most likely to result in the best performance. Prescriptive analytics Forecast analytics Explanatory analytics Descriptive analytics
Prescriptive analytics
Which of the following data analytics model use optimization techniques? Diagnostic analytics Prescriptive analytics Predictive analytics Descriptive analytics
Prescriptive analytics
Which of the following is an important task of a database management system? Helps collect data from vendors Helps create rules for data analysis Provides support such as performing maintenance and routine backups. Provides unauthorized access to data when authentication fails
Provides support such as performing maintenance and routine backups.
The unexplained variance in the regression analysis is also known as: Regression variance Residual variance Total variance Predicted variance
Residual variance
The SQL code to extract only departure time information for all records of the following "Flight" table is: SELECT Departs FROM Flight; SELECT * FROM Flight; SELECT * FROM Flight WHERE To = "LGA (New York City)"; SELECT Flight # FROM Departs;
SELECT Departs FROM Flight;
The central limit theorem states that if the population is normally distributed, then the Sampling distribution of the mean will also be normal for any sample size Standard error of the mean will not vary from the population mean Mean of the population can be calculated without using samples Sampling distribution of the mean will vary from the sample to sample
Sampling distribution of the mean will also be normal for any sample size
Which of the following steps is not used in the k-means clustering algorithm? Assign each data point to some cluster. Choose the number of clusters K. Select cluster centers in such a way that they are as closest as possible from each other. Calculate the distance between each data point and each cluster center
Select cluster centers in such a way that they are as closest as possible from each other.
Florence Nightingale's rose diagram tells a story about Interests of national debt during the war Soldier's cause of mortality in the hospital during the work Cause of cholera outbreak Napoleon's invasion to Russia
Soldier's cause of mortality in the hospital during the work
When you keep eating the food you don't like precisely because you already bought the food, you are committing _______________ Endowment effect bias Sunk-cost fallacy Zero risk bias Availability heuristics bias
Sunk-cost fallacy
Which of the following category of data mining you would use for Spam filtering of emails? Supervised Unsupervised Heuristics Both supervised and unsupervised
Supervised
Which of the following statements is a reason not to use a table for data visualization? Large amount of information can be included in a very small space Tables cannot easily show trends The table has more precise numbers Tables display more information in less space than a chart
Tables cannot easily show trends
What are the three principles of describing numeric data? Centrality, dispersion and size Mean, median and mode Dispersion, range and standard deviation center, spread and shape
center, spread and shape
In inferential statistics, a _____________ is used to infer about a ______________. sample, population Population, significance Population, sample Sample, significance
sample, population
You are creating a database to store temperature and wind data from various airport. Which of the following fields is the most likely candidate to use as the basis for a Primary Key in the Airport Table? Airport code Address State City
Airport code
In order to reject the null hypothesis, the p-value must be less than the Standard deviation Variance Degrees of freedom Alpha
Alpha
A researcher wants to find out if a lack of exercise leads to weight gain. Which of the following variables could not be considered as confounder? Both "Exercise level" and "Wight" Weight Age Exercise level
Both "Exercise level" and "Wight"
Which of the following the first stage of agglomerative hierarchical clustering? By separating cluster into two finer groups By joining two clusters farthest away from each other By joining two clusters that not at a Euclidean distance By joining two clusters that are closest to each other
By joining two clusters that are closest to each other
When sample size increases Confidence interval remains the same Confidence interval increases Confidence interval decreases Standard deviation of the sample mean increases
Confidence interval decreases
Which of the following is not an application of clustering analysis? Web click stream analysis Market segmentation analysis Collaborating filtering analysis Crime prediction analysis
Crime prediction analysis
Which of the following is not a component of relational database? Relationship among rows in tables CPU of Database Server Metadata Tables
CPU of Database Server
When two variables are highly negatively correlated, the correlation coefficient will be ______________ Close to 0 Close to 1 Close to 10 Close to -1
Close to -1
In data extraction process for an ETL tool, which of the following is not an example of legit data source? Customers' social media data Competitions' data Online Line Transaction data Point of Sales data
Competitions' data
In the target story discussed in the lecture, why did Target send the teen daughter maternity ads? Target analytic model confused her with an older woman with a similar name Target was using special promotion that targeted all teens in her geographical area Target analytics model suggested she was pregnant based on her buying habit Target was sending ads to all women in a particular neighborhood
Target analytics model suggested she was pregnant based on her buying habit
Which of the following basic data visualization principles violated for the graph shown below? All three principles of data visualization violated. The chart should minimize graphical complexity The chart should tell a story The chart should have a graphical integrity
The chart should have a graphical integrity Keep the axis same to maintain graphical integrity.
Which of the following is true of hierarchical clustering? The data partition does not occur in a single step All clusters must have more than one object in it No single cluster can have all data All clusters must have the same number of data
The data partition does not occur in a single step
Which of the following violates the principle of data visualization? The chart should tell a story Avoid unnecessary chart junk The lie-factor should be closely equal to 1 The data-ink ratio should be higher than 1
The data-ink ratio should be higher than 1
Which of the following is a definition of distance between two clusters in a single linkage clustering? The average of distance between all pairs of objects, where each pair is made up of one object from each group The distance between the least distant pair of objects, one from each group The distance between the most distant pair of objects, one from each group The sum of square of the distance between clusters
The distance between the least distant pair of objects, one from each group
Which are useful principles for data visualization? The graph suggests a possible true effect The use of a wide range of colors is critical to emphasize distinctions Including as many grids as possible is vital for fully specifying the data to be represented It is important to include pointed arrows whenever possible to really draw attention to the eyes
The graph suggests a possible true effect
You arrived at a significant test statistic (p-value < 0.05) when comparing responses from three treatment groups in a one-way ANOVA. How would you interpret the alternative hypothesis for this test? None of the other answers is true The mean response from at least one treatment group is different from that of the others The mean responses from all three treatment groups are different The mean responses from all three treatment groups are the same
The mean response from at least one treatment group is different from that of the others
Which of the following is not a continuous random variable? The outcomes of rolling two dice The pollution level (measured in air quality index) in the air around us The time to complete a specific task The possible amount of rain on a given day
The outcomes of rolling two dice
Which of the following is a Type-II error? The research hypothesis is actually true, but the test correctly rejects the null hypothesis. The research hypothesis is actually true, and the test incorrectly fails to rejects null hypothesis The null hypothesis is actually true, but the hypothesis test incorrectly rejects it. The null hypothesis is actually true, and the hypothesis test correctly fails to reject it.
The research hypothesis is actually true, and the test incorrectly fails to rejects null hypothesis
When the lie-factor of a graphical chart is more than 1, The graph understates the true effect The graph suggests a possible true effect The size of the effect shown in the graph is bigger than the actual effect in the data. The graph simplifies the true effect
The size of the effect shown in the graph is bigger than the actual effect in the data
Which of the following is a difference between the t-distribution and the standard normal (z) distribution? The t-distribution cannot be calculated without a known standard deviation, while the standard normal distribution can be. The t-distribution has a larger variance than the standard normal distribution The standard normal distributions' confidence levels are wider than those of the t-distribution The standard normal distribution is dependent on parameters like degree of freedom, while t-distribution is not.
The t-distribution has a larger variance than the standard normal distribution
A correlation coefficient between the "college entrance exam" grades and "scholastic achievement" was found to be 1.08. On the basis of this, you would tell the university that: The entrance exam is a good predictor of success. Students who do best on this exam will make the worst students. The exam is a poor predictor of success. They should hire a new statistician.
They should hire a new statistician. Feedback: -1< r<1
Which of the following is true about A/B testing? To increase conversion rate of your website traffic, A/B testing can be beneficial. You should test multiple elements of your landing page at a time and compare You need to attend WPC 300 course to learn about A/B Testing A neutral result on an A/B testing means you correctly performed the test
To increase conversion rate of your website traffic, A/B testing can be beneficial.
Which of the following is not a true statement? Reducing SSE (sum of squared error) within cluster increases cohesion In the cluster analysis, the objects within clusters should exhibit an high amount of similarity The k-means algorithm is a method for doing partitional clustering To predict sales from transactional data one should perform clustering analysis.
To predict sales from transactional data one should perform clustering analysis.
When are asked to design a database for airline ticket reservation system, based on an Entity Relationship Data model, which of the following could be an example of "entity"? Flight Number Arrival time Destination city Traveler
Traveler
In the experimental design (discussed in the lecture videos) to test the efficacy of "IQ Water", the "IQ water" is called Response variable Treatments Experimental units Measurement units
Treatments
In confirmatory visualization Users expect to see a certain pattern in the data Users typically look for anomaly in the data Users don't know what they are looking for Users confirm the quality of data visualization
Users expect to see a certain pattern in the data
Which of the following is a cloud service provider? Dropbox VMWare Gmail iCloud
VMWare
Which of the following is not a traditional data architectural process? Conceptual Logical Physical Visual
Visual
Do a quick google search and find out about other data visualization tools. Which of the following is not a data visualization tool? Domo Weka Sisense Qlik
Weka
