# HW5, HW6, HW7 – book used is Essentials of Statistics for the Behavioral Sciences 8th edition.

August 30, 2017

uestion
Course Project Paper

The instructions below assume you know how to use Excel. Watch the Excel screencasts if you do not (or use the Dretzke book); see the Using Excel link for more, and refer to the Course Policies for general information about the papers.

The final project in our statistics course is a “showcase” in which you will show that you can analyze a data set and write a professional report to summarize it. The objectives for the project are as follows:

· To show that you can work with a data set

· To show that you can answer your questions by choosing statistical procedures appropriate to the data

· To show that you can use Excel to perform procedures covered in our course

· To show that you can communicate about statistical results by summarizing and formatting your findings in APA-style

· To show that you can interpret your findings and share them with others in a clear and precise manner

The Data Set
By the end of Unit 6, your instructor will send you a unique data set in an Excel workbook. The data set will include background information about the fictitious organization from which the data were “collected,” and any other information you need to get started.

The Analysis
For your statistical analysis, you will be expected to perform a thorough analysis of your data set. This analysis will include (a) descriptive statistics for all the variables, (c) 4-6 graphs, (d) correlations, (e) regressions, and (f) group comparisons/hypothesis tests (t tests or ?2).

The Report
The report you write to summarize your data analysis should be a well-written and organized document that meets the following criteria:

· Created in Word and saved as a PDF document, just like your other papers

· Double-spaced, with 1-inch margins all around

· 4 to 6 pages long, not including graphs or your Excel spreadsheets

All statistics should be reported in the text using APA style. In other words, merely analyzing your data and supplying the Excel worksheets is unacceptable. You must describe what you found, and report the statistics as you learned to do during Units 1-7.

Your report should include the following sections:

1. An introduction and overview of the project

Give a description of the organization (based on the information you were given). Without discussing the results (yet) give an overview of your analysis. For example, describe the demographics of the group you studied. What relationships did you search for or expect? What group comparisons seemed interesting to you? (Although the data set will be fictitious, a good analyst can think of good questions to ask that can be answered through statistical analysis. That’s what you will do!)

2. Complete descriptive statistics, including at least four graphs (of any type)

Run descriptive statistics procedures on ALL variables, such as averages and measures of variability. Choose some variables for which you can graph the data.

3. Complete correlations and at least one regression analysis

Correlations should be performed on all continuous scales. You must also perform one regression, which ought to be done on the variables that have the strongest correlations.

4. Four group tests (any combination of t or ?2)

Choose groups from your data set that you can compare using the procedures you learned. You can do any type of hypothesis test, in any combination. For example, you could perform four independent samples t tests, or two t tests and two chi-squared tests. Do whatever seems sensible and interesting.

5. Your conclusions, in which you summarize the most important or interesting patterns you found

A good analyst interprets the data for his or her reader. You should write a general summary of what you found. What results were the strongest or most interesting? What do your results mean for the organization whose data you analyzed? What would you recommend based on your analysis?

You must include your data set and all your Excel analyses with your project paper. Hand computations (for example for ?2) are also allowed, but must be scanned and uploaded with the Excel workbook. (Note that you would not include your Excel spreadsheets or data set in a real professional report submitted to colleagues or a journal.)

You will upload these separately. Worksheets should be Excel (.xls, .xlsx) files, NOT PDFs.

See the rubric on the next page for how your report will be scored. Remember:

You will lose points if your project report (i.e., the body of the text) does not contain all the required analyses. Analyses that are in the spreadsheets but not discussed in the paper will NOT COUNT.

In your report, you must report statistics using the APA-style formats covered in your textbooks, which you practiced in your papers. Graphs may be attached to the end of your report. However, they should always be discussed in the body of the report as well (e.g., “As Graph 2 shows, there is a strong positive relationship between rated commitment to the company and the length of time one has worked here.”) If you have any questions about the project, ask your instructor.

Rubric for Scoring the Course Project Report

Weight

Writing: Did you follow the instructions for formatting your paper and include all required sections? Is your paper well-written (with proper grammar, reporting of statistics, and strong organization)? Is the tone professional?

15%

Descriptive Statistics: Did you run complete descriptive statistics and report them in an appropriate fashion using standard reporting procedures*? Did you report on all of the most important measures that others would expect to see in a good report?

20%

Graphs: Did you create at least four graphs (of any kind you choose)? Are they properly labeled and formatted with titles and axis labels? Are they properly reported and referred to in the text (e.g., “Graph 1 shows that….”)?*

10%

Correlations: Did you run complete correlations on your continuous variables and report them in an appropriate fashion using standard reporting* procedures?

10%

Regressions: Did you perform at least one regression analysis and report it in an appropriate fashion using standard reporting* procedures?

5%

Group Comparisons: Did you run at least four hypothesis tests (using z, t,or ?2) and report them in an appropriate fashion using standard reporting procedures*?

20%

Conclusions: Did you discuss your conclusions or recommendations based on the data?

10%

Data analysis: Did you include your data set and all your spreadsheets and other computations to demonstrate that you know how to do your analyses? Are the analyses correct?

10%

*Formatting issues will primarily affect your writing grade, but are listed here to remind you about major issues to address for each analysis.

.0pt;text-align:center”>Course Project Data Set

Description: Your instructor has created a data set that you will analyze for your final project. Your data set is different from that of your classmates, although you all will be working with the same survey and variable set (see below). In analyzing the data set, you will be able to use all of the procedures you have learned on this data set, and you can start working on it when you are ready. By the time you receive this, you will already have practiced with many descriptive statistics and some of the group comparisons.

You have been sent a data set to analyze in an EXCEL spreadsheet. It has its variables listed in each column. These variables correspond to the survey on the next page. The data from each respondent are shown in each row. The first thing you should do is make a copy of the data set, and work from that copy, so that your data are presented. Never work on your only copy of a data set! Notice that the first column contains the “respondent number;” when you administer a survey, you should number each returned questionnaire and enter it into your data set. This provides a column that allows you to put data back in order if you sort, as well as check to see if your data recording was correct.

On the next pages you will see the survey questions that correspond to each variable in your data set. It will be helpful to print it out and write the name of the variable next to each question on the survey (in a brief form that you can easily identify, to create a blank “master copy” of the survey. This practice will help you to easily identify which variable you are referring to while you work on your analysis.

Survey description:

In writing your project paper, you will pretend that you are a member of the HR department in a fictitious manufacturing plant, Superior Manufacturing. You have administered a survey to a random sample of 50 employees from several departments to investigate some questions that you have about benefits. Superior has several contracts with the military, and specializes in manufacturing clothing for soldiers. It employs 237 employees, most of whom are seamstresses, other skilled workers, and inspectors. The company has historically not offered much to its employees by way of benefits, but management wants to explore cost-effective ways to do so. The company is a family-owned business with strong ties to the local community, and is a major employee in the town in which is located.

As you write your paper, you may feel free to make up a few fictitious details to describe the company if you wish. However, most of your report should be based on the data, so don’t spend a lot of time on this sort of thing.J Note that the data may not necessarily seem realistic to you. However, your job is to deal with the data you have.

Examine the survey questions carefully, and determine what the level of measurement is by examining the survey. This will help you choose the correct tests. Take care as you do this that you do not get confused while dealing with the survey data. For example, employees are asked which healthcare plan they current are on, the variable called “Health Care Plan.” In the data set, the plan is recorded as either 0, 1, or 2. However, this is a nominal variable, and the numbers are merely labels. Do not try to do things like get a mean or median for a nominal variable. Any codings used are indicated on the survey for you, but would not appear on the survey administered to respondent. Note too that some variables are not recorded in the data set in the same order as they appear in the survey. However, they should be easily recognizable (e.g., salary).

The survey is on the following pages.

Benefits Survey

Thank you for agreeing to participate in our survey. Your responses are completely anonymous, and will be held in confidence. We will use your responses to make decisions about benefits and to improve our benefits to you. Please answer all the questions, and be sure to ask if you have any questions.

Best wishes,

The HR Department

________years old

Assembly Line Inspector Office Staff Managerial

Question 3: How many years have you worked at Superior Manufacturing? Please indicate your answer in the space below:

________years

Question 4: Approximately how many sick days have you taken in the past year? Please indicate your answer in the space below:

_________sick days

Question 5: Please indicate the HealthCare Plan in which you are currently enrolled by circling it below.

HealthCare Plan 1 [Coded as “1” in the data set]

HealthCare Plan 2 [Coded as “2” in the data set]

No Company Healthcare Plan [Coded as “0” in the data set]

Married/Live with Partner Single/Divorced

Question 7: How many dependent children do you have?

________children

Question 8: Please indicate your current salary in the space below in whole dollars.

\$______________

Opinion Scales: Below you will see a series of rating scales. For each scale, select the number that best represents the extent to which you agree with the statement. Please circle one and only one number.

Question 8:

“Having a healthcare plan that covers most of my family’s healthcare expenses is more important than any other job benefit.”

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 9:

“I would like to have a Health Savings Account as part of my benefits package.”

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 10:

“I feel that the HR department communicates openly and clearly with employees.”

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 11:

Rate your satisfaction with your current healthcare plan, or with your decision not to have healthcare insurance if you have no health care plan.

1 2 3 4 5 6 7 8 9 10

Extremely Extremely

Dissatisfied Satisfied

Question 12:

“I strongly desire dental benefits to be part of the benefits package at Superior Manufacturing—even if I have to pay more for it.”

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 13:

“I strongly desire a high deductible insurance plan to be one of my options in my benefits package.

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 12:

“Management has been very responsive to employee concerns about healthcare costs.”

1 2 3 4 5 6 7 8 9 10

Strongly Strongly

Disagree Agree

Question 13:

If you were given the choice, would you prefer to have increased healthcare benefits, or to receive a raise? Please circle your choice below:

Prefer increased benefits Prefer a raise

Thank you for participating in our survey!

Respondent Number

Age

Job Type

Years at Current Job

# Sick Days

Health Care Plan

Marital Status

# Dependent Children

Importance of Health Care

Desire for HSA

Quality of Communication with HR

Salary

Satisfaction with Current Health Care Plan

Need for Dental Plan

Desire for High Deductible Plan

Rating of Management’s Responsiveness

Ranking of Raise vs. Benefits

101

70

Managerial

1

0

0

Single

1

2

10

2

\$43,513.92

9

10

2

9

Prefer Raise

102

54

Office Staff

8

2

2

Single

0

4

2

7

\$28,730.88

1

3

3

7

Prefer Benefits

103

22

Office Staff

1

4

0

Married/Partner

1

9

7

8

\$25,139.52

9

8

6

9

Prefer Benefits

104

21

Assembly Line

0

5

2

Married/Partner

0

9

2

4

\$25,181.28

6

7

5

8

Prefer Benefits

105

37

Assembly Line

5

2

0

Single

1

2

3

10

\$21,673.44

9

5

3

4

Prefer Raise

106

26

Inspectors

3

2

0

Married/Partner

2

6

1

1

\$26,016.48

10

6

9

2

Prefer Raise

107

23

Office Staff

0

3

0

Married/Partner

2

1

6

10

\$27,478.08

4

9

10

4

Prefer Benefits

108

22

Assembly Line

1

4

0

Single

3

9

6

3

\$21,965.76

8

7

10

9

Prefer Benefits

109

73

Assembly Line

36

6

1

Single

3

3

5

8

\$18,750.24

1

7

8

9

Prefer Benefits

110

67

Assembly Line

10

5

0

Single

3

4

1

10

\$20,441.52

4

5

10

6

Prefer Raise

111

47

Office Staff

9

0

2

Married/Partner

2

2

6

1

\$28,271.52

2

1

6

6

Prefer Raise

112

23

Inspectors

2

0

0

Married/Partner

1

9

8

6

\$29,733.12

3

2

5

5

Prefer Benefits

113

38

Assembly Line

18

4

2

Married/Partner

1

2

6

1

\$22,821.84

2

7

5

5

Prefer Benefits

114

65

Managerial

32

2

1

Married/Partner

2

6

1

9

\$32,009.04

9

1

5

10

Prefer Raise

115

47

Office Staff

9

1

1

Single

0

3

8

2

\$24,826.32

5

8

10

8

Prefer Benefits

116

34

Inspectors

8

8

0

Married/Partner

3

10

4

10

\$29,879.28

7

5

1

1

Prefer Raise

117

81

Assembly Line

3

7

0

Single

1

3

6

5

\$24,137.28

1

8

10

1

Prefer Benefits

118

69

Managerial

7

2

0

Married/Partner

1

6

5

5

\$39,985.20

7

6

2

2

Prefer Benefits

119

23

Office Staff

1

2

1

Married/Partner

2

5

1

7

\$31,152.96

9

7

4

9

Prefer Benefits

120

37

Inspectors

1

5

0

Married/Partner

2

3

10

4

\$29,858.40

2

2

10

3

Prefer Benefits

121

18

Assembly Line

0

6

0

Married/Partner

1

1

8

8

\$22,174.56

7

2

3

5

Prefer Benefits

122

54

Assembly Line

10

6

1

Married/Partner

3

3

6

4

\$22,821.84

9

8

10

7

Prefer Benefits

123

77

Managerial

2

1

1

Married/Partner

0

2

9

1

\$46,771.20

3

4

5

2

Prefer Raise

124

41

Inspectors

5

7

0

Single

0

10

1

10

\$30,338.64

1

10

8

6

Prefer Benefits

125

36

Assembly Line

12

0

2

Married/Partner

0

8

10

5

\$22,988.88

4

8

1

2

Prefer Benefits

126

58

Assembly Line

7

8

2

Single

2

2

7

3

\$22,842.72

5

2

10

4

Prefer Raise

127

75

Assembly Line

1

5

0

Married/Partner

2

3

5

7

\$18,666.72

4

3

2

7

Prefer Benefits

128

50

Inspectors

20

3

2

Married/Partner

1

3

9

1

\$31,361.76

7

10

9

4

Prefer Raise

129

70

Managerial

30

3

0

Married/Partner

3

1

4

9

\$36,748.80

1

4

9

8

Prefer Benefits

130

79

Assembly Line

18

3

2

Single

1

5

9

5

\$20,733.84

4

3

3

5

Prefer Benefits

131

37

Office Staff

1

2

1

Single

3

7

6

9

\$23,886.72

1

2

5

1

Prefer Benefits

132

47

Inspectors

25

7

0

Single

3

1

7

6

\$31,716.72

9

1

6

3

Prefer Raise

133

74

Managerial

17

0

2

Married/Partner

3

5

8

8

\$36,540.00

2

1

5

5

Prefer Benefits

134

43

Assembly Line

15

5

1

Married/Partner

1

3

5

7

\$22,216.32

2

3

9

10

Prefer Raise

135

68

Office Staff

5

1

1

Single

2

9

9

8

\$30,213.36

10

2

4

10

Prefer Benefits

136

78

Inspectors

13

7

0

Single

3

8

5

7

\$28,000.08

6

1

1

5

Prefer Raise

137

62

Inspectors

19

0

1

Single

2

5

1

1

\$26,392.32

3

7

7

5

Prefer Benefits

138

26

Assembly Line

1

8

2

Married/Partner

6

3

4

3

\$24,659.28

1

1

5

2

Prefer Benefits

139

50

Office Staff

1

1

1

Single

3

7

6

1

\$30,192.48

2

8

2

8

Prefer Benefits

140

52

Assembly Line

5

5

1

Married/Partner

3

8

10

1

\$24,471.36

3

1

5

7

Prefer Benefits

141

23

Assembly Line

1

1

2

Single

1

10

6

6

\$20,274.48

6

10

4

2

Prefer Benefits

142

27

Assembly Line

2

4

2

Single

0

5

3

8

\$24,283.44

4

6

6

3

Prefer Benefits

143

41

Assembly Line

20

0

0

Married/Partner

3

10

3

5

\$18,729.36

3

9

6

10

Prefer Benefits

144

63

Assembly Line

35

0

1

Single

1

3

3

2

\$22,654.80

2

3

9

1

Prefer Benefits

145

36

Assembly Line

3

1

1

Married/Partner

2

1

9

8

\$18,979.92

6

5

7

7

Prefer Benefits

146

44

Assembly Line

1

2

1

Single

2

6

10

9

\$20,525.04

5

1

9

5

Prefer Benefits

147

49

Assembly Line

27

4

2

Single

1

5

3

1

\$22,341.60

10

9

8

3

Prefer Benefits

148

36

Assembly Line

14

6

0

Married/Partner

4

6

8

9

\$23,176.80

7

6

10

8

Prefer Raise

149

58

Assembly Line

24

8

1

Single

0

5

1

1

\$21,736.08

6

5

8

8

Prefer Benefits

150

41

Assembly Line

14

1

1

Single

3

9

9

2

\$23,302.08

2

3

9

9

Prefer Raise

Get a 30 % discount on an order above \$ 100
Use the following coupon code:
RESEARCH
Positive SSL