By this week, you should have completed data collection on at least 30 participants who met the qualifications to complete the survey (e.g., at least 18 years or older, have other specific characteristics that make them a member of the population you intended to study).
The data for your short survey should be entered into the Excel database that you created last week. With this data set, complete the following:
- Calculate descriptive statistics for your main independent and other variables you have collected information on (example: demographic variables).
- Create a bar chart for the participants’ gender and ethnicity.
- Create a histogram for participants’ age.
- Calculate descriptive statistics for your dependent variable.
- Create a summary table of your descriptive statistics.
- Hint: For categorical variables, you should be calculating frequencies and percentages; for continuous variables, you should be calculating means and standard deviations.
- Use one hypothesis-testing statistic that examines the relationship between your independent variable and dependent variable.
- Hint: This test should be one of the following—independent samples t-test, paired t-test, one-way ANOVA, or Pearson’s chi-squared test.
- Write the null and alternate hypotheses.
- What is the calculated statistic value?
- What is the p and critical statistic value?
- Is the p value significant? Is calculated statistic value greater than critical value?
- What is your conclusion?
Want to see an example of a summary table? Click here: Summary Table
Need Excel help? Click on the Excel Function Help Workbook under Course Materials.
Due: Sunday, 11:59 p.m. (Pacific time)
Points: 150
Expert Solution Preview
Introduction: As part of your medical college coursework, you have been collecting data for a short survey and entering it into an Excel database. Now, you need to analyze the data and complete several tasks related to calculating descriptive statistics, creating charts and tables, and conducting hypothesis testing.
1. To calculate descriptive statistics for the independent and other variables, you can use Excel’s built-in functions such as AVERAGE, COUNT, and STDEV for continuous variables, and COUNTIF and SUMIF for categorical variables. To create a bar chart for gender and ethnicity, you can use the chart wizard in Excel and select the appropriate chart type. To create a histogram for age, you can use Excel’s Data Analysis Toolpak, which provides a histogram function.
2. To calculate descriptive statistics for the dependent variable, you can use the same Excel functions mentioned above.
3. To create a summary table of the descriptive statistics, you can use Excel’s PivotTable feature. This allows you to summarize and aggregate data across multiple variables. For categorical variables, you should calculate frequencies and percentages, and for continuous variables, you should calculate means and standard deviations.
4. To conduct hypothesis testing, you need to select an appropriate test based on the type of variables you have and the research question you want to answer. For example, if you have two groups of participants and a continuous dependent variable, you can use an independent samples t-test. If you have more than two groups, you can use a one-way ANOVA. If you want to test the relationship between two categorical variables, you can use Pearson’s chi-squared test. Before conducting the test, you need to write null and alternative hypotheses. You also need to calculate the test statistic value, p-value, and critical statistic value. If the p-value is less than the significance level (e.g., 0.05), then the result is statistically significant. You can then draw a conclusion based on the result and the research question.
