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-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
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
Data
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 |
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:
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
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:
Required:
1. By looking through the data in the text file, what do you think the delimiter is?
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:
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
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:
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)?
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:
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
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:
3. How would that change to the average impact the way you would interpret the data?
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:
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
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
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:
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
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 |
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:
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
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
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:
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
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
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:
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
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
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:
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
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?
Already member? Sign In
