Create a bar graph of the means for weight lost in pounds

Reference no: EM133709426

Homework: Research Methods in the Social Sciences- Running and Interpreting a t-Test Using Excel

Overview:

For this homework, you will apply your knowledge of experimental research to determine if there is a statistically significant difference between mean (average) outcomes for an experimental (Intervention group) group and a control group. You will run "descriptive statistics" and a "t-test" using a sample data scenario and set described below. The descriptive statistics will tell you means and standard deviations regarding the outcomes measured; the t-test will tell you if there is a statistically significant difference between the two means of the outcomes measured.

Instructions:

In a hypothetical study, a researcher randomly assigned participants who had trouble dieting into one of two groups - an experimental (Intervention group) or a control group. In the experimental group, participants completed an intervention where were asked to think about how life would be better if they dieted and how life would be worse if they did not. Participants in the control group did not receive any sort of intervention. At the start of the study, all participants weighed 300 pounds. A month after the study began, participants were weighed again, and the number of pounds lost was recorded. The data collected is listed below. It was hypothesized that participants in the intervention group would lose more weight, on average, than participants in the control group.

Intervention Group (Weight Lost in Pounds)	Control Group (Weight Lost in Pounds)
20	2
21	1
17	0
18	2
21	0
22	0
16	3
17	1
20	0
16	2
14	4
17	1
22	0
16	3
17	2

Part I

For the data set above, determine the following:

A. The mean and standard deviation for weight lost in pounds for the intervention group.

B. The mean and standard deviation for weight lost in pounds for the control group.

Directions for Running Descriptive Statistics in Excel (Means and Standard Deviations):

In the Resources section of the Unit, review the PowerPoint: "Running a t-Test in Excel". This describes how to run both Descriptive Statistics and a t-test.

1) Enter the Data Set Above into Excel
2) Click Data
3) Click Data Analysis
4) Click Descriptive Statistics
5) Input Range (Select Data Columns)
6) Check Summary Statistics
7) Click OK

Part II

A. Run a t-test and determine the t statistic.

B. Was there a statistically significant difference in mean scores for weight lost in pounds between the intervention group and the control group? How can you tell? Look at the p value for assistance. Explain your answer.

Directions for Running a t-Test in Excel

1) Click DataClick Data Analysis
2) Click t-test (assuming equal variance)
3) Indicate Variable 1 Range
4) Indicate Variable 2 Range
5) Enter .05 as your alpha level
6) Click OK

Part III

A. Create a bar graph of the means for weight lost in pounds for both the intervention group and the control group. Add a title and label your axes.

Directions for Creating a Bar Graph in Excel

Refer to the video under Readings and Resources in Unit 6, entitled, "Column Graphs and t-test in Excel" for help in creating a bar graph using Excel. You may also refer to the "Creating a Bar Graph in Excel" PowerPoint under the Unit 6 Readings and Resources.

Reference no: EM133709426

Questions Cloud

How the lexical definitions and connotations of valid : Discuss how the lexical definitions and connotations of valid and warranted can help us understand the differing purposes of deductive and inductive

Describe scholarly sources relevant to a particular theory : Describe credible and scholarly sources, relevant to a particular theory. Apply a social psychological theory to a chosen case study.

Examine the criteria used to evaluate your assignment : Examine the criteria used to evaluate your assignment to find out how to get the highest grade for your work.

Explain why esophageal squamous cell carcinoma : BIOS251 Anatomy & Physiology Define adenocarcinoma, metaplasia, and dysplasia and Explain why Esophageal squamous cell carcinoma is more likely to arise

Create a bar graph of the means for weight lost in pounds : Create a bar graph of the means for weight lost in pounds for both the intervention group and the control group. Add a title and label your axes.

What tools techniques and approaches that you would take : What tools, techniques, and approaches that you would take if you were working with partners who were experiencing sexual dysfunctions?

What populations can conclusions be generalized to and why : What populations can the conclusions be generalized to, and why? Why was the study design (quantitative or qualitative) the appropriate design?

Explain how each technology can assist you in making plan : Explain how each technology can assist you in making a plan, scheduling related tasks and communicating the plan to each of the members of the team involved.

Car bumpers has compartment syndrome of both thighs : A child who was crushed between two car bumpers has compartment syndrome of both thighs. This patient will be closely monitored for signs of rhabdomyolysis

User Account

All Pages