Homework answers / question archive / 1

1

Statistics

Share With

---

1. __________ data would be considered the least sophisticated type of data.

2. __________ data would be considered the most sophisticated type of data

3. Line charts are not recommended for what type of data?

4. Exhibit 4-8 gives chart suggestions for what data you’d like to portray. Those options include all but the following

 

 

5. What is the most appropriate chart when showing a relationship between two variables (according to Exhibit 4-8)?

6. Refer to the graphic associated with the opening vignette regarding the 2016 presidential election. Indicate which of the following would be effective alternative presentations of the data to communicate voter outcome, and which would not be.

 

 

 

 

	Communication Alternative Effective? Frequency distribution of states based on the number of letters in each state's name   Box and whisker plot showing the margin difference   Scatterplot showing the relationship between expected margin and actual margin   Line graph showing the number of voters in each state   List of states in descending order of margin

7. Evaluate the graphic associated with the opening vignette regarding the 2016 Presidential election. Rank each of the following alternative options in order of effectiveness (1 - most effective, 5 - least effective) at communicating the margin of error in the polls.

 

	Communication Alternative Effectiveness Rank Box and whisker plot showing the margin difference   List of states in descending order of margin   Line graph showing the number of voters in each state   Scatterplot showing the relationship between expected margin and actual margin   Frequency distribution of states based on the number of letters in each state's name

 

8. Refer to Exhibit 4-8. Select the categories to identify the appropriate chart for changes in earnings per share over time.

 

1. Category:

 

2. Subcategory: 

 

9. Refer to Exhibit 4-8. Select the categories to identify the appropriate chart for the composition of the accounts receivable balance (e.g. types of customers with balances) at the end of the year.

 

Category:

Subcategory: 

10. In this lab, you will focus on communicating your findings from chapter 2, Lab 2-2.

 

Parts 1–4 of the IMPACT Model

Part 5: Communicate Your Findings

 

Refer to Chapter 4 pages 164 through 166 for instructions and steps for each of the lab parts.

 

Software needed

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

 

Data

• Sláinte dataset
   

Sum of Sales_Order_Quantity_Sold	Column Labels
Row Labels	April	February	January	March	Grand Total
Imperial IPA	17		23	2	42
Imperial Stout	36	27	61	42	166
IPA	34	35	36	66	171
Pale Ale	18	4	27	32	81
Stout	16	33	65	4	118
Wheat		11	21	54	86
Grand Total	121	110	233	200	664

 

 

	What quantity of Imperial Stout sold in December?   What was the grand total (of all beers) sold in April?   What quantity of Imperial IPA sold in December and January (combined)?   Which product sold the most in November?   Which products did not sell at all in February?   Which product(s) did not sell at all in April?

 

11. In this lab, you will:

 

Part 1: Identify appropriate questions.

Part 2: Complete the ETL process to load the data in Tableau for analysis.

Part 3: Analyze the data you receive with data visualization.

Part 4: Communicate the data you receive with a digital dashboard.

 

Refer to Chapter 4 pages 166 through 174 for instructions and steps for each of the lab parts.

 

Software needed

• Tableau. Visit with your instructor for instructions or follow this link to download Tableau, https://www.tableau.com/academic/students, and click Get Tableau for Free to register for a free student license. Your student license will last one year.
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 

Data

• Lab 4-2 Slainte Subset

After completing step 10 in part 3, Which Product_Code sold the most?

2004

After completing step 10 in part 3, How much did Product_Codes 2002 and 2004 sell, respectively?

 

 

 

 

After completing step 19, Which product(s) sold the most in 2019 and 2020?

 

 

 

 

 

 

(Hint: Steps 29 and 30) After completing steps 29 and 30, glance at the filled map to determine which three states appear to be the lowest performers in terms of total products sold?

 

 

 

By hovering over the states in the filled map, you can view the total products sold in each state. You can also add labels to the map, if you'd prefer. Input the number of products sold for each state.

 

	State Product Sold Arkansas   Iowa   Kansas   Louisiana   Missouri   Nebraska   Oklahoma   Tennessee   Texas

 

12. In this lab, you will:

• Learn how to prepare data visualization in Tableau.

 

Part 1: Identify the Questions

Part 2: Master the Data

Part 3: Perform an Analysis of the Data

Part 4: Address and Refine Results

 

Refer to Chapter 4 pages 175 through 186 for instructions and steps for each of the lab parts.

 

Software needed

• Microsoft SQL Server Management Studio and Microsoft Excel (available on the VMWare at the University of Arkansas)
• Tableau (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 by operating system. Contact your course instructor for the specific login credentials. The 2016 Dillard's data cover all transaction over the period 1/1/2014 to 10/17/2016.

After completing Lab parts 1 and 2, complete the following requirements.

 

Required:

1-a. Which state had the highest average transaction amount?

1-b. What is the average transaction amount in New York? (Either hover over the state to see the number, or turn on labels to view the amounts associated with each state). (Round your answer to 2 decimal places.)

 

 

13. After completing Lab parts 3 and 4, complete the following requirements.

 

Required:

2-a. Which City has the highest average transaction amount? (It can be easier to answer this question if you sort the data. Clicking the "sort" button will re-order the bars so that the city with the highest average transaction amount will be the first bar listed).

 

2-b. In the Deptcent "Childrens," which Deptdec is associated with the lowest average transaction amount?

 

 

2-c. What is the average transaction amount associated with Junior Dresses? (either hover over the bars to see the number, or turn on labels to view the average transaction associated with each bar). (Round your answer to 2 decimal places.)