3202 test 1
In one study, researchers find the following regression results: Hourly Earnings = 12 + 5*College_dummy + (-3)*Female_dummy + 1*Age, where Female_dummy = 1 if gender is female, and 0 otherwise (likewise for College_dummy). Joan is a 22-year-old female college graduate. John is a 22-year-old male college graduate. What is Joan's predicted earnings - John's predicted earnings?
-3
According to the normal distribution, ______ % of the data would fit within 1 standard deviation of the mean. 68 95 99 99.7
68
Which of the following is informative about the overall performance of the whole regression model? A. R square B. F C. coefficient D. p-value for coefficient
A, B
In Tableau, which type of chart is best described as useful for when quartiles, median, and outliers are required for analysis and insights? Box and Whisker plots Scatter plots Line chart Pie chart
Box and Whisker plots
Which investment option has the highest NPV? (Hint: calculation is not necessary to answer this question)
Check phone
Which of the following investment options has the highest IRR? (Hint: calculation is not necessary to answer this question)
Check phone
Predicting which companies are likely to be fraudulent/not fraudulent is an example of _____________ in predictive analytics. Classification Prediction Regression Time series analysis
Classification
Which of the following measures the relationship between two variables? Correlation Mean Range Standard deviation
Correlation
Which cash reconciling item could potentially affect either the bank statement or the general ledger? Error Interest earned on notes held by bank Outstanding deposit NSF checks
Error
Prescriptive analytics would be more likely to use these tools in its analysis than other types of analytics: Benford's law, box plot Goal-seek analysis, what-if analysis Totals, sums, averages and subtotals Forecasting tools, regression and classification
Goal-seek analysis, what-if analysis
If the data analyst hypothesizes that grocery sales are higher on Sunday than on other days, the null hypothesis would likely state that: Grocery sales are lower or no different on Sunday than on other days. Grocery sales are higher or no different on Sunday than on other days. Grocery sales are higher on Sunday than on other days.
Grocery sales are lower or no different on Sunday than on other days.
If I get p=0.5 from a Chi-square test: I cannot reject the null hypothesis because this p-value is larger than the threshold I should reject the null hypothesis because this p-value is smaller than the threshold I cannot reject the null hypothesis because this p-value is smaller than the threshold I should reject the null hypothesis because this p-value is larger than the threshold
I cannot reject the null hypothesis because this p-value is larger than the threshold
Which is most persistent in predicting future amounts of the variable based on current amounts of that same variable? Cash flows from operating activities Cash flows from investing activities Operating income Cash flows from financing activities
Operating income
Which would have a higher expected profit margin (per dollar of sales) than the others? Shaving cream Ice cream Bananas Real estate
Real estate
If p -value of a statistical test is 0.09 and the significance level is 10%, you should Accept the null hypothesis. Reject the null hypothesis. Reject the alternative hypothesis. Not reject the null hypothesis.
Reject the null hypothesis.
Which of the following is most likely to be the primary key of the "Transaction" table? Transaction ID Transaction Date Transaction Type Customer ID
Transaction ID
What type of question is learning how much the company paid in state taxes last year? What happened? What is happening? Why did it happen? What are the root causes of past results? Will it happen in the future? What is the probability something will happen? Is it forecastable? What should we do based on what we expect will happen?
What happened? What is happening?
The most appropriate data type for whether or not a product is eligible for prime shipping would be _____. number currency Y/N flag short text
Y/N flag
Which of the following statements regarding Tableau is true? Pie chart is better at representing numerical data than line chart in Tableau. You can change the underlying data in Tableau. You cannot display multiple charts simultaneously in Tableau. You can create time series forecasts with confidence bound in Tableau.
You can create time series forecasts with confidence bound in Tableau.
Albert Einstein's IQ is among the top 1% in the world. In other words, his IQ is: above the 99th percentile below the 1st percentile above the 1st percentile below the 99th percentile
above the 99th percentile
Benford's Law is a tool for which type of data analytics? predictive descriptive prescriptive diagnostic
diagnostic
To show the distribution of a continuous variable (e.g., household income), which chart should you use? histogram line chart pie chart bar chart
histogram
Which of the following features of data can lead to high veracity? make the data publicly available online increase the frequncy of data production invite external auditors to audit the data include both structured and unstructured data
invite external auditors to audit the data
What is the best measure of central tendency for nominal data (categorical data without inherent order)? median mode skewness mean
mode