Week 9 Lab
docx
keyboard_arrow_up
School
Temple University *
*We aren’t endorsed by this school
Course
4501
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by JusticeSnowRook481
Lab 6-2 (Tableau track)
Lab 6-2 Objective Questions (LO 6-1, 6-3)
OQ1. Look at the Benford visual in the top-left corner of your dashboard. Which digit appears much greater than its expected value?
The leading digit 1 appears much greater than its expected value.
OQ2. Click the bar for the leading digit 4 to filter the transactions. What is the grand total of all transactions that begin with a 4 (rounded to the nearest dollar)?
The grand total is $2,071,610.
OQ3. Hover over the individuals in the Benford Average visualization (you could also create a new visualization to show the Benford average and Purchase Order count by user). What is the name of the individual with the smallest Benford Average who also has more than 10 transactions?
L Bybee.
OQ4. Hover over the individuals in the Benford Average visualization. What is the average Benford Expected value for the person (round to two decimal places) with the smallest Benford Average who also has more than 10 transactions?
It’s 0.08.
OQ5. Hover over the individuals in the Benford Average visualization. Click the bar for the first individual with more than 10 transactions to filter the dashboard. What digit do most of that individual's transactions begin with?
Digit 9.
Lab 6-2 Analysis Questions (LO 6-1, 6-3)
AQ1. What does calculating the Benford Average tell us about individuals?
It tells us if the dataset is regular or not and hence to see if it's fraudulent.
AQ2. What can we learn by looking at an individual's transactions through the lens of Benford's law?
We can learn that any data irregularities indicate fraud.
AQ3. As an auditor, why would we be concerned with a high volume of transactions that exceed the Benford Expected value?
It's because a high volume of transactions that exceed the Benford Expected value is likely to be fraud. That's why auditors need to apply other methods to identify it.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Lab 6-3 (Microsoft track)
Lab 6-3 Objective Questions (LO 6-1, 6-2)
OQl. How many duplicate records did you locate?
I located 2 duplicate records.
OQ2. What is (are) the invoice number(s) of the duplicate payments?
The invoice reference number is 4022595.
OQ3. How much money could the company recover from the supplier from these duplicate transactions?
$732.04.
OQ4. What data items do you need to combine to be able to find duplicate payments?
Payment ID, payment date, prepared by, payment amount and invoice reference.
Lab 6-3 Analysis Questions (LO 6-1, 6-2)
AQ1. Before computerization or Data Analytics, how would companies find that they had made duplicate payments?
Companies would look at each transaction one by one and manually find duplicates.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
AQ2. What data items do you need to be able to find duplicate payments?
Payment date, payment amount and invoice reference.
AQ3. Would the date of the duplicate payments usually be the same or different?
The dates of the duplicate payments are usually different.
Related Documents
Related Questions
Question 3
Listen
What are the values of r and r² for the below table of data?
Hint: Make sure your diagnostics are turned on. Enter the data into L1 and L2.
Click STAT, CALC, and choose option 8: Lin Reg(a+bx).
A
r = -0.862
r2=0.743
B
r=0.673
2=0.820
X
y
5
C
r=0.743
r2=-0.862
8
22
23.9
14
9
14
17
20
5.2
arrow_forward
Question Completion Status:
A Moving to another question will save this response.
Question 20
Analyzing the transactions using the accounting equation is the second step in processing transactions.
True
O False
A Moving to another question will save this response.
16
14
13
f2
195
f1
esc
5.
%23
4
2
Q
W
tab
31
arrow_forward
Please answer questions correctly
arrow_forward
Assignment:
In the space at the right, type the best formula (or function) needed to perform the following computations. The first one has been done for you
arrow_forward
Create a SQL table using your name with the following features:
the columns of your table must include, at least the data types (in this order) and one more of your choice
NOTE: You need to specify a 2 column (i.e 2 attribute
1. varchar (n), // where n covers the string length you want to enter
2. Int,
3. decimal, (precision = 8, scale = 3
4. date.
5. ??? your choice here ???
Table constraints:
1. It has a two column primary key
2. a check constraint on 2 columns, on the decimal and the date field
3. Use '2024-02-18' date as the default on the date field
5. write down your relational schema
5. Create the table, insert at least 4 rows, and do a Select * to show them
example don't just copy these, change the constraint names
arrow_forward
5. Which two talks last for the same amount of time?
Puzzler
0,888
ASTE
248:202
STEITE
Each letter has a number value. Use the code to name an item that matches
each of the descriptions below. Write the word and its value.
A = 1
H = 8
C = 3
D = 4
E = 5
F = 6
G = 7
J = 10
K = 11 L = 12
L= 12
M =
B = 2
1=9
O=15 P = 16 Q = 17 R = 18
Q=17 R= 18 | S = 19
V = 22 W = 23 X = 24 Y = 25
Y = 25 Z = 26
1. Animal with a sum between 20 and 30
2. Food with a sum between 50 and 75
3. Shape with a sum greater than 75
34
M = 13 N = 14
=
13 N = 14 T nidT
T= 20 U = 21
U = 21
og svi and 19al
# 9th forW 03.2
uny worl2
arrow_forward
red
Question 11
4) Listen
Use the graphs below to categorize the statements to describe either Graph A
or Graph B.
3
Graph A
Graph B
0
#12
"
3/2
2x
0
*/2
3/2
2
-1
T
graph a
graph b
Add an answer item!
Add an answer item!
Answer Bank
amplitude = 1
midline is y=3
f(x)= cos(x)+3
amplitude =3
f(x)=3sin(x)+1
midline is y=1
All Change
arrow_forward
F
ctions
Listen
A
Categorize the following statements as either true or false.
Press on an item in the answer box, and then press on the box under the corresponding
category. To remove an item, you can press on the box and the trash icon to the right of the
item you want to remove.
True
Add an answer item!
Answer Bank
False
Add an answer item!
12
5=
=80°
π=360°
플=900
3π
= 108°
5
sin20+cos20=tan20
sin 20+ cos20=1
arrow_forward
Subpart please
arrow_forward
how am i supposed to figure out the missing info?
arrow_forward
Question 2
Listen
Which linear regression equation matches the given data sets? Use your TI-84+
calculator to determine the equations.
Hint: Click STAT and chose option 1: EDIT. Enter your data into L1 (explanatory
variable) and L2 (response variable). Click STAT, choose CALC, and choose op-
tion 8.
Table A
x
y
X
Table B
y
0
7.5
0
6.8
1
7.7
1
5
2
8
2
7.5
3
8
3
7
4
8.5
4
9
Table C
Table D
X
y
X
y
0
11.2
0
15
1
7.7
1
77
2
8
NOT AN OPTION
3
4.5
3
6.5
4
4.6
4
3.2
ŷ=7.48+0.23x
a. Table B
ŷ-5.78+0.64x
b. Table C
y=10.48-1.64x
c. Table A
arrow_forward
#18 and #19. Details on pics
arrow_forward
The Elberta Fruit Farm of Ontario has always hired transient workers to pick its annual cherry crop. Janessa Wright, the farm
manager, just received information on a cherry picking machine that is being purchased by many fruit farms. The machine is a
motorized device that shakes the cherry tree, causing the cherries to fall onto plastic tarps that funnel the cherries into bins. Ms.
Wright has gathered the following information to decide whether a cherry picker would be a profitable investment for the Elberta
Fruit Farm:
a. Currently, the farm is paying an average of $250,000 per year to transient workers to pick the cherries.
b. The cherry picker would cost $540,000. It would be depreciated using the straight-line method and it would have no salvage
value at the end of its 5-year useful life.
c. Annual out-of-pocket costs associated with the cherry picker would be: cost of an operator and an assistant, $80,000
insurance, $4,000; fuel, $12,000, and a maintenance contract. $15,000.
Click…
arrow_forward
these multiple choice Questions from ACCOUNTING PRINCIPLES 1 Course.I need the final answer.
arrow_forward
Click on the "Prepare Fin Sts" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score.
Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas for all dollar amounts.
The formula must only contain cell addresses.
Each correct formula will begin with =, +, or -.
The basic mathematical operators are +, -, * and /
Addition: To add the values in cells A1 and B4, the formula is =A1+B4
Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4
Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4
Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4
THIS FILE REQUIRES THE USE OF =SUM FOR ALL TOTALS AND SUBTOTALS
The =SUM function adds all values…
arrow_forward
I need help with Questions #3 and #4, please.
Thank you
arrow_forward
omework E X
ezto.mheducation.com/ext/map/index.html?_con%3Dcon&external_browser%3D0&launchUrl=https%253A%252F%252Ffayted
User Management,..
https://outlook.off..
FES Protection Plan
lomework Exercises
Saved
Select whether each of the following acCcounts normally has a debit balance or a credit balance:
1. Cash
Debit
2. Blaine Brownell, Capital
Credit
9:36
3. Fees income
Credit
4. Accounts payable
Credit
5 Supplies
Debit
6. Equipment
Debit
7. Accounts receivable
Debit
8 Salaries expense
Debit
Address
arrow_forward
Typing clearly urjent
arrow_forward
please help with parts a,b, and c
arrow_forward
I need typing clear urjent no chatgpt used i will give 5 upvotes pls full explain
arrow_forward
This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J.
Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amounts
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
All answers must be entered as a formula only. Please reference the correct cell(s) or the cell(s) value.
arrow_forward
Please avoid solution image based thnx
arrow_forward
I need do fast typing clear urjent no chatgpt used i will give 5 upvotes pls full explain
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Question 3 Listen What are the values of r and r² for the below table of data? Hint: Make sure your diagnostics are turned on. Enter the data into L1 and L2. Click STAT, CALC, and choose option 8: Lin Reg(a+bx). A r = -0.862 r2=0.743 B r=0.673 2=0.820 X y 5 C r=0.743 r2=-0.862 8 22 23.9 14 9 14 17 20 5.2arrow_forwardQuestion Completion Status: A Moving to another question will save this response. Question 20 Analyzing the transactions using the accounting equation is the second step in processing transactions. True O False A Moving to another question will save this response. 16 14 13 f2 195 f1 esc 5. %23 4 2 Q W tab 31arrow_forwardPlease answer questions correctlyarrow_forward
- Assignment: In the space at the right, type the best formula (or function) needed to perform the following computations. The first one has been done for youarrow_forwardCreate a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint namesarrow_forward5. Which two talks last for the same amount of time? Puzzler 0,888 ASTE 248:202 STEITE Each letter has a number value. Use the code to name an item that matches each of the descriptions below. Write the word and its value. A = 1 H = 8 C = 3 D = 4 E = 5 F = 6 G = 7 J = 10 K = 11 L = 12 L= 12 M = B = 2 1=9 O=15 P = 16 Q = 17 R = 18 Q=17 R= 18 | S = 19 V = 22 W = 23 X = 24 Y = 25 Y = 25 Z = 26 1. Animal with a sum between 20 and 30 2. Food with a sum between 50 and 75 3. Shape with a sum greater than 75 34 M = 13 N = 14 = 13 N = 14 T nidT T= 20 U = 21 U = 21 og svi and 19al # 9th forW 03.2 uny worl2arrow_forward
- red Question 11 4) Listen Use the graphs below to categorize the statements to describe either Graph A or Graph B. 3 Graph A Graph B 0 #12 " 3/2 2x 0 */2 3/2 2 -1 T graph a graph b Add an answer item! Add an answer item! Answer Bank amplitude = 1 midline is y=3 f(x)= cos(x)+3 amplitude =3 f(x)=3sin(x)+1 midline is y=1 All Changearrow_forwardF ctions Listen A Categorize the following statements as either true or false. Press on an item in the answer box, and then press on the box under the corresponding category. To remove an item, you can press on the box and the trash icon to the right of the item you want to remove. True Add an answer item! Answer Bank False Add an answer item! 12 5= =80° π=360° 플=900 3π = 108° 5 sin20+cos20=tan20 sin 20+ cos20=1arrow_forwardSubpart pleasearrow_forward
- how am i supposed to figure out the missing info?arrow_forwardQuestion 2 Listen Which linear regression equation matches the given data sets? Use your TI-84+ calculator to determine the equations. Hint: Click STAT and chose option 1: EDIT. Enter your data into L1 (explanatory variable) and L2 (response variable). Click STAT, choose CALC, and choose op- tion 8. Table A x y X Table B y 0 7.5 0 6.8 1 7.7 1 5 2 8 2 7.5 3 8 3 7 4 8.5 4 9 Table C Table D X y X y 0 11.2 0 15 1 7.7 1 77 2 8 NOT AN OPTION 3 4.5 3 6.5 4 4.6 4 3.2 ŷ=7.48+0.23x a. Table B ŷ-5.78+0.64x b. Table C y=10.48-1.64x c. Table Aarrow_forward#18 and #19. Details on picsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning