Instructions: Be sure to label the tables and graphs in a way that is understandable to someone who does not have access to the questionnaire or the raw dataset. For example, when reporting information about Question 5 from the questionnaire, use labels such as “Liberal” in the frequency table, not codes such as “1”. Format printed tables such that they are easy to read and do not overlap across several pages.
To include your Excel work in one document with your other homework problems, you may either copy and paste your output for the tables, or use the instructions for exporting your sheet, found on the Excel tutorial for the mean, median, mode and histograms.
(3pts) Using question 14 (Q14) [How would you best identify yourself politically?]:
(a) Create a frequency table that shows counts/frequencies. Include a column count total. Remember, Categories and titles should be correctly labeled (that is, categories should not be labeled “1”,”2”,”3”, etc).
(b) Draw a bar chart for this distribution. Remember, Categories and titles should be correctly labeled (that is, categories should not be labeled “1”,”2”,”3”, etc).
(c) Is the class more liberal or more conservative, overall? Use specific numbers from your table and chart to support your answer.
- (3 pts) Using Question 4 (Q4) [What is your GPA?]:
(a) Find the mean, median and standard deviation in Excel.
(b) Compare the mean vs. the median and discuss what this says about the shape of the variable’s distribution.
(c) Interpret the standard deviation (describe what the standard deviation measures and what it tells you about your variable).
(d) Refer to the histogram below for this variable to discuss the features of this distribution (specifically, you should describe all of the following: (1) shape, (2) center, (3) spread and any possible (4) outliers).
(e) Find the values for the 5 number summary.
(f) Create a boxplot (stem and whisker plot).
