Based on the MS Excel file on the Happiness Survey

EXAM #1                                                     NAME_______________________________

BUS500C                                                    GRADES _____________________________

Warning: While it is an open book, please work on the exam by yourself and do not communicate with any one about the exam.

Based on the MS Excel file on the Happiness 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 ):

1. 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 )

2. 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)

3. 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)

4. 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)

5. 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)

6. 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)

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"