Hello, I need help completing this

Part A

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

1. Use Excel, to calculate the mean, median, and mode for each variable.
2. Format tables to represent the mean, median, and mode of each variable. Copy and paste each table below.
3. Then 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.]