Introduction to a variety of useful statistical ideas and techniques - Improving the User Experience through Practical Data Analytics - page 41

1.5 SUMMARY
This chapter has explored several basic ideas that you need to know as a UX researcher.
First, we introduced the normal curve and discussed how it is actually a very important
probability curve. After illustrating how to work with probabilities and values associ-
ated with a normal curve, we very speciically discussed how to determine probabilities
associated with the mean of several values (e.g., satisfaction ratings) that you may
encounter as a UX researcher. We then examined the basic aspects of conidence inter-
vals and hypothesis testing to ease us into their use in subsequent chapters.
1.6 ADDENDUM: ACTIVATING “DATA ANALYSIS”
As we said earlier, to ind a conidence interval in Excel, in fact, to do any statistical anal-
ysis in Excel, beside such routine calculations of a sample mean or standard deviation,
etc., you need to irst “activate” a module or section of Excel called “Data Analysis.” It
exists within Excel, but you would not necessarily know about it unless you are told.
The irst step is slightly different depending on whether you have Excel 2007
2010 or 2013. In Excel 2007, the irst step is to click on the “ofice button;” using
Excel 2010 and 2013, you click on the ile menu. Either way, you identify and click
on Excel Options (see Figure 1.26 ).
After clicking on “Excel Options,” you get a dialog box, and need to simply click
on “Add-Ins” (see arrow in Figure 1.27 ). At this point, differences among the differ-
ent versions of Excel disappear.
FIGURE 1.26
Beginning the process of activating Data Analysis in Excel.