BUSI 614 Week 7 – Cross-Tabulation and T-Test Using SPSS Assignment
BUSI 614 Week 7 – Cross-Tabulation and T-Test Using SPSS Assignment.
CROSS-TABULATION AND T-TEST USING SPSS ASSIGNMENT INSTRUCTIONS
OVERVIEW
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.
INSTRUCTIONS
AT&T Deliverables
1. Run a frequency distribution for all variables except Identification Number.
Note: This database is a third party database from which the description 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?
Including a Narrative in Your SPS Output File
You will note that some of the questions require you to interpret the results. SPSS allows you to include a narrative at any point in the Output file. To include a narrative, follow these simple
steps:
Go to the point in the Output file that you wish to insert new text (highlight the point on the menu to the left), and then go to Insert => New Text.
Including any text in the Output file will reduce the amount of work you need to do in creating a Word document for the narrative. Consequently, you will only have to submit one file (the SPSS Output file) rather than multiple files.
Hypothesis testingThe hypothesis is formulated conventionally as follows (an example):
Ho: There is no significant difference in customer evaluation between contract terms and service coverage.
Ha: There is a significant difference in customer evaluation between contract terms and service coverage.
Hypothesis testing:
Alpha = 0.05.
If p < 0.05, then reject Ho.
p = 0.016, therefore reject Ho and accept Ha.
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
