Here's what we'd like you to do with the user-satisfaction data that you have:īegin by distinguishing between the interval-level, ordinal level, and categorical level variables in these data. Of this assignment calls for you to talk to calculate a variety of descriptive statistics and do some interpretation.
Everything here, by the way, can be computed by hand, if you're so inclined - but I don't recommend it. The basic point is that you need to acquire a certain facility with using Excel to perform certain basic functions to complete this exercise. There are also a wide variety of other Excel learning tools accessible on the Internet, if you want to search for yourself. These are not the greatest tutorials in the world, but they basically do the job.
XLSTAT SPEARMAN HOW TO
You can click here to access a page with a number of tutorials on how to carry out specific procedures in Excel. If you have access to Excel, but do not have the ability to use XLStat, then you can still fall back on Excel's statistical capabilities by doing it yourself. There will be a tutorial on the use of this program forthcoming shortly. Basically, it's a series of Excel workbooks that you unzip into a directory and then call through a macro-based interface to Excel that the program itself installs. It's a very useful front end to Excel that makes it easy to use the various statistical functions, once you spend a little time becoming familiar with the XLStat interface itself.
XLSTAT SPEARMAN INSTALL
If you have the ability to download and install a program, then we recommend that you check out XLStatistics (found at You're about ready to start doing some analysis. From your earlier work with data, you'll recognize that some of the variables are demographic descriptors of the patrons of the store, while some are measures of their buying behavior and others are measures of attitudes.
The first worksheet holds the actual numerical data the second worksheet (labelled "labels") contains a basic codebook listing the variables and the codes associated with each. 582 customers were surveyed in all, and each case represents the responses from a single customer." This is a hypothetical data file that concerns a satisfaction survey conducted by a retail company at 4 store locations. The data themselves are from a set prepared for teaching purposes by SPSS Inc.
The data that we will use for this exercise are contained in a downloadable spreadsheet As we said, we recommend the use of Excel to calculate what you need to calculate. Once you have a feel for what descriptive statistics are and why they might be interesting, then you can turn to some practical experience.
0 kommentar(er)
