Question: Hello, I need help completing this Part A Using the three variables, complete the following for each variable: Using Excel, calculate the mean, median, and

Hello, I need help completing this

Part A

Using the three variables, complete the following for each variable:

  1. Using Excel, calculate the mean, median, and mode for each variable.
  2. Formatted tables to represent the mean, median, and mode of each variable. Copy and paste each table below.
  3. Explain/summarize the output for each variable.

Note: You might have to recode your variables before completing this. See Calculating Mean, Median, and Mode in Excel for the step-by-step process.

Independent Variable 1

Independent Variable 1 Name: Gender

(i.e., Male, Female, Other)

Descriptive Statistics Table:

[Paste table here.]

Summary and Description:

[Summary and description here.]

Independent Variable 2

Independent Variable 2 Name: Ethnicity

(i.e., White, Black or African American, Hispanic or Latino, Asian, Other)

Descriptive Statistics Table:

[Paste table here.]

Summary and Description:

[Summary and description here.]

Dependent Variable

Dependent Variable Name: Parental Education Level

(i.e., No high school diploma, High school diploma, Some college, no degree, Associate degree, Bachelor's degree, Master's degree, Doctoral degree.)

Descriptive Statistics Table:

[Paste table here.]

Summary and Description:

[Summary and description here.]

Part B

Respond to the following questions:.

  1. What are some considerations for choosing a measure of central tendency?
  2. [Response here.]
  3. What impact do variable types have on testing when considering central tendency?
  4. [Responses here.]
  5. Which measure of central tendency was most appropriate for each of the variables? Why?
  6. [Response here.]

References

[List references.]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!