please i need help with this exercise:

Exercise 3-Excel File Notes about this le: I There are 3 tabs: Data, Analysis, and Presentation. I The data in the Data tat] represent the Time on Taslt in seconds for tsting of two different prototypes designated as Prototype A and Prototype B. The same task was used for both prototypes and the time to complete the task was recorded for each participant. A total of 20 participants were induded in the study. A standard ABBA method was used for counterbalancing the order in which the prototypes were tested: Participant 1 used Prototype A, Participant 2 used Prototype B, Participant 3 used Prototype B, Participant 4 used Prototype A, and so on. There are therefore 10 time scores for each prototype, but these scores are intermixed in the Data tab. Performing the Exercise This exercise involves: [1] calculating means and standard errors of the means for each prototype, {2] using a t test to dEtErmine ifthe time data indicate that there is a significant diffErEmE bethEn Prototype A and Prototype B, and {3} creating a column chart to displayr the data. 1. Transfer data to the Analysis tab Because the data are somewhat unwieldy to manage when intennixed in a single column, the rst steo is to move the data to the Analysis tab and to separate the data for Prototype A and Prototype B. a. In the Analysis tab, enter "Prototype A" in cell El and enter "Prototype B\" in cell C1. b. Enter the function =DataIC2 in cell BI, which displays the score for Participant 1. c. Enter the corresponding functions in cells 33-311 to display the scores for the remaining participants who used Prototype A cl. EntE1r the function =Dataic3 in cell C2, which displays the score for Participant 2. e. Entetr the corresponding functions in cells 34211 to display the scores for the remaining participants who used Prototype B 2. Calculate the means and standard errors of the means a. Enter "Mean\" in cell A13. b. Enter \"Standard Error\" in cell A14. c. Enter the function avenncrtaznn] in cell 513 to display the mean for Prototype A. d. The standard error ofa mean is a measure ofvanability mat is calculated by dividing the standard deviation by the square root of the number of data points used to calculate the mean. Enter the function =[sroevri32:a11nrrsoh'rtcouur{ez:e11m in cell 314 to display the standard error of the mean for Prototype A. e. Enter the corresponding functions to calculate the mean and standard error of the mean for Prototype B so they are displayed in cells (:13 and C14. f. Use the Decrease Decimal button to decrease the decimal places to 1 [e.g., xx.x}for means and standard errors. 3. Use a t test to determine the probability that the difference between the scores for Prototype A and Prototype B is due to \"chance.\" A t test is a common way to determine if there is a "statistically signicant\" difference between the scores for bird conditions. Excel can calculate t tests, but you need an Analysis Toolpak add-in that is provided with Excel. but needs to be installed. 3. Install the Analysis Toolpalr in Excel. With your Excel file open, click on the Ofce button [upper left cornerL then click on the Excel Options button at the lower n'ght of the Office menu. In the Excel Options window, click on Add-Ins on the left side. In the Add-Ins window, select I"Analysis Toolpak" from the list and click "OK\". After you complete these steps, you can click on the Data tab in Excel and you should see a Data Analysis button. b. Enter =1TE5T[BZ:311, 21211, 2, 2] in cell Elli, which Iwill return a probability value. 32:311 are the cells w'rth scores for Prototype A. 01211 are the cells with scores for Prototype B, the rst \"'2\" is u5ed to select a 2-tailed test. and the second "2" is used to indicate that the scores are from independent samples {i.e., different sets of participanls]. c. In cell A16, enmr the text \"t test: p value="' to provide a label for the p value that is displayed in cell 315. The probability value faulting from a t test - typically repremed by p indicates the probability that these sets of Scora would occur simply due to chance. In general, for usability studies. it p is less than .05, then the difference is considered statistically significant. A p of .05 means that there is only a 5% chance [1 chance out of 20}that this difference would have Damned due to chante. It is therefore determined that it is very likely that the observed difference in times is due to the differences between the dign of Prototype A and the design of Prototype B. See Section 2.4.1 and the Excel Tip at the end of that section in "Measuring the U5er ExperienceI for more information about using a t test. 4-. Create a column chart to Show the means for the raw time data for Prototype A and Prototype B. 5. Add error bars to the chart to Show the standard errors of the means. The value of showing error bars for the standard errors of the means is that a general "rule of thumb" is that if the error bars do not overiap in this type of comparison of two conditions, then difference between these conditions is likely to be signicantly signicant. {As with other "rula of thumb", this isn't always true. so you still need to use something like a t test to check.) The steps for adding the error bars may be slightly different across different versions of Excel. The "Excel Tip" at the end of Section 2.3 in \"Measuring the User Experience\" provides instructions for adding error bars for an example with data similar to the data in this exercise. although this example uses 90% condence intervals instead of standard errors. You can follow this example and simply select your standard error values at the steps in the example where the values for the condence intenrals were selected. The video at this link provides a slightly different, but related, example, which may also be helpful: WW 6. Add appropriate labels to the chart. For example, the chart title can he \"Mean Time on Task for Prototypa A and B Error bars represent standard errors ofthe mean)\" and the vertical axis can be labeled \"Time on Task lseoo ndsl." The nal chart should look slmllar to the one below. Mean Time on Task for Prototypes A and B {Error bars represent standard errors} 10D Time on Task [sects ndsl H W #- Ll" Bl 'Iul M U) U U U U U U U U . U U Prototype A. Prototype a