Proteach
BUSI 331
SPSS Writing Assignment Supplemental Materials
International Operations at CarCare Inc.
Synopsis
CarCare is considering expanding its operations beyond the United States. The company wants to know whether it should target countries with customers who tend to have a positive attitude toward their current cars. It has gathered data on US and German car owners. The data is included below. Using the data and outputs provided, please analyze the test for the cross-tabulation, t-test, ANOVA and multiple regression outputs. This data is also presented through presentations within Modules/Weeks 6 and 7.
Data from CarCare Survey
Key:
Att=Attitude toward current car
Attnew = Attitude toward new car
Car = 0 import, 1 domestic
Country = 0 Germany, 1 USA
*Note: the "spend" category in the data set represents the amount the respondent spends on car care products.
|
Att |
Car |
Country |
Spend |
Attnew |
|
12 |
1 |
1.00 |
148.96 |
13 |
|
15 |
1 |
1.00 |
368.99 |
14 |
|
14 |
1 |
1.00 |
164.97 |
12 |
|
14 |
1 |
1.00 |
391.96 |
13 |
|
7 |
1 |
1.00 |
321.23 |
15 |
|
10 |
1 |
0.00 |
425.76 |
14 |
|
14 |
1 |
0.00 |
297.51 |
12 |
|
21 |
1 |
0.00 |
521.45 |
15 |
|
14 |
1 |
0.00 |
377.86 |
13 |
|
14 |
1 |
0.00 |
216.09 |
17 |
|
14 |
1 |
0.00 |
409.03 |
13 |
|
12 |
1 |
0.00 |
405.48 |
9 |
|
19 |
1 |
0.00 |
301.15 |
11 |
|
12 |
1 |
0.00 |
315.07 |
14 |
|
14 |
1 |
0.00 |
263.32 |
13 |
|
10 |
1 |
1.00 |
449.00 |
14 |
|
10 |
1 |
1.00 |
273.16 |
11 |
|
18 |
1 |
0.00 |
397.58 |
11 |
|
17 |
1 |
0.00 |
224.77 |
14 |
|
17 |
1 |
0.00 |
263.34 |
15 |
|
15 |
1 |
1.00 |
511.98 |
12 |
|
12 |
1 |
1.00 |
270.06 |
14 |
|
20 |
1 |
0.00 |
616.74 |
13 |
|
14 |
1 |
1.00 |
306.70 |
12 |
|
15 |
1 |
0.00 |
218.69 |
11 |
|
19 |
0 |
0.00 |
299.44 |
17 |
|
14 |
0 |
1.00 |
616.10 |
18 |
|
14 |
0 |
1.00 |
385.53 |
12 |
|
17 |
0 |
0.00 |
470.30 |
13 |
|
12 |
0 |
1.00 |
450.37 |
12 |
|
15 |
0 |
0.00 |
447.48 |
12 |
|
18 |
0 |
0.00 |
397.41 |
17 |
|
11 |
0 |
1.00 |
330.39 |
11 |
|
14 |
0 |
1.00 |
468.46 |
12 |
|
13 |
0 |
1.00 |
240.87 |
12 |
|
14 |
0 |
1.00 |
329.31 |
17 |
|
12 |
0 |
1.00 |
377.76 |
11 |
|
18 |
0 |
0.00 |
634.15 |
12 |
|
19 |
0 |
0.00 |
503.09 |
18 |
|
11 |
0 |
1.00 |
354.38 |
10 |
|
15 |
0 |
1.00 |
196.14 |
11 |
|
16 |
0 |
0.00 |
430.06 |
11 |
|
15 |
0 |
1.00 |
180.19 |
14 |
|
16 |
0 |
0.00 |
363.73 |
14 |
|
15 |
0 |
1.00 |
302.65 |
12 |
|
14 |
0 |
1.00 |
344.51 |
17 |
|
17 |
0 |
1.00 |
206.46 |
16 |
|
15 |
0 |
1.00 |
487.85 |
14 |
|
15 |
0 |
1.00 |
433.90 |
13 |
|
16 |
0 |
0.00 |
206.13 |
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Frequencies: Spend & Attnew Statistics |
|||
|
|
Spend |
Attnew |
|
|
N |
Valid |
50 |
50 |
|
|
Missing |
0 |
0 |
|
Mean |
358.3495 |
13.2009 |
|
|
Median |
359.0576 |
12.8904 |
|
|
Mode |
148.96a |
9.15a |
|
|
Std. Deviation |
118.13352 |
2.13797 |
|
|
a. Multiple modes exist. The smallest value is shown |
Cross-tabulation: Country and Car with Bar Chart
Independent Samples T-Test: Spend and Country
One-Way ANOVA: comparing Countries on selected variables of Att and AttNew
Bivariate Regression Analysis: Independent variable of Attnew and Dependent Variable of Spend
Multiple Regression Analysis: Dependent Variable of Attnew and Independent Variables of Att, Spend and Country
Page 6 of 7