Data Analytics for International Business Trailing Assessment

Assignment Task

Part A

Each multiple choice question is worth 1 mark. For each of these questions write down the letter matching the correct answer.

1. What is the price of the Curry Motors car with the largest engine size?

2. How many cars have a price between £10000 and £14000?

3. How many more 1993 cars are there than 1992 cars?

4. What is the average engine size of the Ford cars?

5. Which make of car has the lowest average price?

6. How many 1993 Ford cars are in insurance group 10?

7. What is the registration number of the 1992 car with the highest price?

Assume that the following additional charges are made when purchasing a car: £200 per insurance group unit. For example, for a car in insgrp 10 the insurance charge is £2000. 12% of the price of the car for a 4 year warranty. For example, for a car with the price of £8500, the warranty charge is £1020.

8. What is the total warranty charge for all cars?

9. Which car has a total cost (price + warranty charge + insurance charge) of £17432?

10. Create a pie chart to represent the price, insurance charge and warranty charge for the Volkswagon Scirocco GT 1.8 K347LCS.

Create a bar chart to represent the average warranty charges and insurance charges for Audi, BMW and Ford.

Write down a formula that when placed in cell N2 could be autofilled down column N of the

CarsForSale sheet and would display the message Engine Size Less Than 2 if the engine size is less than 2. If not, the message should be Engine Size At Least 2.

13. Write down a formula that when placed in cell O2 could be autofilled down column O of the CarsForSale sheet, to present the difference between the price of each car and the maximum price of all cars.

Part B

For these questions you may use the Access database. For each of these questions you are required to write an SQL query that results in the information stated in the question.

14. Display all of the employee details for employees with manager number 875.

15. Display the employee name and job for the employees who earn at least £21000 and whose job is sales.

16. Display the salary of each employee decreased by 20%. Name the column

17. Display each department number and the average salary for each department number.

18. Display the employee name and salary for each employee in a single column. These should be presented as in the following example for employee MARCH:

19. Display all the employee details of the employees whose salary is greater than the average salary.

20. Display the employee names of all employees who work in department number 2 and earn the maximum salary of those who work in department number 2.

This International Business has been solved by our PhD Experts at My Uni Paper.