Statistics
(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).
