Excel Data Analysis, HW 2: Visual Search Experimentgoals:Learn how to organize data using the Excel sort function (Data / Sort / )Learn how to use other statistical functions (Formula / Insert Function).Learn how to create a simple graphSubmission procedureYour file should have the following name:(your last name)_e2 (e.g., yamauchi_e2.xls)Send your report [email protected] the subject box, enter “your-last-name_e2” and your university ID (UID)For example, if I am submitting my Excel Homework 2, then my subject box should be:yamauchi_e2 12345678Tasks:Task 1: (40% of your total score; Table 10%, Graph 30%)Fill out the table and draw a graph (not here but on your excel sheet). Your graph should look like below. Format your graph exactly as shown below.Task 2: (60% of your total score; Tables 20%, graph 40% )Fill out the tables and draw graphs separately for male and female subjects. Your graphs should look like below. Format your graphs exactly as shown below.01/13/19, 8:06 PM 1/3Excel Data Analysis, HW 2: Visual Search Experimentgoals:Learn how to organize data using the Excel sort function (Data / Sort / )Learn how to use other statistical functions (Formula / Insert Function). Learn how to create a simple graphSubmission procedureYour file should have the following name: (your last name)_e2 (e.g., yamauchi_e2.xls)Send your report [email protected] the subject box, enter “your-last-name_e2” and your university ID (UID)For example, if I am submitting my Excel Homework 2, then my subject box should be:yamauchi_e2 12345678also save your file as “your-last-name_e2”01/13/19, 8:06 PM 2/3Tasks:Task 1: (40% of your total score; Table 10%, Graph 30%)Fill out the table and draw a graph (not here but on your excel sheet). Your graph should look like below. Format your graph exactly as shown below. feat.present feat.absent conj.present conj.absent4 ????? ????? ????? ?????16 ????? ????? ????? ?????64 ????? ????? ????? ?????01/13/19, 8:06 PM 3/3Task 2: (60% of your total score; Tables 20%, graph 40% )Fill out the tables and draw graphs separately for male and female subjects.Your graphs should look like below. Format your graphs exactly as shown
View Full Document