Multiple regression in r studio

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: