Gender Differences in Searching for Health Information Article Summary Questions Apply your new statistical knowledge in the analysis of a research paper.

Gender Differences in Searching for Health Information Article Summary Questions Apply your new statistical knowledge in the analysis of a research paper. Analyze mock t-test data using the Excel Analysis ToolPak. Review materials and the article to finish assignment.The first part is Apply your new statistical knowledge in the analysis of a research paper. The second part is analyze mock t-test data using the Excel Analysis ToolPak. Assignment 9
Objective
Apply your new statistical knowledge in the analysis of a research paper. Analyze mock t-test data using the
Excel Analysis ToolPak.
Preparation
Review the article assigned in this week’s materials, Gender Differences in Searching for Health Information on
the Internet and the Virtual Patient-Physician Relationship in Germany: Exploratory Results on How Men and
Women Differ and Why. Install the Excel Analysis ToolPak and follow the steps below.
Assignment
PART A (25 points)
Summarize the article (Gender Differences in Searching for Health Information on the Internet and the Virtual
Patient-Physician Relationship in Germany: Exploratory Results on How Men and Women Differ and Why:
Link https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4526954/) by answering the following questions. Your
answers do not need to be in paragraph/paper format, you may post your answers after each question in the
order in which they appear.
•
•
•
•
•
•
•
•
•
•
What did the researchers hypothesize?
How were the data collected?
What were some important characteristics of the sample?
Was this an experiment, a quasi-experiment, or a non-experiment?
What variables were the researchers most interested in?
How did they analyze their results? Try your best to use your own words here! Focus on the analyses
with t-tests.
What did the researchers find? (i.e., What were the results?)
Were these results similar to or different from previous studies?
What conclusions can we make from this research? In other words, what do we know now that we
didn’t know before?
What were some limitations of this research?
Know that there may be some statistical language or psych jargon that is not completely clear. That is OK. You
are still new to this! As long as you get the general idea of the assignment, you’re fine. ?
PART B (25 points)
Follow these steps to analyze mock data using an independent samples t-test.
1. Read about Excel and the ToolPak and install it on your computer. If you have trouble, please contact
me as soon as possible.
2. Open a blank Excel spreadsheet and make sure the ToolPak is installed. Having trouble finding the
Toolpak? Select “Alt” type “t” and then type “i” and select the Analysis Toolpak from the menu that
1
appears. Still don’t see it? Select the “Data” dropdown menu (pictured below) to see the Data Analysis
option (on the top right corner of the spreadsheet, circled in red in the picture on the next page).
3. Watch this video (Link: https://www.youtube.com/watch?v=DN4_1ynREIU) to learn how to
conduct an Independent Samples t-test using the Excel ToolPak.
4. Imagine you are an evaluator who has collected data from 20 villages in India, 10 where 1/3rd or more of
the village council seats are filled by women and 10 where less than 1/3rd of the seats are filled by
women. This is our “independent” or grouping variable and it has 2 levels: “less” represented by a “1” in
the table below and “more” represented by a “2” in the table below. Our “dependent” variable is the
percent of the village’s budget that is spent on issues central to women such as public assistance for
widows and maternity care. Enter these data into your Excel spreadsheet just as they appear
below. This example should sound familiar. Remember the week 1 assignment?! ?
Make-up of Village Council
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
% of Budget Spent on Issues
Central to Women
10
5
6
4
8
8
9
8
4
5
10
10
20
11
7
9
11
8
14
8
5. Conduct an independent samples t-test (assuming unequal variances) with the mock data. Fill in the
blank spaces below with the information from your Excel output file. Note that if p < .05, there is a statistically significant difference between the 2 groups. 2 Mean for group 1 (fewer women on the councils) Mean for group 2 (more women on the councils) t Critical two-tail (our t-statistic) P(T Purchase answer to see full attachment