Reference no: EM132875346

CROSS-TABULATION AND T-TEST USING SPSS ASSIGNMENT INSTRUCTIONS

There are 2 SPSS data sets for this module/week's SPSS assignment: AT&T and IBM. Do not forget to review the synopsis of each data set. You will need to upload each SPPS output separately.

AT&T Deliverables
1. Run a frequency distribution for all variables except Identification Number.
Note: This database is a third party database from which thedescription of three variables has been lost. Therefore I would suggest the following variable types that you can use and that you can code into your database:
Q9A - What is the number of people in your household?
Q9B - How many non-family members do you have in your household?
Q9C - How do you rate the quality of Cingular's international roaming service?
0 = not applicable
1 = excellent
7 = highly unreliable
2. Cross tabulate "Do you currently have a wireless service from a carrier other than AT&T Wireless" (Q3) with the demographic variables (recoded Q8-Q11). What does it mean? Provide your narrative in the note taking function in the SPSS output file. see notes below
Note: (You will need to first examine each of the variables to ensure that they are either nominal or interval with 10 or fewer class intervals. To do this go to variable view in the data file. If some variables have greater than 10 class intervals or are ratio data you will need to transform these variables into new variables with say 4 categories. By running a frequency distribution and examining the range plus highest and lowest data values you should be able to determine how many categories to create and the data range that you will need to specify for each category.You should have no problem creating these new variables as you practiced the transform function in Assignment 3. Use this procedure whenever you have to do a cross-tabs).
3. Run an independent samples t-Test for variables (Q7A-Q7K). Q3 is the grouping variable. Is the result significant? Formulate the null and alternative hypotheses. Include this narrative in your SPSS output file - see notes below
4. Do the respondents evaluate AT&T more favorably on contract requirements (Q7E) than they do on coverage (Q7A)? Run a two-tailed paired samples t-Test to answer this question. Formulate the null and alternative hypotheses. Include this narrative in your SPSS output file - see notes below
5. Do the respondents evaluate AT&T more favorably on high-quality customer service (Q7I) than they do on lower prices (Q7K)? Run a two-tailed paired samples t-Test to answer this question. Formulate the null and alternative hypotheses.Include this narrative in your SPSS output file - see notes below
6. Do the evaluations of AT&T on a selection of phones (Q7G) exceed 5.0? What are the managerial implications of these results?Include this narrative in your SPSS output file - see notes below.

IBM Deliverables
1. In this survey, participants of what role (Q1) and what size of companies (Q2) are most represented? HINT: cross-tab the 2 variables. Examine the chi square statistic. What does it mean? Provide your narrative in the note taking function in the SPSS output file.
Note: (You will need to first examine each of the variables to ensure that they are either nominal or interval with 10 or fewer class intervals. To do this go to variable view in the data file. If some variables have greater than 10 class intervals or are ratio data you will need to transform these variables into new variables with say 4 categories. By running a frequency distribution and examining the range plus highest and lowest data values you should be able to determine how many categories to create and the data range that you will need to specify for each category.You should have no problem creating these new variables as you practiced the transform function in Assignment 3. Use this procedure whenever you have to do a cross-tabs).
2. Conduct a cross-tab of IT role (Q1) with dimensions of the overall measures of the firm being evaluated (variables Q4-Q7). Assume role 3 to be IT. Examine the chi square statistic. What does it mean?
3. Conduct a cross-tab of IT role (Q1) with dimensions of image (variables Q8-Q17). Examine the chi square statistic. What does it mean?
4. Conduct a cross-tab of IT role (Q1) with dimensions of likelihood of purchase (variables Q18-Q21). Examine the chi square statistic. What does it mean?
5. Conduct a cross-tab of IT role (Q1) with dimensions of sales and service (variables Q22-Q26). Examine the chi square statistic. What does it mean?
6. Conduct a cross-tab of IT role (Q1) with dimensions of IT measures of the firm being evaluated (variables Q27A-Q27B). Examine the chi square statistic. What does it mean?

Attachment:- Quantitative Assignment Instructions.rar