business analytics statistics question

by

All work must be shown to qualify for partial credit. Each answer must provide a managerial explanation of the outcomes.

Please include the excel spreadsheet with the work. Use data in file “administrator” to answer questions in file “1”.