Lab Exam 2

Question 1

Accept the null way 1

Answer 1

P value < 0.05

Question 2

Accept the null way 2

Answer 2

T stat < t critical

Question 3

Regression:
Y =
X =

Answer 3

Y = dependent

X = independent

Question 4

Dependent variable =

Answer 4

Intercept + independent variable coefficients*independent variable

Question 5

Benford =

Answer 5

LOG10(1+(1/first digit))

Question 6

Benford chart name

Answer 6

Reimbursement distribution

Question 7

Q1

Answer 7

Quartile.INC(…,1)

Question 8

IRQ

Answer 8

Q3 - Q1

Question 9

Upper bound =

Answer 9

Q3 + (IQR x 1.5)

Question 10

Lower bound =

Answer 10

Q1 + (IQR x 1.5)

Question 11

Bins steps:

Answer 11

Click on sales in data column
New group
Bin size: 20
New thing in data is created
X-axis: bins
Y-axis: sum of sales, change to count of sale (amount)

Question 12

Create a data table in powerBI

Answer 12

Go to table tab and create table
In text thing: date=calendar(date(2015,01,01), date(2020,12,31))
Mark as date table

Question 13

ROA =

Answer 13

Ratios(net income)/ratios(assets total)

Question 14

Gauge:
Value
Target Value

Answer 14

Value: actual value
Target value: sum of target value

Question 15

Mean =

Answer 15

Average

Question 16

To drill through to audit type to a table on pg 2

Answer 16

Put audit type to drill through fields
On pg 1 right click on bars in bar chart and click drill through

Question 17

Top customer + city in specific products

Answer 17

Clustered bar chart
Product + customer = y axis
Click arrow at bottom