Reference no: EM132330721
Assignment
Answer the following questions. Answers should be uploaded in a neat, easy-to-read Word document. Move all graphs, charts and tables to one document.
The essay parts count for about 50 percent of the points in your answer so be sure and include well-considered, detailed explanation and discussion in your own words. Use APA style references and citations if needed.
1. Be sure to read the section of the chapter relating to PCA including information about the breakfast cereals dataset. Either remove records with missing data or use the missing data utility in XLMiner.
a. Categorize each variable in terms of whether it is quantitative/numerical, ordinal, or nominal. Explain why in each case.
b. Use Excel functions or descriptive statistics menu to create a table containing the average, median, min, max, and standard deviation for each variable. Then, describe each step you took in Excel to create the table.
c. Use XLMiner or SPSS to create a histogram for each quantitative variable. Examine the histogram and summary statistics:
I. Which variables have the most variability?
II. Which variables are skewed?
III. Are there any extreme values?
d. Do side-by-side boxplots of calories in hot vs cold cereals. Explain what is shown and why it is important?
e. Create the correlation table for the quantitative variables.
I. Which pair of variables in most strongly correlated?
II. How would you reduce the number of variables based on their correlation?
III. How would the correlations change if the data was normalized first?
Why do we care which variables are strongly correlated? What is the meaning of positive vs. negative correlation?