Slavic Data File: https://www.limes.one/Content/DataFiles/Slavic.txt

Question:Open File:Slavicdata. Use only company 6354 from state Alabama (symbol AL). Need to make a scatter plot chart where X-axis is401KContributionand Y-axis isPayCheck.

1. What is the maximum 401KContribution?

• a. 950
• b. 9600
• c. 800
• d. 1200

2. There is a cluster of "dots" whose X values are less than 200. Among these dots there are few standing out with highest Y-axis value. What is this value?

• a. 5500
• b. 6500
• c. 8500
• d. 10500

3. The chart has one isolated point in LOWER RIGHT CORNER. What are the approximate (X & Y) coordinates of this point?

• a. 900 & 4000
• b. 600 & 5000
• c. 500 & 8000
• d. 700 & 10000

Sort the data (from smallest to largest) from:Slavic, by two keys, by CompanyID and EmployeeId. Answer questions.

4. After this sorting, what are the numbers in cells A22?

• a. 1374445
• b. 1370602
• c. 1368500
• d. None of these

5. After sorting, use data from Company with ID=71, need to make a scatter plot chart where X-axis is 401KContribution while Y-axis is Matching. Statement: Dots on the left side of the chart lie approximately on a straight line.

• a. True
• b. False

6. For the same chart. Statement: Dots on the right side of the chart follow almost perfect line.

• a. True
• b. False

7. On this same chart the dot with highest Y-axis has also highest X-axis value.

• a. True
• b. False

Customer Data File: https://www.limes.one/Content/DataFiles/Fliers_Customers.txt

Open File:Fliers Customersdata. Produce the scatter plot chart in which X-axis is the number of Fliers and Y-axis is the number of customers.

8. Two dots on the left have what approximate y-axis values?

• a. 250
• b. 350
• c. 450
• d. 550

9. What is the approximate average for X-axis?

• a. 200
• b. 400
• c. 600
• d. 100

10. What is the approximate X-axis for a dot with highest Y-axis?

• a. 500
• b. 550
• c. 600
• d. 650
• e. 700

Slavic Data File: https://www.limes.one/Content/DataFiles/Slavic.txt

OpenSlavicdata and use the appropriate sorting (as well as Average and StDev functions) in order to answer the following questions: Hint: to compute an average of an array, just type: =Average(Array)and highlight the desired array of data. Similarly, to compute Standard Deviation just type: =StDev(Array)

Answer questions 11 and 12.Extra credit 10% each.

11. What is the average salary for employee with ID number = 797976. (Pick the closest answer)

• a. 1150
• b. 1200
• c. 1090
• d. 2000

12. What is the Standard deviation for the salary for employee with ID number = 797976. (Pick the closest answer)

• a. 36
• b. 34
• c. 44