12-15 pg double spaced Research and Design Paper. Excel Proficiency required. Th

12-15 pg double spaced Research and Design Paper. Excel Proficiency required. The research design proposal will raise a research question, review relevant literature, develop a testable hypothesis, and propose a research design to test the hypothesis.
Below i have linked:
– Expectations for the Research Design
– The database and the codebook for it. (I chose Religious Affiliation as Independent variable and how serious people view climate change as dependent variable.
– Lab 4 (this is me attempting to do the t-test for this paper, however, I don’t think I did it right. The professor later gave the class suggestions. I have included those suggestions at the very bottom. basically whatever the questions of this lab are, is what is supposed to be included in the research design data section.
– I have also included power point slides that may help you that the Professor assigned.
Professor’s suggestions
1. Data not always cleaned properly. Many opinion variables were measured on ordinal scales (e.g. 1 Strongly support, 2 Support, 3 Oppose, 4 Strongly oppose) but included Not sure responses coded as 98. This means you get misleading numbers if you do NOT clean/code out the not sure responses. E.G. mean response to “carbontax_support_epa” is 22.74 if you don’t code this out, and 2.80 when you do. When you develop these analyses further for your final papers, you should be sure to clean/remove these responses properly. You should also think about the real world meaning of the average, relative to your scale – e.g. if your ordinal scale is 1-4, then a mean of 2.8 indicates an average response close to “Oppose” while a mean of 22.7 is meaningless.
2. T-tests should test your hypotheses, not compare two different variables. In some cases, I saw t-tests that compared one variable (e.g. ideology) to another (e.g. support for X policy), finding them significantly different. When your hypothesis is “conservatives are more/less likely than liberals to support X”, you need to filter support for the policy by ideology (using the filters command in Excel we’ve covered previously), then compare those two subsets – e.g. responses for policy support among conservatives to responses among liberals – through your t-test.
Thanks