代做BSYS847 Assessment 2 - Data Analysis Assignment 1代做Processing

项目预算：开发周期：发布时间：要求地区：

BSYS847

Assessment 2 - Data Analysis Assignment 1

This assessment requires you to develop visuals and conduct a descriptive analysis of cyber security performance measures. The hypothetical cyber security performance measures data is for one thousand organizations in an Excel spreadsheet. The lower the compliance score, the lower the cyber security performance.

Please carefully note the following points about the data:

1. Cybersecurity performance is measured in the “compliance score” variable.

2. The organization_id variable presents the unique identifier for each organization.

3. The department_type presents the department within the organization.

4. The control_title variable represents the controls related to cyber security that are used in the organization.

5. The compliance_score variable presents the compliance score for each control applied in the organization.

Using the dataset and the RStudio application, you are required to:

Question 1. Using the Plotly package, develop an interactive bar graph of the average compliance score for each department. Export the interactive bar graph as an HTML file and upload it on Canvas. The HTML file can be named as department_graph_student_name_surname.

Question 2. Using the Plotly package, develop an interactive bar graph of the average compliance score for each control (i.e. control_title). Export the interactive bar graph as an HTML file and upload it on Canvas. The HTML file can be named as control_graph_student_name_surname.

Question 3. Which control, i.e. (control_title), has received the lowest average compliance score?

Question 4. Using the Plotly package, develop an interactive box plot of the compliance score for each control. Export the interactive box graph as an HTML file and upload it on Canvas. The HTML file can be named as box_plot_student_name_surname.

Question 5. Which control title has the highest spread for compliance score?

Question 6. Which control title has an outlier value?

Question 7. Based on the box plot, which control titles are suitable for further analysis? Why?

Please carefully note the following points:

1. You should provide the answers in the form. of bulleted points.

2. The maximum word limit for the assignment is 200 words.

3. The answers must be provided in the Answer Template given below. The same template is also provided as a sperate file. Please note that marks will be deducted if the answers are not provided in the template.