Reference no: EM13242845
A Survey of 50 Companies
In January '08, fifty customers of a lumber manufacturer were surveyed regarding their satisfaction with products and service. These customers buy from the supplier and sell to retail chains like Home Depot and Lowes. Shortly after, the manufacturing company was sold. In June '08, the customers were telephoned and interviewed and were asked to rate overall satisfaction again.
Variable

Position

Label

Measurement Level


id

1

ID

Scale

Participant ID number

delivery

2

Delivery Reliability

Scale

On a scale of 1 to 10, how would you rate the reliability of delivery of your orders?

Prodsat

3

Product Satisfaction

Scale

On a scale of 1 to 10, how would you rate your satisfaction with the quality of your most recently purchased products?

Techsat

4

Technical Support

Scale

On a scale of 1 to 10, how would you rate your satisfaction with the technical support?

Salesat

5

Salesforce

Scale

On a scale of 1 to 10, how would you rate your satisfaction with the sales support?

Size

6

Firm Size

Ordinal

0 = small (less than 100 emp.) 1 = large (100 or more)

Usage

7

Usage Level

Scale

What percent of your purchases are from our company?

Satjan

8

Overall Satisfaction in January

Scale

On a scale of 1 to 7, rate your overall satisfaction with your most recent purchasing experience.

Satjun

8

Overall Satisfaction in June

Scale

On a scale of 1 to 7, rate your overall satisfaction with your most recent purchasing experience.

Structure

10

Structure of Procurement

Nominal

How your purchasing is structured?
0 = Decentralized; 1 = Centralized

OwnType

11

Type of Ownership

Nominal

0 = Publicly Traded; 1 Privately owned

PurType

12

Type of Purchasing

Nominal

1 = Private Label; 2 = Company Brand; 3 = Both

For each research question, describe in your Microsoft Word document the application of the seven steps of the hypothesis testing model.
Step 1: State the hypothesis (null and alternate).
Step 2: State your alpha (unless requested otherwise, this is always set to alpha = .05).
Step 3: Collect the data (use one of the data sets).
Step 4: Calculate your statistic and pvalue. (This is where you run spss and examine your output files.)
Step 5: Accept or reject the null hypothesis. (This is where you report the results of your analyses t (df) = tvalue, p = sig. level.)
Step 6: Assess the Risk of Type I and Type II Error. (Did the data meet the assumptions of the statistic, effect size, and sample size?)
Step 7: State your results in APA style and format.
Part 1
Question 1: How do small companies compare to the major competitor?
The trade association magazine published a report that this company's major competitor accounts for about 60% (60.0) of their small customers purchases. Is this company's Usage different than their competitors?
1. Use Select Cases to choose companies with less than 100 employees (Firm Size=0).
2. Run a single sample ttest using usage as the dependent variable, and 60.0 as the test value.
3. Report the descriptive statistics, assumptions tests, as well as tests of statistical significance.
Question 2: Is there a difference between small and large companies in their overall satisfaction with the company as rated in January?
1. Run an independent samples ttest.
2. Use size as the independent variable.
3. Use overall satisfaction in January as the dependent variable.
4. Report the descriptive statistics, assumptions tests, as well as tests of statistical significance.
Question 3: Has satisfaction with the manufacturer changed since the change in company ownership?
1. Run the paired samples ttest
2. Use satisfaction in January and satisfaction in June as the variable pair.
3. Report the descriptive statistics, assumptions tests, as well as tests of statistical significance.
Write a brief conclusion statement summarizing your results. What can you tell this manufacturing company about their customers? What could you suggest they do to improve?
Part 2:
Question 1: Are there differences in perceptions of delivery reliability between the companies who resell as a private label, manufacturer brand, or a combination of both?
1. Run the oneway ANOVA.
2. Use type of company sales as the independent variable.
3. Use delivery reliability as the dependent variable.
4. Select descriptive statistics and tests of homogeneity.
5. Choose an appropriate posthoc comparison to evaluate the differences between groups.
Question 2: Did company size and structure of procurement impact overall customer satisfaction in January?
1. Run a twoway between groups ANOVA.
2. Use size and structure of procurement as independent variables.
3. Use overall satisfaction in January as the dependent variable.
4. Report the descriptive statistics, assumptions tests, effect sizes (partial eta) as well as tests of statistical significance.
Question 3: Has overall customer satisfaction changed since the change in ownership? And, are smaller companies more satisfied than larger companies?
1. Run a oneway between groups ANCOVA.
2. Use size as independent variables.
3. Use overall satisfaction in January as the covariate.
4. Use overall satisfaction in June as the dependent variable.
5. Report the descriptive statistics, assumptions tests, effect sizes (partial eta) as well as tests of statistical significance.
Write a brief conclusion statement summarizing your results. What can you tell this manufacturing company about their customers? Has the change in ownership improved customer satisfaction? What types of customers seem to be most satisfied with this company?
Part 3
Question 1: Is there a relationship among the variables measuring different aspects of customer satisfaction?
1. Run a Pearson correlation matrix using delivery reliability, product satisfaction, technical support, sales satisfaction, overall satisfaction in January and overall satisfaction in June.
2. Create a scatterplot for the following pairs: (1) delivery reliabilityoverall satisfaction in June; (2) product satisfactionoverall satisfaction in June.
3. Report the descriptive statistics, assumptions tests, as well as tests of statistical significance identify of positive and negative relationships.
Question 2: Does delivery reliability impact overall satisfaction in June?
1. Run a simple regression using delivery reliability as the independent variable and overall satisfaction in June as the dependent variable.
2. Report the descriptive statistics, assumptions tests (scatter plots), as well as tests of statistical significance.
Question 3: Does delivery reliability and product satisfaction impact overall satisfaction in June?
1. Run a stepwise multiple regression using delivery reliability and product satisfaction as the independent variables and overall satisfaction in June as the dependent variable.
2. Report the descriptive statistics, assumptions tests (scatter plots), as well as tests of statistical significance.
Write a brief conclusion statement summarizing your results. What can you tell this manufacturing company about the relationship among satisfaction variables? Are there any areas they need to improve? Does adding a second variable to the regression equation increase prediction of customer satisfaction?
Part 4
Question 1: Before the change of ownership, the company was encouraging its customers to reduce private labeling as a way to reduce cost of goods sold. Explore the distribution of customers by company sales. Does the distribution of customers (private label, brand label, or both) differ from what one would expect by chance?
 Run a chi square goodness of fit using Company Sales as the variable with "all categories equal".
 Report the observed and expected values and the tests of statistical significance.
Question 2: Run a chi square goodness of fit using purchase type as the variable with "all categories unequal" for the expected value.
1. Run a chi square goodness of fit using purchase type as the variable with 12, 26, and 12 as the expected values.
2. Report the observed and expected values and the tests of statistical significance.
Question 3: Is there a relationship between the type of purchasing and the structure of procurement?
1. Run chisquare independence test (crosstabs) using type of purchasing in the rows and structure of procurement in the column.
2. Use the chi square and the phi coefficient to evaluate the relationship and statistical significance.
3. Report the observed and expected values and the tests of statistical significance.
Attachment: business.sav