Use the ” Churn” dataset to complete the data preparation…

Question Answered step-by-step Use the ” Churn” dataset to complete the data preparation…  Use the ” Churn” dataset to complete the data preparation activities in Microsoft Excel. This dataset represents customer account information from BigTel.Using Microsoft Excel, explore whether there are missing values for any of the variables with screenshots. If so, specify the variables that have missing data, the rows that have the missing values, and, using the mean imputation technique, the specific values that you enter into the dataset for the fields that have missing data. Note that the actual Excel file does not need to be updated.Using Microsoft Excel, compare the area code and state fields and identify any apparent abnormalities. If abnormalities are determined, explain how they should be addressed in subsequent analyses.Using Microsoft Excel, determine whether there are any outliers among the number of calls to customer service and identify the method used to make this determination. Use the graphical method and the Z score method. For the graphical method, assume a bin size of 1. For the Z score method, assume+/- 4 Z score boundary points for outliers.Image transcription textA B D E F G H K M N O P Q R S U Area Int’l VMail VMail Day Day Day Eve Eve Eve Night Night Night Intl Intl IntlCustServ 1 State Length Code Phone Plan Plan Message Mins Calls Charge Mins Calls Charge Mins CallsCharge Mins Calls Charge Calls Churn? 2 KS 128 415 382-4657 no yes 25 265.1 110 45.07 197.4 9 … Show more… Show more  Engineering & Technology Computer Science BIT 445 Share QuestionEmailCopy link Comments (0)