18 QUESTIONS. 1. 18 QUESTIONS Report. By (Name of Stude

8-12 page Analytics Report Data set is BRIDSTRIKES_DATA needs to be use teradata software to solve appendix 18 questions answers with screen sorts and explanation which is given in the end of assignments and also have to do all Task 1 to 6. report format should be same like given sample reports ApA style references must use peer reviewed 6 articles Go through report marking criteria

Running head: 18 QUESTIONS 1
18 QUESTIONS Report
By (Name of Student)
(Institutional Affiliation)
(Date of Submission)
(Code)

18 QUESTIONS 2
Question 2: How many different species (distinct) have been involved in bird strikes?
Question 3: Where the data has been recorded, what percentage of the time was the pilot
warned of birds or wildlife?

18 QUESTIONS 3
Question 4: What are the top five airline/operators involved in bird strikes?
Question 5: What proportion (percentage) of bird strikes involved medium and large
wildlife?

18 QUESTIONS 4
Question 6: In which phase of flight would the aircraft be most likely to experience a bird
strike?

18 QUESTIONS 5
Question 7: Has a bird strike ever occurred whilst the aircraft was parked? If so, in how
many instances?

18 QUESTIONS 6
Question 8: Is a bird strike more likely to happen when there is no cloud as compared with
overcast conditions?

18 QUESTIONS 7
Question 9: In what precipitation conditions is a bird strike most likely to happen?
Question 10: Which species of wildlife had the largest total cost? How much was this?

18 QUESTIONS 8
Question 11: For the most costly species of wildlife, which phase of flight was the most
common for a bird strike?

18 QUESTIONS 9
Question 12: For the species Bald Eagle and Canadian goose, examine the time of day that
bird strikes occur to see if there are any differences between the two species. Hint: you will
need to use a filter on the species of wildlife and also use two categories.
Question 13: Investigate using a crosstab for the data values Pilot warned of bird strike,
Altitude bin, and the total cost.
Question 14: Create a Geomap of the bird strike data.

18 QUESTIONS 10
Question 15: Using the sum of the number of records, investigate the bird strike count by
airport. Hint: remove any missing data and use a sort.

18 QUESTIONS 11
Question 16: Investigate the bird strike cost by airport. Hint: remove any missing data and
use a sort on the cost.

18 QUESTIONS 12
Question 17: Compare the answers of the two questions above. What does this indicate?

18 QUESTIONS 13
Question 18: Perform a cluster analysis on the two variables time out of service and total
cost. Use the cluster matrix graph to describe how the four clusters differ from one another
in terms of the two variables used.

18 QUESTIONS 14