RES/710: Statistical Research Methods And Design I Wk 2 Excel Practice: Organizing and Visualizing Data Assignment Instructions In this assignment, you'll organize a small dataset, calculate summary statistics by category, and create visualizations to explore patterns in the data. You'll use the provided Excel file to complete this assignment. Follow the steps below to organize the data, run calculations, and create charts. When you're done, upload your completed Excel file as your assignment deliverable. Step 1: Prepare the Dataset Download the Excel Practice: Organizing Visualizing Dataset. Review the data on the first tab labeled Survey Data. The dataset includes employee satisfaction scores from three departments: Customer Service, Marketing, and IT. Before continuing, sort the data by Department (A to Z) so that responses from each department are grouped together. Step 2: Create a Summary Table In the Survey Data tab below your sorted dataset, create a summary table that shows the number of responses and the average satisfaction score for each department. Include the following in the Summary Table: Department name Count of responses Average satisfaction rating Be sure your summary table is clearly labeled and easy to follow.

11:28 PM Thu Oct 23 2 51% . . . res710_v6_wk...lizing_dataset Home Insert Draw Page Layout Formulas D Q ... Calibri (Body) 11 AA ~ A General A . .. V I V EV fx Enter text or formula here C D E F G M N O Q R U V W Department Satisfaction Rating Customer Service 6 Customer Service Customer Service Customer Service Customer Service Marketing 6 Marketing Marketing 10 Marketing 11 Marketing 12 Marketing Chart Title 14 15 Department Count ASR Customer Service 20 Marketing 7 7.2 1 2 Count ASR 26 28 30 36 37 Survey Data