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.

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?".

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"

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

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"