Directions: For the Excel assignment, you will be conducting analysis on a given dataset. Using Microsoft Excel you will use the datafile staffsurvey Procedure: You are a researcher in a large Fortune 500 HR department. You have conducted an employee survey. Your goal is three-fold (i.e., parts 1, 2 and 3 below): Part 1: Determine employees' views of level of importance for various corporate components. Develop a scale using the variables: "q1imp, q2imp, q3imp, q4imp, q5imp, q6imp, q7imp, q8imp, q9imp, q10imp". Title the scale it "Important Factors". Report the Cronbach's Alpha value in the Word document. Report whether the scale deemed reliable in the Word document. Calculate in the individual means for all above variables (q1imp-q10imp). NOTE: delete all Null/Missing information from the variables and leave blank prior to calculating the means. Based on the means, report which variable/factor your employees view as the single most important in the Word document. o Hint: the highest value signifies the most important. Create a new variable in the dataset entitled "qimpTOT". Add it to the dataset directly after the variable "qimp10". This variable should be a summation of the above 10 variables (i.e., qimp1-qimp10). o Hint, each response for qimpTOT should be the individual respondent's q1imp + qimp2 +....qimp10 total score. Part 2: Determine if views of importance are correlated to years of service with the organization. Using the newly