Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / ACC555 Data Analytics Practice Lab Problems-Chapter 6 Problem 1: Required information NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document
ACC555 Data Analytics
Practice Lab Problems-Chapter 6
Problem 1:
NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.
In this lab, you will:
Part 1: Identify the questions.
Part 2: Master the purchase order and payment data.
Part 3: Perform the analysis.
Refer to Chapter 6 pages 235 through 240 for instructions and steps for each of the lab parts.
Software needed
Data
After completing Lab Part 1, answer the following questions.
1. What data do you need to calculate the account balances? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)
check all that apply
2. What is the formula needed to compute the balance in accounts receivable? Fill in the blanks shown below.
Problem 2:
Upload the Word or PDF document containing your Lab screenshots using the button below.
Problem 3:
NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.
In this lab, you will:
Part 1: Identify the questions.
Part 2: Master the purchase order and payment data.
Part 3: Perform the analysis.
Refer to Chapter 6 pages 240 through 241 for instructions and steps for each of the lab parts.
Software needed
Data
Lab 6 Current Audit Files - If you have already downloaded these files from Lab 5-1, you do not need to download again.
After completing Lab Part 1, answer the following question.
Before computerization or data analytics, how would companies find that they had made duplicate payments? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)
check all that apply
Problem 4:
After completing Lab Part 2, answer the following question.
What data items do you need to be able to find duplicate payments? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)
check all that apply
Problem 5:
After completing Lab Part 3, answer the following question.
1. How many duplicate records did you locate?
2. What course(s) of action would you recommend? Select all choices that apply. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)
check all that apply
Problem 6:
Upload the Word or PDF document containing your Lab screenshots using the button below.
Problem 7:
NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.
In this lab, you will:
Test a hypothesis in Excel. Specifically, we will see if the returns in January are greater than the rest of the year.
Part 1: Identify the Questions
Part 2: Master the Data
Part 3: Perform an Analysis of the Data
Part 4: Address and Refine the Results
Part 5: Communicate Insights and Track Outcomes
Refer to Chapter 6 pages 241 through 247 for instructions and steps for each of the lab parts.
Software needed
Data
The data for this lab and all other Dillard's labs must be accessed through the University of Arkansas Remote Desktop. Documentation on how to connect and log in to the remote desktop can be found below and on the Additional Student Resources page.
Once you have a remote access account, you can log in to access the University of Arkansas server using any web browser. Instructions for logging in can be found below:
Logging into UARK Remote Desktop - VMWare
Accessing the Dillard’s dataset in Excel
After completing Lab Part 4, answer the following questions.
1. Using the p-values (or the t-statistic and critical values), answer the questions presented in the statement below.
The p-value for the january is -----------the rest of the year, so returns as a percentage of sales for january are --------the returns as a percent of sales for the rest of the year. (options were higher, lesser, greater, lower, same as)
Problem 8:
Upload the Word or PDF document containing your Lab screenshots using the button below.
Note: Problem 2, 8 are not answered in this document.
Already member? Sign In
