Posted: March 15th, 2022

Use the appropriate function to read the following data into R as a data frame named lab7.data: CLICK HERE Download CLICK HERE

The data set represents several attributes on data breaches across several organizations. It includes 500 observations and 10 variables. The names and descriptions of each variable in the data set is provided below.

event_ID: used to label each event

data_type: the type of data breached

num_people (in millions): the number of people impacted by a data breach, expressed in millions

num_people_v2: coded version of the variable num_people

num_records (in millions): the number of records breached, expressed in millions

per_sensitive: percent of sensitive data breached

per_sensitive_v2: coded version of the variable per_sensitive

dys_impact: the length of the negative financial impact from the data breach

dys_detect: the number of days it takes to detect the breach

cost_controls (in millions): the amount of money spent on security controls, expressed in millions

1.

Use the best subsets approach to determine which variable(s) would best predict the cost of controls. Please be sure to exclude categorical variables such as event_ID.

NOTE: Please note that predictors is being used as a placeholder for the actual predictors in your model. In your answer below, make sure you replace all the blanks, such as [1] and [2], with the correct syntax so that the lines of code work. Make sure you also include the variable names of your predictors in place of predictors.

bestsubsets = [1]([2]~ predictors, data = [3], [4])

[5]([6], [7] = “adjr2”)

2.

The single best one-variable model includes which of the following variables?

Group of answer choices data_type

num_people

num_people_v2

num_records

per_sensitive

per_sensitive_v2

dys_impact

dys_detect

3.

The single best two-variable model includes which of the following variables?

Group of answer choices data_type

num_people

num_people_v2

num_records

per_sensitive

per_sensitive_v2

dys_impact

dys_detect

4.

The single best three-variable model includes which of the following variables?

Group of answer choices data_type

num_people

num_people_v2

num_records

per_sensitive

per_sensitive_v2

dys_impact

dys_detect

5.

The single best four-variable model includes which of the following variables?

Group of answer choices data_type

num_people

num_people_v2

num_records

per_sensitive

per_sensitive_v2

dys_impact

dys_detect

6.

Run five separate regression models that represent the five models shown in the best subsets plot in R. Number your models sequentially from Model 1 to 5 based on the number of predictors it includes. Provide the Adjusted R2 values for each of your five models below.

Note: Please the report the values as displayed in R. Do not round them.

Model 1:

Model 2:

Model 3:

Model 4:

Model 5:

7.

After examining the significance of the predictors in each model and their Adjusted R2, which of the following models provides the best fit for predicting the cost of controls?

Group of answer choices Model 1

Model 2

Model 3

Model 4

Model 5

Model 6

8.

Evaluate Model 5 for multicollinearity and provide the estimates below.

The highest VIF among your predictors is:

The lowest tolerance among your predictors is:

Note: Please report each of these values as displayed in R. Do not round them.

9.

Based on the results from your calculations for the tolerance, you can conclude that for Model 5 there is:

Group of answer choices a potential concern for multicollinearity.

a serious concern for multicollinearity.

no concern for multicollinearity.

10.

Based on the results from your calculations for the VIF, you can conclude that for Model 5 there is:

Group of answer choices a concern for multicollinearity.

no concern for multicollinearity.

11.

Use R to generate a correlation matrix for the predictors used in Model 5. Based on your results, the strongest correlation can be found between which of the following two predictors?

Group of answer choices num_people

num_records

per_sensitive

dys_impact

dys_detect

cost_controls

12.

The value of the strongest correlation between your predictors is:

Place an order in 3 easy steps. Takes less than 5 mins.