Загрузка данных


По результатам социологического исследования ответы респондентов на определенный вопрос анкеты представлены в виде выборки:

{A/B_tester; Computer_scientist; Computer_scientist; NA; User_experience_designer; Computer_scientist; Computer_scientist; Computer_scientist; Security_engineer; User_experience_designer; Test_engineer; NA; Network_administrator; User_experience_designer; NA; A/B_tester; A/B_tester; A/B_tester; Test_engineer; Test_engineer; Test_engineer; Test_engineer; User_experience_designer; A/B_tester; Computer_scientist; A/B_tester; NA; Computer_scientist; Security_engineer; A/B_tester; Security_engineer; NA; User_experience_designer; Test_engineer; A/B_tester; A/B_tester; Network_administrator; NA; User_experience_designer; NA; Test_engineer; Security_engineer; Computer_scientist; A/B_tester; Test_engineer; A/B_tester; Security_engineer; Test_engineer; Network_administrator; Computer_scientist; Security_engineer; Test_engineer; NA; Network_administrator; User_experience_designer; Computer_scientist; User_experience_designer; Computer_scientist; Test_engineer; Test_engineer; User_experience_designer; Network_administrator; User_experience_designer; User_experience_designer; Computer_scientist; User_experience_designer; NA; Network_administrator; Computer_scientist; A/B_tester; Security_engineer; A/B_tester; NA; Network_administrator; A/B_tester; Network_administrator; Network_administrator; User_experience_designer; Test_engineer; Test_engineer; User_experience_designer; Computer_scientist; NA; NA; Computer_scientist; A/B_tester; A/B_tester; Test_engineer; A/B_tester; A/B_tester; Computer_scientist; NA; Network_administrator; Security_engineer; NA; NA; Security_engineer; Computer_scientist; Computer_scientist; A/B_tester; NA; A/B_tester; Network_administrator; User_experience_designer; Security_engineer; Computer_scientist; Test_engineer; Security_engineer; Security_engineer; User_experience_designer; Computer_scientist; Test_engineer; User_experience_designer; NA; Security_engineer; Computer_scientist; Network_administrator; NA; NA; Computer_scientist; Security_engineer; Network_administrator; Network_administrator; NA; User_experience_designer; Security_engineer; User_experience_designer; NA; Computer_scientist; Network_administrator; Test_engineer; NA; NA; A/B_tester; Security_engineer; NA; Network_administrator; Computer_scientist; Computer_scientist; Network_administrator; Network_administrator; Security_engineer; Network_administrator; Network_administrator; NA; Computer_scientist; Computer_scientist; Security_engineer; User_experience_designer; Security_engineer; User_experience_designer; NA; Computer_scientist; Computer_scientist; User_experience_designer; User_experience_designer; Security_engineer; User_experience_designer; Computer_scientist; A/B_tester; A/B_tester; Computer_scientist; Test_engineer; Security_engineer; User_experience_designer; Security_engineer; Security_engineer; A/B_tester; User_experience_designer; A/B_tester; NA; Network_administrator; Network_administrator; A/B_tester; User_experience_designer; Test_engineer; User_experience_designer; Network_administrator; Security_engineer; A/B_tester; User_experience_designer; Test_engineer; Network_administrator; A/B_tester; Network_administrator; A/B_tester; Computer_scientist; Computer_scientist; Computer_scientist; User_experience_designer; A/B_tester; User_experience_designer; User_experience_designer; Computer_scientist; User_experience_designer; User_experience_designer; Security_engineer; Network_administrator; Security_engineer; NA; Computer_scientist; A/B_tester; Computer_scientist; A/B_tester; Security_engineer; A/B_tester; Computer_scientist; A/B_tester; Network_administrator; Security_engineer; Test_engineer; Test_engineer; A/B_tester; Computer_scientist; User_experience_designer; User_experience_designer; NA; Security_engineer; Security_engineer; NA; A/B_tester; Computer_scientist; User_experience_designer; Computer_scientist; Test_engineer; Test_engineer; Test_engineer; NA; User_experience_designer; Test_engineer; A/B_tester; NA; A/B_tester; NA; Network_administrator; Network_administrator; User_experience_designer; User_experience_designer; User_experience_designer; Network_administrator; Security_engineer; A/B_tester; A/B_tester; A/B_tester; Security_engineer; Computer_scientist; NA; NA; Network_administrator; Network_administrator; NA; A/B_tester; Network_administrator; NA; Computer_scientist; A/B_tester; Network_administrator; Security_engineer; A/B_tester; Computer_scientist; Test_engineer; A/B_tester; Security_engineer; Computer_scientist; Network_administrator; Computer_scientist; A/B_tester; A/B_tester; User_experience_designer; NA; Test_engineer; Computer_scientist; User_experience_designer; User_experience_designer; NA; A/B_tester; Test_engineer; User_experience_designer; Network_administrator; Computer_scientist; Computer_scientist; Network_administrator; Test_engineer; NA; A/B_tester; A/B_tester; Security_engineer; Test_engineer; A/B_tester; A/B_tester; User_experience_designer; NA; Network_administrator; Network_administrator; NA; Test_engineer; Test_engineer; Network_administrator; Test_engineer; Security_engineer; Network_administrator; NA; Computer_scientist; Security_engineer; Test_engineer; NA; Computer_scientist; NA; NA; Security_engineer; Network_administrator; Test_engineer; Security_engineer; Test_engineer; NA; Security_engineer; Security_engineer; Test_engineer; A/B_tester; A/B_tester; NA; User_experience_designer; Test_engineer; Computer_scientist; User_experience_designer; NA; NA; User_experience_designer; A/B_tester; NA; Security_engineer; Security_engineer; Test_engineer; NA; Network_administrator; A/B_tester; NA; Test_engineer; Network_administrator; Network_administrator; User_experience_designer; Computer_scientist; A/B_tester; Network_administrator; Test_engineer; Test_engineer; A/B_tester; Security_engineer; Test_engineer; Security_engineer; Network_administrator; Security_engineer; Security_engineer; Test_engineer; Security_engineer; User_experience_designer; Test_engineer; Network_administrator; Network_administrator; NA; Network_administrator; Security_engineer; Computer_scientist; NA; A/B_tester; Network_administrator; Computer_scientist; Test_engineer; User_experience_designer; NA; NA; Network_administrator; Security_engineer; Network_administrator; User_experience_designer; User_experience_designer; Network_administrator; Computer_scientist; Network_administrator; Security_engineer; Network_administrator; A/B_tester; Computer_scientist; NA; User_experience_designer; Test_engineer; Network_administrator; Test_engineer; Computer_scientist; Computer_scientist; Test_engineer; NA; Network_administrator; User_experience_designer; Network_administrator; Computer_scientist; A/B_tester; Security_engineer; NA; User_experience_designer; Test_engineer; Security_engineer; A/B_tester; Network_administrator; A/B_tester; NA; Test_engineer; Test_engineer; NA; Network_administrator; Computer_scientist; Security_engineer; NA; Test_engineer; User_experience_designer; Computer_scientist; User_experience_designer; Security_engineer; Test_engineer; Computer_scientist; User_experience_designer; A/B_tester; Security_engineer; NA; NA; NA; NA; A/B_tester; Computer_scientist; A/B_tester; Security_engineer; Network_administrator; Network_administrator; Computer_scientist; NA; User_experience_designer; Network_administrator; NA; A/B_tester; Test_engineer; A/B_tester; NA; NA; Network_administrator; Test_engineer; Computer_scientist; Security_engineer; A/B_tester; A/B_tester; User_experience_designer; NA; User_experience_designer; User_experience_designer; Security_engineer; A/B_tester; User_experience_designer; A/B_tester; A/B_tester; NA; Security_engineer; User_experience_designer; Security_engineer; Network_administrator; Security_engineer; Network_administrator; Network_administrator; Security_engineer; A/B_tester; Test_engineer; Test_engineer; Security_engineer; Computer_scientist; NA; A/B_tester; NA; Computer_scientist; Security_engineer; Test_engineer; Test_engineer; Network_administrator; Network_administrator; Computer_scientist; Network_administrator; NA; Computer_scientist; Security_engineer; NA; NA; User_experience_designer; Network_administrator; User_experience_designer; A/B_tester; A/B_tester; Computer_scientist; NA; Network_administrator; NA; A/B_tester; A/B_tester; Security_engineer; User_experience_designer; NA; NA; Security_engineer; Security_engineer; A/B_tester; Test_engineer; Test_engineer; Security_engineer; NA; Security_engineer; A/B_tester; Security_engineer; User_experience_designer; Security_engineer; A/B_tester; User_experience_designer; NA; A/B_tester; Computer_scientist; Network_administrator; A/B_tester; NA; Security_engineer; Computer_scientist; A/B_tester; Network_administrator; Security_engineer; Test_engineer; Security_engineer; User_experience_designer; A/B_tester; Test_engineer; Network_administrator; NA; Security_engineer; Computer_scientist; NA; User_experience_designer; Network_administrator; A/B_tester; Computer_scientist; Test_engineer; NA; Security_engineer; Test_engineer; User_experience_designer; User_experience_designer; A/B_tester; A/B_tester; Network_administrator; Security_engineer; NA; Security_engineer; A/B_tester; Network_administrator; Computer_scientist; A/B_tester; Test_engineer; Network_administrator; Security_engineer; NA; NA; User_experience_designer; User_experience_designer; Computer_scientist; User_experience_designer; User_experience_designer; A/B_tester; NA; Test_engineer; Computer_scientist; Security_engineer; Test_engineer; A/B_tester; Computer_scientist; User_experience_designer; User_experience_designer; Computer_scientist; Computer_scientist; Network_administrator; Test_engineer; Computer_scientist; NA; Security_engineer; Network_administrator; Security_engineer; Network_administrator; User_experience_designer; Security_engineer; Security_engineer; A/B_tester; Network_administrator; User_experience_designer; Computer_scientist; NA; Network_administrator; NA; Test_engineer; Security_engineer; A/B_tester; A/B_tester; NA; Security_engineer; Computer_scientist; A/B_tester; Security_engineer; User_experience_designer; Computer_scientist; Computer_scientist; Security_engineer; Network_administrator; Computer_scientist; Test_engineer; Computer_scientist; Security_engineer; NA; NA; Test_engineer; Network_administrator; Security_engineer; A/B_tester; A/B_tester; Test_engineer; Security_engineer; NA; Network_administrator; NA; Network_administrator; Network_administrator; NA; Security_engineer; User_experience_designer}.

 
Используя Excel и/или R(RStudio), очистите выборку от пропусков, обозначенных как "NA", и на уровне значимости 0.05 проверьте критерием согласия (Хи-квадрат критерием Пирсона) гипотезу о равновероятном распределении ответов респондентов с помощью критической области. По результатам исследования заполните следующую форму:


п.	Балл	Задание	Ответ
1.	2	Количество степеней свободы 	Ответ для координаты 1
2.	2	Наблюдаемое значение хи-квадрат	Ответ для координаты 2
3.	2*	Критическое значение статистики хи-квадрат 	Ответ для координаты 3
4.	2*	Имеются ли основания отвергнуть гипотезу о равновероятном распределении ответов респондентов на заданном уровне значимости?