# Statistics Question

Assignment Content

This week you will continue to build your course project/mock study by completing a worksheet on mean, median, and mode. Understanding how to calculate and interpret the mean, median, and mode of data is important because it allows for understanding key elements of central tendency, averages, etc. along with potential outliers or skewed data.

Don't use plagiarized sources. Get Your Custom Essay on
Statistics Question
Just from \$13/Page

Completethe

Course Project Worksheet – Mean, Median, and Mode

.

Refer to

Calculating Mean, Median, and Mode in Excel

for help with this assignment.

RES/710 v5
Course Project Worksheet – Mean, Median,
and Mode
Complete Parts A and B below.
Part A
Using the three variables you chose in Week 1, complete the following for each of your variables:
1. Using Excel, calculate the mean, median, and mode for each variable.
2. Create APA 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 prior to completing this assignment. See Calculating
Mean, Median, and Mode in Excel for the step-by-step process.
Independent Variable 1
Independent Variable 1 Name: [Enter independent variable 1 here.]
Descriptive Statistics Table:
Summary and Description:
[Enter your summary and description here.]
Independent Variable 2
Independent Variable 2 Name: [Enter independent variable 2 here.]
Descriptive Statistics Table:
Summary and Description:
[Enter your summary and description here.]
Dependent Variable
Dependent Variable Name: [Enter dependent variable here.]
Descriptive Statistics Table:
Summary and Description:
[Enter your summary and description here.]
Course Project – Mean, Median, and Mode
RES/710 v5
Page 2 of 2
Part B
Respond to the following questions.
1. What are some considerations for choosing a measure of central tendency?
2. What impact do variable types have on testing when considering central tendency?
3. Which measure of central tendency was most appropriate for each of your variables? Why?
References
[List references according to APA guidelines.]
RES/710 v5
Calculating Mean, Median, and Mode in Excel
Note: If you are using a variable in words (rather than numbers) you will need to recode your variable
prior to calculating the mean, median, and mode this week.
Recoding in Excel

Go to your first row of data.
Select the =IF function.
=IF(A2
This is the cell we want to recode.
=IF(A2, “Male”, 1, 0)
So here we are saying if A2 is male, then 1, or if not male, then 0.
Calculating Mean, Median, and Mode in Excel
RES/710 v5
Page 2 of 4
Then we need to copy and paste this for all our variables. To do so, highlight the new cell and click copy
(which will copy the formula).
Then, highlight the rest of the column and click paste.
Calculating Mean, Median, and Mode in Excel
RES/710 v5
Page 3 of 4
Now we have recoded “Sex” to binary variables (1,0).
Now we can run the descriptive statistics (mean, median, mode, etc.).
Highlight the data to include.
Select Data, then Data Analysis.
Next, select Descriptive Statistics and OK.
For input range, you’ll need to highlight the column you want to run and follow checkmarks for the rest of
the illustration below under Output options, and then click OK.
Calculating Mean, Median, and Mode in Excel
RES/710 v5
Page 4 of 4
Note: Your table will appear on a new Excel sheet.
Sample: