This week you will have an opportunity to practice working with a data set in Excel. You have
been provided a copy of the fictional survey and data set.
- Create a frequency distribution for each item on the survey. Here are two examples
that you can create in Excel. These charts come from your data set and show the ages
of the subjects in the study. It is up to you to select the type of chart that best
highlights the data. Note that the first chart shows all the raw data, where each
individual subject’s age is shown. As you can see, it does not give you much information
about the distribution of ages in your sample. Therefore, it is important to create
intervals for your data. The second chart combines age into intervals.
- Calculate the mean and standard deviation for each item. You do not need to do this for
age and gender. Only do Questions 1-12 from the survey. - Determine the median and mode for each item. You do not need to do this for age and
gender. Only do Questions 1-12 from the survey. - Run a frequency distribution, mean, and standard deviation for all the items by gender.
In other words, run the same analyses for women only and one for men only. - Copy your tables into a word document.
- For each of the items, provide the following information:
a. Describe what is being shown in the graph (mean, standard deviation, skewness)
and note the mean and median as well.
b. Interpret the analyses done on each individual item (note than a low scores on
items are not always negative).
c. State your preliminary conclusion about each of the items.
ANSWERS
Introduction
The project involves the analysis of data obtained from a survey on college education.
Question 1: Frequency distribution
Gender
[Graph hidden]
To access full answer, click on the purchase button below.