Draw a bar chart for this distribution. Remember, Categories and titles should be correctly labeled.Is the class more liberal or more conservative, overall? Use specific numbers from your table and chart to support your answer.

Statistics 

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 data set. 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.

4. (3pts) Using question 14 (Q14) :
(a) Create a frequency table that shows counts/frequencies. Include a column count total. Remember, Categories and titles should be correctly labeled .
(b) Draw a bar chart for this distribution. Remember, Categories and titles should be correctly labeled.
(c) Is the class more liberal or more conservative, overall? Use specific numbers from your table and chart to support your answer.

5. (3 pts) Using Question 4 (Q4) :
(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 .
(d) Refer to the histogram below for this variable to discuss the features of this distribution .
(e) Find the values for the 5 number summary.
(f) Create a boxplot .

Last Completed Projects