Create a histogram for each quantitative variable

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?

Reference no: EM132330721

Questions Cloud

Advise each of the parties of their rights in contract law : Kent Institute Australia - BO1BLAW204 Business Law Assignment - Advise each of the parties of their rights in Contract law

Human resources for a small rural acute care hospital : You are the newly-hired director of human resources for a small rural acute care hospital. You've been on the job for just 3 months and have spent that time get

Evaluate any competitors existing production : Evaluate any competitors' existing production in the chosen country. Assess sales forecasts in the selected country by using the Federal Reserve of St. Louis's.

Could jeremy bentham justify the continued existence : You work in logistics at Faker, Inc., an import company that buys counterfeit items from suppliers in China. Faker brings these items into the US and sells them

Create a histogram for each quantitative variable : Create a table containing the average, median, min, max, and standard deviation for each variable. Describe each step you took in Excel to create the table.

Entrepreneur and a small business owner : Differentiate between an entrepreneur and a small business owner. Discuss how Blodgett demonstrated entrepreneurial traits.

Current external environment factors in health industry : Explain how you would integrate current external environment factors in the health industry. Translate your interpretation into a critical list of action items

Approaches to managing people in organizations : Management involves the exercise of formal authority over the work of other people. Evaluate the importance of both of these approaches to managing people in or

Approach on leading the turnaround process : Critique Oliveira's approach on leading the turnaround process. What would you have done differently?

User Account

All Pages