Calculate descriptive statistics using excel including

Assignment Help Other Subject

Reference no: EM133475319

Homework: Social Science Paper

Description

For the homework, you will conduct a quantitative study that will include three parts: (i) Descriptive Statistics, (ii) Inferential Statistics, and (iii) Discussion of your findings.

You will choose a data set for this homework (See Step 1 - Excel Set Up)

To guide you in this homework, go through the 7 steps needed to complete the homework. You can access the 7 steps in this module and you can see the attched file for detial

• The 7 Steps provided in this module will give you the opportunity to submit a discussion post for Q&A and/or if you want me to review your work (this is optional)

Part I: Descriptive Statistics

Write a research question appropriate for descriptive statistics derived from the description of the dataset you chose (see Step 2)

Calculate descriptive statistics using Excel including: mean, standard deviation, variance, mode, & range (see Step 3)

A. Write your descriptive results in summary form including: mean, standard deviation, variance, mode, range, maximum and minimum (see Step 3)

Provide an interpretation of your descriptive findings (see Step 3)

Run a correlation between two variables providing the r-value (aka, correlation coefficient) for interpretation (ex. high positive linear correlation) (see Step 4)

B. Provide a scatterplot based on the two variables you ran in your correlation analysis (see Step 4)

Part II: Inferential Statistics

Write a research question appropriate for inferential statistics derived from the description of the dataset you chose (see Step 5)

State your steps for hypothesis testing including (see Step 6):

Null hypothesis and alternative hypothesis

A. Alpha level (state desired significance level/direction)

Calculate either an independent samples t-test (gender, age, etc.) OR a paired samples t-test (pulse 1 vs. pulse 2) in MS Excel. Choose One t-test (See Step 6)

Provide your results from the t-test (see Step 6)

D. Interpret the t-test findings (i.e., make a determination): Reject or retain the null hypothesis (see Step 6)

Part III: Discussion

A. Discuss the findings from your study (see Step 7).

Reference no: EM133475319

Questions Cloud

Vietnam each contribute to the new ideology : How did the Nixon Shock, the Arab oil Shock, the Watergate Affair and the Final Collapse in Vietnam each contribute to the new ideology?

How counselors understand counselees and task of counseling : Determine the implications of the imago Dei for how counselors understand counselees and the task of counseling.

Dramatic increase in american population : What allowed the dramatic increase in American population during the 18th century?

What was communication style of the meetings leader : Was the meeting opened with an announcement or explanation of its purpose and importance? What was the communication style of meeting's leader or facilitator.

Calculate descriptive statistics using excel including : Write a research question appropriate for descriptive. Calculate descriptive statistics using Excel including: mean, standard deviation, variance, mode & range.

Describe your own political socialization process : Describe your own political socialization process. Make sure to include the different factors that have shaped your political beliefs.

Prepare the financial statements for period : Prepare the Financial Statements for period. Be sure to complete all three required documents (Income Statement, Statement of Owners Equity and Balance

What implications in agribusiness digital development : What implications in agribusiness digital development do government and academic has to deal and its strategy using triple helix model.

Cottagers and Indians : What should Canada's priority be; when dealing with present day problems that are the result of past decisions that went against treaty, like this one,

User Account

All Pages