Please help me with this. Here is the Research Question: How do gender and ethnicity influence the perceived academic success of first-generation college students?

Use Excel to complete frequency data runs for each of the variables. (Gender: This is a nominal level of measurement. Ethnicity: This is also a nominal level of measurement. Parental Education Level: This is an ordinal level of measurement). Then, describe each frequency table directly, referencing the data in the table.

Paste the frequency tables in the appropriate sections below. Be sure to describe the results and directly reference the table.

Frequency Table for Independent Variable 1

Independent Variable 1: Name: [Gender]

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

Frequency Table:

[Paste your frequency table here.]

Summary and Description:

[Enter your summary and description here.]

Frequency Table for Independent Variable 2

Independent Variable 2: Name: [Ethnicity]

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

Frequency Table:

[Paste your frequency table here.]

Summary and Description:

[Enter your summary and description here.]

Frequency Table for 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.)

Frequency Table:

[Paste your frequency table here.]

Summary and Description:

[Enter your summary and description here.]

Part 2: Histograms and Graphs

Using the same data, develop a histogram and assess the distribution of each variable. Consider why the distribution of the data is important.

Paste the histograms in the appropriate sections below. Be sure to describe the results and directly reference the histogram.

Histogram for Independent Variable 1

Independent Variable 1: Name: [Gender]

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

Histogram:

[Paste your histogram here.]

Summary and Description:

[Enter your summary and description here.]

Histogram for Independent Variable 2

Independent Variable 2: Name: [Ethnicity]

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

Histogram:

[Paste your histogram here.]

Summary and Description:

[Enter your summary and description here.]

Histogram for 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.)

Histogram:

[Paste your histogram here.]

Summary and Description:

[Enter a summary and description here.]

References

[List references for Part 1 and 2]