Q$1.$ Perform Technology Risk assessment using data in excel sheet $$week$7-$data$$ in the attached Excel file $$Week$7-$Risk$\_$Assessment$.$ Use column $$emails$$ which has unstructured data, and extract topics using the sheet $$Week$7-$Risk$-$Matrix$.$ Use $$Topic Extract$$ model available in MeaningCloud Add$-$on$.$

a$.$ Perform Risk Assessment and calculate the risk score:

$1.$Extract Technology events from the unstructured data

$2.$Count events for each category

$3.$Calculate likelihood and impact

$4.$Calculate the risk levels and ratings in the attached sheet

b$.$ Using Linear Regression, find the coefficients and equation of Regression after normalizing the data as in the sample regression sheet. Use Risk factor as dependent variable and features as independent variables. Convert all textual categorical variables to numeric, and clean data if necessary.