Exercise Z-Excel File Notes about this le: The file has four tabs Presentation, Analysis, SurveyData, and lssueData. The SurveyData and IssueData tabs contain the data that you will use for Exercise 2. You will not be changing the data. You will use the data from the SurveyData and IssueData tabs to create summary tables in the Analysis tab. You will use these summary tables to create charts and place the charts in the Presentation tab. For this study, 15 participants were asked to use a high-fidelity prototype of an e- commerce website to complete 8 different shopping tasks. While a participant was attempting to complete each task, an observer recorded if the participant encountered any issues. Each issue observed was assigned a unique number ie.g., 1 = Did not see checkout link, 2 = Confused by navigation choices, etc]. The specific issues are not included in the data instead the generic terms of "Issue 1," "Issue 2,\" etc. are used. {See Chapter 5 in \"Measuring the User Experience\" for more information about issues- based metrics.) The Issues data for the study are presented in two tables in the IssuesData tab. There were ten different issues observed during the study. The first table in the IssuesData tab shows the number of times that each participant encountered each issue during the study (i.e., for all of the tasks). For example, Participant 1 encountered Issue 1 once and encountered Issue a once, but did not encounter any other issues. These data support a summary of how many different issues were encountered and how many times each of these issues was encountered in the study. - The second table in the IssuesData tab shows the number of issues encountered by each participant In each of the tasks regardless of the type of issue. For example, Participant 1 encountered two issues in Task 1, but no issues in the other tasks. These data support a summary of how many issues were encountered during each task in the study. After a participant completed all of the tasks, the participant completed a short post- session surveyr that used the 5-point Likert scale below to collect responses to indicate participant perceptions of the prototype used in the study. (See Chapter 6 in \"Measuring the User Experience" for more information about Likert scales.) 3:33: I ' T Agree? 1 2 3 4| 5 l o o l o [ o [ o The questionnaire included the five statements below. For each statement, the participant was asked to provide a response of 1, 2, 3, 4 or 5. I think that overall this product is easy to use. I think that people I know would find this product easy to use. I enjoved using this product. I think that people I know would enjoy using this product. I would purchase this product if it were available at the right price. {See the "System Usability Scale" section in Chapter 6 for information about use of such statements when collecting UX metrics.) The data collected from the questionnaire are presented in the Survey-Data tab. For example, Participant 1 gave a rating of \"5\" for all five of the questions. Performing the Exercise 1. Copy the Exercise Z-Excel le to your computer with the name \"Exercise 2-\". You will use this copy of the file to complete Exercise 2 and then submit the completed Excel file to the Exercise 2 assignment in Canvas. 2. Review the data in the [ssuesData tab and the SurveyData tab to get an initial understanding of the raw data. 3. lIZI'eate Summary Tables in the Analysis Tab for the data in the lssueData tab. 3. Create three tables In the Analysis tab using the labels in the cells indicated in the gure below. Issue Number of Times Encountered mmumunwurn 11 iTask Number of Issues 14 g i i i A E A "|"| H O NHUUHWHH b. In cell 32, type the function =COUNTIF{IssueData |82:816, "1": and then press Enter. This function works the same as the COUNTIF function that was used in Exercise 1. c. Enter the appropriate COUNTIF functions in cells as through B11. The completed table shows the number of times each Issue was encountered in the study. d. In cell 314, type the function ISUMIIssueDatalazomanti and then press Enter. Note: The SUM function is used to calculate a total of the values In a range of cells. Because a participant may have encountered more than 1 issue in a task, the SUM function Is used In place of the COUN11F function. e. Enter the appropriate SUM functions in cells 815 through 321. The completed table shows the number of issues that were encountered in each task In the study. 4. Create a Summary Table in the Anaiysis Tab for the data in the Survey Data tab. For Exercise 2, you will summarize the survey data using what is called a \"hotel boat" and "bottomsl box\". This analysis does not include any ratings in the middle of the stale {i.e., "3"] and provides an indication of general agreement or disagreement with each statement. [See the "Anaiyzing Ratingsscale Data" section in Chapter 6 of "Measuring the User Experience" for a discussion about use oi toolbox scores] 3. Create a new table in the Analysis tab starting in column E with the labels shown below. Be sure to place the "Statement' label in cell F1. Number orTlmn Encountered Statement 1|m' 2 | _\"__ 1 1 1 a a s _a_ 1 rap-2am a" a manor: 5_ a 6 5 _? 6 .9. r _s. a 1.\"..- 5 1'1! II} b. In cell F3. We the function :COUNTIF{5urveyDataIE-2:Bl. ">3"l and then press Enter. This function returns a count of the ratings that are higher than 3. which is what is needed for a top- 2 bus: in this case. c. Enter appropriate functions into cells as through 13 to display the top-2 box counts for Questions 2- 5. d. In oell Fa, type the tunction =COUHTIF{5urveyDataIB-2:B1. "