BUSINESS DATA ANALYTICS FINAL PROJECT
ANALYZING A REAL WORLD DATASET
1. 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?
2. 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?
3. Start observing this dataset, and then, answer the following questions:
1) Start observing this dataset, and then, answer the following questions
2) What type of variables are listed in this dataset and which ones are quantitative variables and which ones are qualitative variables, if any?
3) Plot time series charts.
4. Start analyzing this dataset, and then, answer the following
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).
5. Report your research findings by answering the following questions:
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 interpret covariance, correlation, and least square lines.
Create an Analytical Model Using JMP.
1) Define what is the response variable and what are the factor variables in this dataset.
2) Build a decision tree.
3) Interpret the results (in details).
