Statistics homework help

/in /by

Based on the MS Excel file on the Entrepreneurship Survey, please see the data in the Excel file and provide the answers to the following (The final submission can either in Excel or in this MS Word file; graphs can be formatted using computer programs or images drawn by hand. The original questionnaire is in the attached pdf file. Only some of the questions of the original survey are included in the Excel file (Q3-14 and Q30-40. Original Age and Education Year are given): 

  1. Please list all the variables under two categories: (1) Quantitative variables; (2) Qualitative variables
  2. Please list all the variables under three categories: (1) Nominal; (2) Ordinal; (3) Interval/Ratio
  3. Choose any reasonable variables, please produce  (1) one Frequency table;  and (2) one Bar/Pie chart
  4. Choose any reasonable variable, please produce  one  Histogram  graph and write a paragraph of your observations based on the graph ( hint: only Interval/Ratio are meaningfully appropriate for histogram )
  5. Please choose any reasonable variable and calculate its (1) Mean, (2) Median, (3) Mode, (4) Range (5) and Variance ( hint: only Interval/Ratio are meaningfully appropriate for such descriptive statistics)
  6. Choose any reasonable variable,  please calculate its Standard Deviation and draw a graph for its potential population distribution using the Empirical Rule ( hint: only Interval/Ratio are meaningfully appropriate for such descriptive statistics)
  7. Choose any reasonable variable,  please calculate its quartiles and draw a Box plot ( hint: only Interval/Ratio are meaningfully appropriate for such descriptive statistics)
  8. Choose any reasonable variable,  please draw a Scatter plot and write a paragraph of your observations based on the graph (hint: only Interval/Ratio are meaningfully appropriate for such descriptive statistics. For ordinal variables with 5 or more scales, such as Q3-14, you can treat them as interval variables for this question).
  9. Choose any reasonable variable,  please draw a Contingency table and write a paragraph of your observations based on the table