Explore and summarize the cereals.xls dataset

Assignment Help Other Subject

Reference no: EM13942436

In this question you will explore and summarize the cereals.xls dataset.

(a)For each of the 16 variables in the dataset, state whether the variable is categorical (qualitative) or numerical (quantitative).For categorical variables, state whether the variable is nominal or ordinal.

(b)Create a table that summarizes the mean, median, min, max, standard deviation, and coefficient of variation for each of the quantitative variables.

(c)Examine the summary statistics for the eight variables that reflect the nutritional value of the cereals (calories through potassium). Use the coefficient of variation to find the three nutritional variables with the largest variability (we cannot use the standard deviation because the variables have different units). Generate histograms and boxplots for these three variables.

(i)Describe the distributions.Are the variables skewed?
(ii)Are there any outliers for these variables?
(d)Plot a side-by-side boxplot comparing the calories in hot versus cold cereals. What does this plot show us?
(e)What type of plot would you use to compare calories to rating?What type of plot would you use to compare type to rating?Generate the plots and describe the relationship between the variables.
(f)Generate the correlation matrix for the quantitative variables.
(i)Which variable has the strongest positive correlation with calories?Which variable has the strongest negative correlation with calories?
(ii)What percentage of the variance in these three variables would we capture if we replace the variables with thei

Reference no: EM13942436

Questions Cloud

Girtin hitched bakery makes big time wedding cakes : Girtin Hitched Bakery makes big time wedding cakes to order. The company has a three activity cost pool activity-based costing system. The activity rate for the Size-Related activity cost pool is $1.28 per guest.

Details of at least two organisations using erp systems : Your explanation should include definitions and details of at least two organisations using ERP systems and the benefits they achieved.

Use of sdlc and agile development approaches : Compare the use of SDLC and agile development approaches. Justify your choice of your selected approach to systems development.

Topic-king abdullah scholarship program : Specific Purpose: To inform to the audience about king Abdullah scholarship programand what are the goals of it.

Explore and summarize the cereals.xls dataset : For each of the 16 variables in the dataset, state whether the variable is categorical (qualitative) or numerical (quantitative).For categorical variables, state whether the variable is nominal or ordinal.

Explain the concept of files and streams : Every seven-letter phone number corresponds to many different seven-letter words. Unforte. nately, most of these words represent unrecognizable juxtapositions of letters.

Analyse what meant by moral values in mid-victorian britain : 'Victorian moral values were shared by all.' Analyse what was meant by 'moral values' in mid-Victorian Britain, with particular reference to the lives of the working classes.

Analyse the contributions of the early greeks : Legal Theory 1000 word Essay Answer one of the following three questions 1. Analyse the contributions of the early Greeks, the Romans and the early Christians to the concept of natural law and natural rights.

Why is a logical linear sequence useful : Why is it logical to write test items or assessments before producing instructional strategies? Why is a logical linear sequence useful, even though in practice instructional design components may be more concurrent

User Account

All Pages