Reference no: EM132251284
SPSS QUANTITATIVE ASSIGNMENT 1 -
INSTRUCTIONS - There are 2 SPSS data sets for this 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 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:
A - What is the number of people in your household?
B - How many non-family members do you have in your household?
C - 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.
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.
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 varibales have greater than 10 class intervals or are ratio data you will need to transform these valiables into new 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 testing -
The 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.
SPSS QUANTITATIVE ASSIGNMENT 2 -
INSTRUCTIONS - There are 2 SPSS data sets for this 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. Regress (Q7F) on these variables: (Q7A-Q7E and Q7G-Q7K). Interpret these results.
2. Do those who currently have or do not have a wireless service from a carrier other that AT&T Wireless (Q3) differ in terms on the evaluations of AT&T on all of the attributes (A7A-Q7K) when these variables are considered simultaneously? To accomplish this task, run a 2 group discriminant analysis.
3. Can the evaluations of AT&T on all of the attributes (Q7A-Q7K) be represented by a reduced set of factors? Conduct a principal components analysis using varimax rotation and then save and upload the factor scores and plots.
IBM Deliverables
1. Do survey participants who have different IT roles (Q1) differ in terms of dimensions of overall measures (Q4-Q7) when these variables are considered simultaneously? Since there are no value labels in the IBM data set, assume role 3 to be IT.
2. Do survey participants who have different IT roles (Q1) differ in terms of dimensions of image (variables Q8-Q17) when these variables are considered simultaneously?
3. Do survey participants who have different IT roles (Q1) differ in terms of dimensions of purchase (variables Q18-Q21) when these variables are considered simultaneously?
4. Do survey participants who have different IT roles (Q1) differ in terms of sales and service support (variables Q22-Q26) when these variables are considered simultaneously?
5. Do survey participants who have different IT roles (Q1) differ in terms of future trends variables (Q27A-Q27G) when these variables are considered simultaneously?
6. Can the image variables (Q8-Q17) be represented by a reduced set of variables?
7. Can the likelihood of purchase variables (Q18-Q21) be represented by a reduced set of variables?
8. Can the sales and service support variables (Q22-Q26) of the questionnaire be represented by a reduced set of variables?
9. Can the future trends variables (Q27A-Q27G) of the questionnaire be represented by a reduced set of variables?
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.
SPSS Steps:
- Multiple Regression: Go to Analyze =>Regression =>Linear=>Select Dependent Variable (scale data only)=>Select Independent Variables (usually scale data but can contain nominal)=>OK.
- Discriminant Analysis: Go to Analyze => Classify => Discriminant => Grouping Variable (must be nominal data) => Define range => Independent Variables (scale data) => Statistics => Box's M => Classify => Summary Table => OK.
- Factor Analysis: Analyze => Dimension Reduction => Factor => Select Variables (must be scale data only) => Extraction => Scree Plot => Continue => OK.
Important: Do not restrict yourself to the steps listed. Have fun and experiment with options/layout/different stats options/graphs, etc. Read up on how to interpret results.
Attachment:- Assignment Files.rar