# Interpreting Tables

I need help interpreting these tables. I have started on them but I do no think they are correct. The solutions would be very helpful for my studies.

Problem 1.

Below is a tabulation of the demographic data from the Frequency distribution of a survey done by Ms. Sandra Jones. Her sample consisted of 148 of a total of 3,700 clerical employees in three service organizations.

Based on the tabulation provided below, describe the sample characteristics.

Table 1: Frequency Distributions of Sample (n = 148)

RACE EDUCATION GENDER

Non-whites = 48 (32%) High School = 38 (26%) Males =111(75%)

Whites = 100 (68%) College Degree = 74 (50%) Females = 37 (25%)

Masters Degree = 36 (24%)

AGE # OF YEARS IN ORG. MARITAL STATUS

< 20 = 10(7%) < 1 year = 5 (3%) Single 20 (14%)

20-30 = 20(14%) 1-3 = 25(17%) Married 108 (73%)

31-40 = 30(20%) 4-10 = 98(66%) Divorced 13 (9%)

>40 = 88(59%) >10 = 20(14%) Alternative Lifestyle 7 (4%)

Here is another tabulation of the Means, Standard Deviations, etc., for Ms. Jones' data.

How would you interpret these data?

Table 2 and 3 are in the word doc, refer to the doc.

This is what I came up with but not sure if it's correct.

Table 1 - Description of the sample characteristics

The race of employees based on the sample are majority white at 68% and non-whites at 32%. The education level is that half of the employees have a college education, 24% of the employees have a master degree and 24% of the employees have a high school degree. The majority of the employees are male at 75% and 25% of the employees are female. The majority of the age of employees are greater than 40 years of age at 59%, 7% less than 20 years of age, 14% between 20 - 30 and 20% between 31 - 40 years of age. Most employees (66%) have worked at the organization from 4-10 years, 17% have worked there 1-3 years, 14% have worked there more than 10 years and 3% have worked there less than a year. The marital status where most employees are married at 73%, 14% of employees are single, 9% are divorced and 4% lead an alternative lifestyle.

Table 2 - Interpretation

Table 2 gives you the average (mean) for each of the variables as well as the standard deviation (average spread of sample data about the mean) and the range (minimum to maximum) for the sample data points. This gives you an idea of the employees in the sample, their average age, average number of years married, average stress, job involvement and performance. This tells you if the sample is similar or different employees are from each other. The average age of employees are 37.5 and the average number of years married for employees is 12.1 years. There's a wide variation in the number of years married (standard deviation = 24) indicating ???

Table 3 - Interpretation

In Table B the variables are correlated with each other. This means that you are seeing if they "move together" closely (strong relationship) or loosely (modest relationship) or not at all (no relationship). It shows that there is a strong relationship between age and number of years married and a loose relationship with the other three variables, stress, job involvement and performance.

Age the dependent variable does not have a highly significantly positive correlation to the four independent variables, numbers of years married, stress, job involvement and performance. This makes sense since age is not a factor in job performance.

© BrainMass Inc. brainmass.com October 17, 2018, 7:31 am ad1c9bdddfhttps://brainmass.com/statistics/correlation/interpreting-tables-516813

#### Solution Preview

Here is another tabulation of the Means, Standard Deviations, etc., for Ms. Jones' data.

How would you interpret these data?

Table 2: Means, Standard Deviations and Other Statistics

VARIABLE MEAN STD. DEV MODE MIN MAX

Age 37.5 18 38 20 64

# of Years Married 12.1 24 15 0 32

Stress 3.7 1.79 3 1 5

Job Involvement 3.9 1.63 4 2 5

Performance 3.6 0.86 3 3 5

From the same research done by Ms. Jones, the following inter-correlation matrix is shown. Interpret these results.

In the age group, there are many people at age of 38. The youngest is 20 and the oldest is 64. Further, all these ages locate within two standard deviations away from the mean. In other ways, there may be no obvious outlier in this data set.

For the number of years married, there ...

#### Solution Summary

The expert examines interpreting tables.

Statistics for Business and Economics - SPSS software

Please try to include the following three elements for each of the question:

? Hypotheses (both null and alternative hypotheses)

? Analysis (Relevant SPSS printouts or Excel)

? Conclusion (interpretation of data)

? Do not need to outline and examine the assumptions that the chosen statistical technique makes (e.g., the distributions have equal variance in a multiple regression analysis) UNLESS stated in question/problem)

1. SPSS computation and Interpretation: The Asian economy faltered during the last few months of 1997. Investors anticipated that the downturn in the Asian economy would have a negative effect on the earnings of companies in the United States during the fourth quarter of 1997. The following sample data show the earnings per share for the fourth quarter of 1996 and the fourth quarter of 1997 (The Wall Street Journal, January 28, 1998).

a. Formulate H0 and H1 such that rejection of H0 leads to the conclusion that the mean earnings per share for the fourth quarter of 1997 are less than for the fourth quarter of 1996.

b. Use the data in the following table to conduct the hypothesis test. At alpha = 0.10, what is your conclusion?

Company Earnings 1996 Earnings 1997

Atlantic Richfield 1.16 1.17

Balchem Corp. 0.16 0.13

Black & Decker Corp. 0.97 1.02

Dial Corp. 0.18 0.23

DSC Communications 0.15 -0.32

Eastman Chemical 0.77 0.36

Excel Communications 0.28 -0.14

Federal Signal 0.40 0.29

Ford Motor Company 0.97 1.45

GTE Corp 0.81 0.73

ITT Industries 0.59 0.60

Kimberly-Clark 0.61 -0.27

Minnesota Mining & Mfr. 0.91 0.89

Procter & Gamble 0.63 0.71

2. SPSS computation and Interpretation:

A factorial experiment involving two levels of factor A and three levels of factor B resulted in the following data.

Factor B

Level 1 Level 2 Level 3

Factor A Level 1 135 90 75

165 66 93

Level 2 125 127 120

95 105 136

a. Formulate the appropriate pairs of H0 and H1 (There are more than one pair of hypotheses in this factorial experiment problem)

b. Construct the ANOVA table - no manual calculation and/or "interpretation" are required for 2(b). Please help show me the manual calculation in addition to computer-generated ANOVA table.

c. Test for the interaction effect as well as main effects (no hypotheses necessary, should be in 2a). Use alpha = .05.

3. SPSS computation and Interpretation: Barron's conducts an annual review of online brokers, including both brokers that can be accessed via a Web browser, as well as direct-access brokers that connect customers directly with the broker's network server. Each broker's offerings and performance are evaluated in six areas, using a point value of 0-5 in each category. The results are weighted to obtain an overall score and a final star rating, ranging from zero to five starts, is assigned to each broker. Trade execution, ease of use, and range of offerings are three of the areas evaluated. A point value of 5 in the trade execution area means the order entry and execution process flowed easily from one step to the next. A value of 5 in the ease of use area means that the site was easy to use and can be tailored to show what the user wants to see. A value of 5 in the range offerings area means that all of the investment transactions can be executed online. The following data show the point values for trade execution, ease of use, range of offerings, and the star rating for a sample of 10 of the online brokers that Barron's evaluated (Barron's, March 10, 2003). Use alpha = .05.

Broker Trade Execution Use Range Rating

Wall St. Access 3.7 4.5 4.8 4.0

E*TRADE (Power) 3.4 3.0 4.2 3.5

E*TRADE (Standard) 2.5 4.0 4.0 3.5

Preferred Trade 4.8 3.7 3.4 3.5

my Track 4.0 3.5 3.2 3.5

TD Waterhouse 3.0 3.0 4.6 3.5

Brown & Co. 2.7 2.5 3.3 3.0

Brokerage America 1.7 3.5 3.1 3.0

Merrill Lynch Direct 2.2 2.7 3.0 2.5

Strong Funds 1.4 3.6 2.5 2.0

(a) Determine the estimated regression equation that can be used to predict the start rating given the point values for execution, ease of use, and range of offerings (keep all three independent variables in your regression model even if you find some independent variable(s) that is/are NOT statistically significant). Briefly interpret answer.

(b) Use the F test to determine the overall significance of the relationship. What is the conclusion at the .05 level of significance? Need the relevant hypotheses before trying SPSS analysis.

(c) Use the t test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance? Need the relevant hypotheses before trying SPSS analysis.

***See attached file for full problem description.***

View Full Posting Details