sta questions
a847165977
sta.docxEXAM #1 NAME_______________________________
BUS500C GRADES _____________________________
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 ( 10 points, Review PPT page 5)
2. Please list all the variables under three categories: (1) Nominal; (2) Ordinal; (3) Interval/Ratio (10 Points, Review PPT Page 8).
3. Choose any reasonable variables, please produce (1) one Frequency table; and (2) one Bar/Pie chart (10 Points, Review PPT Page 10 and page 12)
4. Choose any reasonable variable, please produce one Histogram graph and write a paragraph of your observations based on the graph (10 Points, Review PPT Page 13; 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 (20 Points, Review PPT Page 15-17; 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 (10 Points, Review PPT Page 17-18; 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 (10 Points, Review PPT Page 21-22; 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 (10 Points, Review PPT Page 24; 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 (10 Points, Review PPT Page 25)
