You will want to start by looking over your printouts. Even if you've done statistical analyses before, every computer system has its own way of displaying results, so don't be surprised if you have to re‑learn how to make sense of these. Included in Memo 3 are some sheets on reading SPSSPC printouts. By the way, you are welcome to copy these results for your local collaborators, if you think this is a good idea.
The variables in the first printout are listed in the exact order as the questions in the questionnaire, so you might keep the questionnaire handy while you look at the printouts. The variable names and labels should make obvious which variable shows the results from which question.
At the end of the first printout, however, you will see several additional "constructed" variables. I will define the new constructed variables for you here as a quick reference:
PRIMI—First‑time parents (=1) versus experienced parents (=2), based on their answers to question 26.
NON-2-PARENT—Single parents, whether they are living with their own parents or another adult (=2) versus parents living with a spouse (=1).
LOWEDUC—Parents with less than a high school degree (=2) versus those who have at least completed high school (=1).
LOWINC—Families earning less than $14,000 last year (=2) versus those earning $14,000 or more (=1).
NO FRIENDS – Socially isolated (=2) versus not socially isolated (=1) parents, defined as having "friends in this community who are expecting a baby or have young children." (This is just question 29 reversed, so that isolated parents have the high number [=2]).
I also constructed several alternative indices of risk status. These are useful for seeing if "at risk" parents benefit more from the newsletter series than do "non-risk" parents. This kind of information can be useful in targeting our programs for maximum impact, or showing that they have greatest impact where it is needed most. Here are explanations of the risk variables.
RISK1: “4 RISK CATEGORIES” —This variable indicates whether (=2) or not (=1) the parent is in any of the four basic risk categories (all but primi). In other words, this is a two‑level risk index, in which first‑time parents (primis) are put in the non‑risk group.
RISK2: “2-LEVEL RISK VAR” —I formed a second two‑level "risk index" based on all five of the risk factors listed above. If a parent reported being primiparous, in a non‑two‑parent household, low education, low income, or isolated (all as defined above), then this parent was defined as at risk (=2). Otherwise the parent was defined into the non‑risk group (=1). In other words, this is similar to the variable "RISK" (above) except that, in this case, first‑time parents are moved from “non-risk” to “risk group.”
RISK3: “3-LEVEL RISK VAR” —This is a three‑level risk variable, like the one above but with first‑time parents separated out as their own group. If the parent was in any of the RISK categories above, excluding "PRIMI," then she received a value of "3" for this variable. If she wasn't in the other risk categories, but was a first‑time (primiparous) parent, she got a value of "2" for this variable. Otherwise she got a value of "1" (non‑risk group). (Note that if she was both a first‑time parent and in one of the four RISK categories, then she got a value of "3," not "2," for this variable.)
NRISK—How many parents were in two risk categories, how many in 3, etc.? This variable tells you.
I refer to this package of printouts as a "standard set."
Next Steps
I have kept a copy of your printout in my office. As you page through your printouts, feel free to write notes all over them. I find that is a good way to begin the process of turning numbers into meaningful sentences of text. Your task now, after the initial excitement of these printouts wears off, is to turn these numbers into an interesting story-—a draft of a report.
To facilitate this process, you should download a copy of a model report as a writing template, if you have not already done so. It will make your work easier to use the same basic form and sentences as the earlier report. You may still modify that basic report as much as you like. In fact you will have to modify it: your results will inevitably look somewhat different from others. For example, in discussing the most useful sources of parenting information reported by parents (questions 6 through 15), the source described as “very useful” by the highest percentage of parents might be different in your results than in Badger County. Modify accordingly. And, of course, you may choose to emphasize different findings than we did in the earlier report, or to include results that we ignored.
As an initial step toward drafting your report, I recommend you modify the figures (charts) in the report first. Just cross off the numbers and write the correct numbers for your results in their place. Once you have done this, you can refer to your corrected figures when writing (or changing) the text.
On page 9 of your report, you will need to compute the percentage of married couple families raising children in your county. To do this, go to the U.S. Census Fact Finder. Put in your county and state and click on “Go”. Look for Social Characteristics and then click on “Show more”. To compute the percentage of married couple families raising children out of all families raising children divide “Married couple families with own children under 18 years” by “Family households with own children under 18 years old”.
The Crosstabs by RISK Status
I calculated cross-tabulations of the basic outcome variables (Questions 18-19, 21-22, and 24-25) using the different risk variables. I do this so we can select the index of risk that produces the simplest and clearest contrast of groups. I have also summarized these results on a one-page "crosstabs" summary sheet (you received this along with your printouts), which shows the percentage of each group who answered “yes” to each of the questions about behavior change. We will use these results to produce your own version of Figure 8.
Look at the “crosstabs” summary sheet that was sent to you. You can see that similar contrasts were produced by the different indices of risk. Most of the contrasts produced the result we expected, namely that a greater percentage of the “risk group” parents would report positive changes in their behavior due to the newsletter, as compared to the “non-risk” parents. Asterisks on the crosstabs summary sheet mark contrasts that were statistically significant for your data. I recommend using the comparison (set of contrasts) that is strongest for your Figure 8 (this is marked on your summary sheet). This will make a simple and powerful version of Figure 8 in your report. If the comparison that is strongest (for your data) is the contrast between “risk group" and “non-risk” parents, then you can modify the appropriate section that is included in the Badger County Report. If the comparison that is strongest (for your data) is the contrast between “first time” and “experienced” parents, a section is included with this Memo that you can modify to use in your report (simply click on the underlined link).
Lie Scale Items
Two lie scale items (questions 20 and 23) were used to check for intrusion of social desirability or response set bias in our results. Each item asked about something that might have been in the newsletters, but wasn't. If a respondent reported having learned about both of these topics in the newsletters, then we strongly suspected that their answer to these and all other questions were biased by either response set or social desirability bias, or by both biases.
If any respondent answered "yes" to both of these questions in your data, this respondent was deleted from the data file before conducting any of the statistical analyses (frequencies and crosstabs) to increase the accuracy (reliability) of the results.
"Percent" versus "Valid Percent"
You may have a question about whether to report the "percent" or "valid percent" from your printouts. Valid percent is the percent if missing data are excluded from the calculation. In general, I would use the "percent" for any question that had a "yes" or "no" answer, making the conservative assumption that people who didn't answer are really answering "no." I would report "valid percent" in the cases of socio-demographic variables (questions 26 to 31), where it is important that all the categories add up to100%.
After you've looked over the results, you can email me with any questions or comments you have. It's always helpful to compare notes on how we are interpreting the results.
Rounding off to Whole Numbers
I recommend rounding off to integers. This is more honest: we don’t really have accuracy to the nearest tenth or hundredth of a percent! And it makes for a much friendlier report, especially for people who are “math phobic.”
Here are the two rules I use for rounding. First, round to the nearest whole number, so 4.4 becomes 4, while 4.6 becomes 5. Second, if the number is exactly between two integers, round to the nearest even number. In that case 7.5 would become 8 (since 8 is even, while 7 is odd), and 8.5 would also become 8. By using this method, we ensure that numbers are rounded up or down about an equal number of times, without our being able to affect the number in a way that favors our own desired outcome.
Quotations from Respondents
Hopefully you have already transcribed the comments onto typed pages. These are very helpful to read, not to mention gratifying! After you edit the numbers and the basic text of the report, you can go back and insert quotations from the respondents in your own county. You will see from the earlier Badger County report the kinds of places where quotes fit well, but you can insert them in other places as well. I recommend no more than three or four in a row; otherwise, the reader may get impatient. These quotes do not provide “evidence” for our conclusions the way our data do, but direct quotes are a powerful way to provide “examples” of our main findings. They help our conclusions come alive.
It is okay, indeed admirable, to include a few quotations that run contrary to our main conclusions. You can say something like, "A small minority of respondents disagreed strongly, as evidenced by this comment: . . ." Doing this is part of being fair and truthful, and it will raise your credibility with the reader.
Next Steps after Drafting the Report
Once you have written changes onto the earlier (Badger County) report, so that it will fit your results, then send it to me through the mail along with the corrected figures. Don’t forget the page of acknowledgments to recognize any collaborators you have, your secretary, etc.
As your co‑author, when I receive your draft I will go over every sentence and every number to verify accuracy and to ensure that we haven't left anything important out. I will also think hard about each interpretation or conclusion we include, to see if they are supported by the actual results. I will add my own editing marks to your correction copy and give it to my secretary to produce a new laser‑printed draft for you (she will have the "standard" report on her computer, so making a modified report should be efficient). I will mail this draft (with new figures) to you so you can see exactly what changes I made. This takes up to four weeks (making the figures is the hard part, and we run the proof through two drafts before sending it to you, to get out the typos, etc.). The draft I mail back to you will probably be the final draft, but you have the option of marking changes on this draft and sending it back. (I promise very speedy turnaround time on re-drafts.) We are co‑authors, so you are always welcome to argue with me about changes I have recommended. The report isn't final until we both approve it. I will also send the report to you by email as a pdf file, so you can print copies from your office computer. **If you prefer to have your office produce the report, just let me know. I will still want to review the correction draft. **
We should consider for whom the report is being written and what impact we hope it to have. The best option, in my view, is to write it for your local collaborating organization(s) and/or for a local agency or organization that might be convinced to fund the distribution of the newsletter for the future. We should hope for such an impact in every case. The results of our evaluation make a strong case for the impact of the newsletter. Who would be influenced by these results to budget some money?
If you have any questions about how to proceed, Memo 4 discusses the "next steps" in more detail. There are a variety of ways you can use the final report as an educational tool. Memo 4 lists a few of these, but here is a preview. I always recommend that you use your results for presentations in your county. Some groups will be interested in hearing a report of your evaluation because of the topic (e.g. health professionals, parent educators), but many others will be interested simply because they are interested in their communities (e.g. Kiwanis, Lioness Clubs, etc.). To help in presentations like this, we include a draft copy of a 2-fold evaluation summary sheet . Use this as a sample of something you could produce in your own office. A sheet like this can be handed out to everyone who attends your presentations. After you receive the finished draft of the report go to Memo 4, which also includes some sample press releases.
We always talk about how Extension educational programs are “research based.” With this project, you will be teaching based on your own research!
If you have any questions as you proceed with drafting your report email us at: dariley@wisc.edu or costergr@wisc.edu
Enjoy!
Your Co‑Investigators,
Dave Riley, Ph.D.
Child Development Specialist, UW-Extension
Rothermel-Bascom Professor and Assoc. Dean for Outreach & Extension
School of Human Ecology
1300 Linden Drive
University of Wisconsin
Madison, WI 53706
|
Carol Ostergren, Ph.D.
Outreach Specialist
School of Human Ecology
UW-Madison/Extension
1300 Linden Drive
University of Wisconsin
Madison, WI 53706
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|