Homework answers / question archive / ACC555 DATA ANALYTICS Practice Lab Problems Chapter-2 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-2 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

Accounting

Share With

---

ACC555 DATA ANALYTICS

Practice Lab Problems Chapter-2

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. 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 appropriate questions and develop a hypothesis for each question.

Part 2: Master your data and prepare it for analysis in Excel.

Part 3: Perform an analysis using PivotTables.

Part 4: Address and refine your results.

Part 5: Communicate your findings.

 

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

 

Software needed

• Excel
• Access
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data

• Sláinte dataset

2. After you have created your PivotTable, you should see columns for four months (January, February, March, and April), as well as a Grand Total field. Input the total quantity (sum) of each product sold from the Grand Total field below.

Item	Sum of Sales
Imperial IPA
Imperial Stout
IPA
Pale Ale
Stout
Wheat

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. 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:

• Extract data into a text editor and transform it into structured, ready-to-analyze data in Excel.

 

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

 

Software needed

• Text Editor (Windows: Notepad; Mac: TextEdit)
• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data Summary

 

The data used are a subset of the College Scorecard dataset that is provided by the U.S. Department of Education. These data provide federal financial aid and earnings information, insights into the performance of schools eligible to receive federal financial aid, and the outcomes of students at those schools. You can learn more about how the data are used and view the raw data yourself at https://collegescorecard.ed.gov/data/. However, for this lab, you should use the text file provided to you.

 

Data:

• CollegeScorecard Datasets: CollegeScorecard_RawData

 

Required:

1. By looking through the data in the text file, what do you think the delimiter is?

Multiple Choice

• Semicolon

• Comma

• Other

• Tab

• Space

 

Required information

Skip to question

 

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:

• Extract data into a text editor and transform it into structured, ready-to-analyze data in Excel.

 

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

 

Software needed

• Text Editor (Windows: Notepad; Mac: TextEdit)
• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data Summary

 

The data used are a subset of the College Scorecard dataset that is provided by the U.S. Department of Education. These data provide federal financial aid and earnings information, insights into the performance of schools eligible to receive federal financial aid, and the outcomes of students at those schools. You can learn more about how the data are used and view the raw data yourself at https://collegescorecard.ed.gov/data/. However, for this lab, you should use the text file provided to you.

 

Data:

• CollegeScorecard Datasets: CollegeScorecard_RawData

 

2. In the checksums, you validated that the average SAT score for all of the records is 1,059.07. When we work with the data more rigorously, several tests will require us to transform NULL values. If you were to transform the NULL SAT values into 0, what would happen to the average (would it stay the same, decrease, or increase)?

Multiple Choice

• The average would decrease

• The average would increase

• The average would stay the same

Required information

Skip to question

 

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:

• Extract data into a text editor and transform it into structured, ready-to-analyze data in Excel.

 

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

 

Software needed

• Text Editor (Windows: Notepad; Mac: TextEdit)
• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data Summary

 

The data used are a subset of the College Scorecard dataset that is provided by the U.S. Department of Education. These data provide federal financial aid and earnings information, insights into the performance of schools eligible to receive federal financial aid, and the outcomes of students at those schools. You can learn more about how the data are used and view the raw data yourself at https://collegescorecard.ed.gov/data/. However, for this lab, you should use the text file provided to you.

 

Data:

• CollegeScorecard Datasets: CollegeScorecard_RawData

 

3. How would that change to the average impact the way you would interpret the data?

Multiple Choice

• It would present a more accurate depiction of the average SAT across all schools

• It would inaccurately represent a very low SAT average across all schools

• It would have no impact

• It would inaccurately represent a very high SAT average across all schools

 

Required information

Skip to question

 

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:

• Create an ERD (entity-relationship diagram), which provides some quick information on the data that’s provided in the database. In one diagram, you can view all tables to see the entire database, or you can pick just the two you're working with to focus in on those attributes.

 

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

 

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)

 

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

Required:

1. Of the keys listed below, select the options that are primary keys for the TRANSACT and SKU tables. (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

• COLOR 
• CUST_ID 
• ITEM_ID 
• REGISTER 
• SKU 
• SKU_CLASS 
• SKU_SIZE 
• SKU_STYLE 
• STORE 
• TRAN_DATE 
• TRAN_TYPE 
• TRANSACTION_ID

 

Required information

Skip to question

 

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:

• Create an ERD (entity-relationship diagram), which provides some quick information on the data that’s provided in the database. In one diagram, you can view all tables to see the entire database, or you can pick just the two you're working with to focus in on those attributes.

 

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

 

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)

 

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

2. Which attribute should be connected in order to relate the SKU table to the TRANSACT table?

Connecting attribute

Required information

Skip to question

 

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:

• Learn how to access databases, run queries, and perform analyses in Excel.

 

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

 

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)
• Excel 2016 (available on the VMWare at the University of Arkansas)

 

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

Required:

1. Reference the PivotTable you created and identify which state had the highest number of stores. (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

• Arkansas
• Florida
• New York
• Texas
• Wyoming

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. 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:

• Learn how to access databases, run queries, and perform analyses in Excel.

 

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

 

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)
• Excel 2016 (available on the VMWare at the University of Arkansas)

 

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

2. Which states had the fewest number of stores? (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

• Arkansas
• Florida
• New York
• Texas
• Wyoming

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. 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:

• Learn how to access databases, run queries, and perform analyses in Excel.

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

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)
• Excel 2016 (available on the VMWare at the University of Arkansas)

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

3. Which attribute should be connected in order to relate the STORE table to the TRANSACT table?

Connecting attribute

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. 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:

• Learn how to access databases, run queries, and perform analyses in Excel.

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

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)
• Excel 2016 (available on the VMWare at the University of Arkansas)

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

 

rev: 08_17_2018_QC_CS-133851, 02_20_2020_QC_CS-201415, 06_19_2020_QC_CS-217106

 

4. Looking at the first several rows of data, compare the amounts in ORIG_PRICE, SALE_PRICE, TRAN_AMT. What do you think tran_amt represents?

Multiple Choice

• item price after discounts added

• Total transaction price after discounts added

• Total transaction price before discounts added

• item price before any discounts are added