Download Descriptive, Predictive, and Prescriptive Analytics and more Exams Computer Science in PDF only on Docsity!
WPC 300 Final Exam perform business discovery In an agile approach of analytics what is the first step of the process? data warehouse In an ETL process, data is loaded into a final target database such as: prescriptive analytics Which of the following data analysis models use optimization techniques? Prescriptive Analytics 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. descriptive analytics Target is examining their online sales data during the pandemic to understand what happened. Which kind of analytical technique are they using? predictive analytics Costco wants to know how to stock their warehouses for a future pandemic and are using current sales data to help them project the needs. Which kind of analytical technique are they using? prescriptive analytics Your professor is considering purchasing a self-driving car that can figure out the best route and the optimum safe way to drive there without human intervention. What kind of analytics is the car using to do this? Who will win the NBA championship? How many students will enroll for an online class in the Spring? What is the purchase pattern(s) of our customers? Which of the following question(s) can be better answered using data in order to reach an evidence- based conclusion? Data ink can sometimes help tell a richer story Which of the following statement(s) about charts is true? The data-ink ratio should be higher than 1 Which of the following violates the principle of data visualization?
close to 1 In for a chart to minimize graphical complexity, the data-ink ratio must be: Tables cannot easily show trends Which of the following statements is a reason not to use a table for data visualization? the size of the effect shown in the graph is bigger than the actual effect in the data. When the lie-factor of a graphical chart is more than 1, Increases the data-ink ratio Deleting the grid lines in a chart Plots data using a circular historical plot What best describes the nature of a rose diagram? close to 1 In order for a chart to have graphical integrity, the lie factor must be: Which of the following statement(s) about charts is true? A chart should have graphical integrity A chart should minimize graphical complexity A chart should tell a story The graph suggests a possible true effect Which are useful principles for data visualization? distribution of the sample mean will still be normal when the sample size is large The central limit theorem states that even if the population is not normally distributed, the The null hypothesis is actually true, but the hypothesis test incorrectly rejects it. Which of the following is a Type-I error? Confidence interval decreases When sample size increases Null hypothesis Which of the following proposition describes an existing theory or belief?
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.36x. If a car is driven 15000 miles in a year, the model predicts the annual cost of the car to be: 81% of the variation in the money spent on repairs is explained by the age of the vehicle The correlation coefficient between the age of a vehicle and the money spent to repair it is 0.9. Which of the following statement is true? Residual variance The unexplained variance in the regression analysis is also known as: A correlation coefficient between "college entrance exam" grades and scholastic achievement was found to be -1.08. On the basis of this, you would tell the university that: They should hire a new statistician. There is no linear relationship between profit and sales. What would be the null hypothesis for testing a linear regression model with profit as the dependent variable and sales as the independent variable? It is measured using a measure called variance inflation factor (VIF). Which of the following is true about multi-collinearity? 0 and 1 The value of R-Squared always falls between ________ and ________, inclusive. Logit In logistic regression analysis, instead of Y as a dependent variable, we use a function of Y called ________. Log (p/1-p) In logistic regression, the dependent variable y is defined as: Multiple logistic regression If you want to find out if body weight, calorie intake, fat intake and age have an influence on the probability of having a heart attack (yes or no), which of the following kind of analysis will help determine the answer? p/1-p Odds ratio is defined as ________, where p is the probability of success.
Confusion matrix The ________ is often used to describe the performance of a classification model applied to a set of test data for which the true outcomes are known. Training and validation/testing In classification analysis, we typically split the data into two mutually exclusive sets, known as ________, to investigate the strength of the developed model. a binary categorical Logistic regression is a specialized type of regression analysis that is designed to predict ________ variables. Confusion matrix In classification problems, the primary source for accuracy estimation of the model is ________. By utilizing a multiple logistic regression model developed by an in-house analyst A loan officer wants to know if the next customer is likely to default or not on a loan. How can she assess the risk of extending the loan to that customer? To be part of a certain class or not In classification analysis, we are determining the probability of an observation ________. To predict sales from transactional data one should perform clustering analysis. Which of the following is a false statement? Supervised Which of the following category of data mining you would use for Spam filtering of emails? The distance between the most distant pair of objects, one from each group Which of the following is a definition of distance between two clusters in a complete linkage clustering? Data is not labeled for supervised analysis Which of the following statements below is false about supervised/unsupervised data analysis? Crime prediction analysis Which of the following is not an application of clustering analysis? By joining two clusters that are closest to each other
When you are asked to design a database for the airline ticket reservation system, based on an Entity- Relationship Data model, which of the following could be an example of "entity"? Provides support such as performing maintenance and routine backups. Which of the following is an important task of a database management system? airport code 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? data splitting and aggregation Data transformation involves Encrypting Which of the following is not one of the processes involved in data cleaning? specified source database Extract function in ETL reads data from Data warehouse In loading phase of an ETL tool, the transformed data gets loaded into an end target usually the _______. Competitions' data In data extraction process for an ETL tool, which of the following is not an example of legit data source? Data extraction from ERP Which of the following is not a standard practice in "Data Transformation" process of an ETL tool? Load The final stage of an ETL process is: data quality Which of the following is not a requirement for an ETL architecture? Teradata Which of the following is an ETL vendor? load
One of the processes in ETL is Increase more sales Increase more clicks to their website Increase more likes to their social media sites A/B testing can help marketers to to develop a test plan for what you want to test. The first step for any kind of A/B testing is to estimate the parameters of the population. A sample study is mostly done neither the subject nor those working with the subject is aware of who is being given which treatment An experiment is said to be double-blinded if _________ experimental units In the experimental design example "IQ Water", students are called _______. money Regular consumption of organic food will keep you in a good mood. In this example, the confounder could be To increase conversion rate of your website traffic, A/B testing can be beneficial. Which of the following is true about A/B testing? It is not easy to control uncertainties in the comparison.. Which of the following statements is NOT true about experimental studies to compare two treatments? spurious correlation A _______________ is a relationship between two variables that appear to have interdependence or association with each other but actually do not. Observational Study After factoring out the effect of other variables known to affect SAT, such as socioeconomic status, researchers found that music students had a higher SAT score than non-music students. This is an example of __________. Anchoring bias
