Homework answers / question archive / ACC555 DATA ANALYTICS Practice Lab Problems Chapter-1 Required information In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question

ACC555 DATA ANALYTICS Practice Lab Problems Chapter-1 Required information In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question

Accounting

Share With

---

ACC555 DATA ANALYTICS

Practice Lab Problems Chapter-1

Required information

In this lab, you will:

Part 1: Identify appropriate questions, and develop a hypothesis for each question.

Part 2: Translate questions into target fields and value in a database.

Part 3: Perform a simple analysis.

 

Refer to Chapter 1 pages 28 through 30 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 3, complete the following requirements.

 

Software needed

• Word processor
• Web browser
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data

• Financial Statement Analysis (Google Sheets)

rev: 02_04_2019_QC_CS-154273

 

Required:

1. Select an appropriate hypothesized answer to the following question: "How has Apple Inc's gross margin changed in the past three years?".

Multiple Choice

• Apple Inc.'s revenues declined in the past three years.

• Apple Inc.'s new product has had a positive impact on sales.

• Apple Inc.'s gross margin increased by 3% in the past three years.

• Apple Inc.'s net income as a percentage of sales remained constant in the past three years.

Required information

Skip to question

 

In this lab, you will:

 

Part 1: Identify appropriate questions, and develop a hypothesis for each question.

Part 2: Translate questions into target fields and value in a database.

Part 3: Perform a simple analysis.

 

Refer to Chapter 1 pages 28 through 30 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 3, complete the following requirements.

 

Software needed

• Word processor
• Web browser
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data

• Financial Statement Analysis (Google Sheets)

rev: 02_04_2019_QC_CS-154273

2. Match data elements from the previous question to XBRL tags that would provide data to answer the question from Part 1. If the data element requires a calculation, choose "Expression"

Data Element	Correct XBRL Tag
CompanyName
GrossMargin
Sales Revenue
CostofGoodsSold
Change
Year

 

Required information

Skip to question

 

In this lab, you will:

 

Part 1: Identify appropriate questions and develop a hypothesis for each question.

Part 2: Translate questions into target fields and value in a database and perform a simple analysis.

 

Refer to Chapter 1 pages 33 through 34 for instructions and steps for each of the lab parts. After completing Lab parts 1 and 2, complete the following requirements.

 

Software needed

• Word processor
• Web browser
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Required:

1. Select an appropriate hypothesized answer to the following question: "Are there geographic patterns or anomalies regarding customers who make late payments?".

rev: 08_29_2018_QC_CS-135258

Multiple Choice

• Customers in some states have more payment plans than others.

• Some areas have customers with a longer employment history.

• Customers with late payments have high credit utilization.

• Customers with late payments are evenly geographically distributed.

 

Required information

Skip to question

 

In this lab, you will:

 

Part 1: Identify appropriate questions and develop a hypothesis for each question.

Part 2: Translate questions into target fields and value in a database and perform a simple analysis.

 

Refer to Chapter 1 pages 33 through 34 for instructions and steps for each of the lab parts. After completing Lab parts 1 and 2, complete the following requirements.

 

Software needed

• Word processor
• Web browser
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

2. Match data elements from the previous question to XBRL tags that would provide data to answer the question from Part 1. If the data element requires a calculation, choose "Expression"

Data Element	Correct XBRL Tag
Manager ID
Approval Date
Enter date
Number of Days