Reference no: EM131492150

Assignment

Using a data set from Resources.

Part I

Open this dataset in Excel and define the following:

1) What does this dataset represent?
2) How many variables and cases there are in this dataset?

After understanding this dataset define your main goals, such as:

1) What are you planning to analyze?
2) What are your hypotheses?

3) Are there a lot of missing data inside this dataset? Which variables have missing data?

Part II

1) What type of variables are listed in this dataset and which ones are quantitative variables and which ones are qualitative variables if any?
2) Plot time series charts.

Part III

1) Summarize this dataset by using descriptive statistics such as tabular and graphical methods (i.e., Frequency distributions, bar charts, pie charts, Pareto Charts (if applicable), histograms, frequency polygons, ogives, contingency tables, and scatter plots).

Part IV

1) Describe this dataset by using central tendency.
2) Compute and interpret the range, variance, and standard deviation.
3) Use empirical rules to describe variations in this dataset.
4) Compute and interpret percentiles, quartiles, and box-and-whiskers displays.
5) Compute and explain covariance, correlation, and least square lines.

Attachment:- Resources.rar