IT Specialist : Data Analytics Practice Exam 1. What is the mean profit over the five-year period covered by the graph? A. 1.5 B. 1 C. 2.5 D. 1.7 2. Which statement is true about p-values? A. A p-value close to 1 reflects a greater relationship between two values. B. Smaller p-values provide greater evidence that the null hypothesis should be rejected. C. A p-value describes how much one variable impacts another. D. Large p-values reflect a significant difference between two groups. 3. Which two features are required to create successful machine learning systems? (Choose 2.) A. System scalability B. Adaptive algorithms C. Data aggregation D. Data disaggregation 4. For each statement about data, select Yes if it is true or No if it is false. A. A single payment for a service you purchased is raw data. Answer:YES B. Predictions based on a series of experiments are raw data. Answer:NO C. A summary of all responses received on a marketing survey is raw data. Answer:NO 5. You conduct a survey of 100 people regarding pet ownership. You want to perform statistics on this data. Move each aggregate function from the list on the left to the correct use on the right A. You want to know the number of pets that occurs most often. Answer:MODE. B. You want to know the average number of pets owned by each person, even if that value is a fraction. Answer:MEAN C. You want to know the number of pets owned by the 50th person if the people are ranked in order from the least number of pets owned to the most number of pets owned. Answer:MEDIAN 6. The development costs at your company have skyrocketed in the last year. It is suspected that most of the costs incurred come from contractors. You're given a set of data that contains all the hours worked by contractors over the last year. Which aggregate function should you use to determine the mean number of hours worked by contractors? A. SUM B. AVG C. MIN D. COUNT 7. You are provided this table of aggregated employment data about data analysts from different regions of the world. You need to determine when you should disaggregate this data. For each statement, select Yes if you should disaggregate the data or No if you should not. A. You want to know if the employment rate is proportional to students who went to colleges in high-income areas. Answer:YES B. You want to know if military training has a positive correlation with employment. Answer:NO C. You want to know whether there are more employed people in the Western USA than in the Eastern USA. Answer:NO 8. The example below shows a summary of monthly vacation rental information for one year. Rental Type Cabin Condo Cottage House Townhouse Grand Total Total Rental Income $36,750.00 $67,456.00 $27,597.00 $81,519.00 $12,032.00 $225,354.00 Which technique should you use to view cabin rentals by month? A. Data aggregation B. Data drilling C. Data correlation D. Data mining 9. A researcher believes that people who graduate from college make more money than those who do not. A professor points out that the researcher neglected to include statistics of high-paying professions that do not require a college degree. Which type of bias affected the researcher's study? A. Confirmation B. Selection C. Motivational D. Availability 10. Which two expressions save the year variable as the number 2024? (Choose 2.) A. year="2024' B. year=2000+24 C. year=2+0+2+4 D. year="2024" E. year=2024