Report on Statistical Analysis of Asian and French Cuisine Dataset

Running head: REPORT ON STATISTICAL ANALYSIS
Report On Statistical Analysis
Name of the Student:
Name of the University:
Author Note:

1REPORT ON STATISTICAL ANALYSIS
Table of Contents
Introduction......................................................................................................................................2
Discussion........................................................................................................................................2
Descriptive Statistics...................................................................................................................2
Multiple Linear Regression.........................................................................................................4
Graphical Representation of the Data..........................................................................................6
Conclusion.......................................................................................................................................7
References........................................................................................................................................9

2REPORT ON STATISTICAL ANALYSIS
Introduction
The report is based on the statistical analysis of a random sample of a secondary data of
69 observations, collected from taste.com.au website in 2018. The dataset consist of information
about Asian and French Cuisine and there are 3 categorical variables (Recipe flavor, Cuisine
origin, and Recipe difficulty) and 5 quantitative variables (Recipe description number of words,
Prep time, Cook time, Total time, and ingredient count). The data is statistically analysed using
MS Excel and then all the conclusions are summarised.
Discussion
The dataset is first recorded in the Excel sheet and then the data is segregated on the basis
of the type of Cuisine Origin. There are two values of the Cuisine Origin variable which are
Asian cuisine and French cuisine. Thus, the dataset is divided into two groups and the two
separate groups of data are analysed using the Data Analysis ToolPak in MS Excel (Carlberg
2014). There are 35 observations of Asian Cuisine and 36 observations of French Cuisine.
Descriptive Statistics
The Descriptive Statistics of “Total Time (Minutes)” variable are evaluated for both the
datasets of the two groups by clicking the “Descriptive Statistics” option of “Data Analysis”
menu from the Data tab (Walkenbach 2013). It provides a thorough analysis of the data,
providing the highest and smallest values, measures of location (Mean, Median, and Mode) and
measures of dispersion (Standard deviation, Variance, Skewness, Kurtosis, and Range)
(Wildemuth 2016).
The output of the descriptive statistics of Asian Cuisine data is shown below-

3REPORT ON STATISTICAL ANALYSIS
Total Time (Minutes)
Mean
52.1142
9
Standard Error
7.55648
4
Median 35
Mode 25
Standard Deviation
44.7047
6
Sample Variance
1998.51
6
Kurtosis
3.35639
9
Skewness
1.94272
3
Range 180
Minimum 0
Maximum 180
Sum 1824
Count 35
Largest(1) 180
Smallest(1) 0
Confidence Level (95.0%)
15.3566
2
The above output shows that the Median is less than the Mean value. The sample variance is
1998.516. A large value of sample variance indicates that the data values are spread from each
other and from the mean value (McCracken and Chakraborti 2013). The largest value is 180 and
the smallest value is 0. The kurtosis value of 3.3563 indicates that the distribution of the dataset
is “Leptokurtic” and the dataset is thinner than the normal distribution (Ho and Yu 2015). which
means that the dataset has heavy tails. The Skewness is 1.942723 which suggests that dataset is
highly skewed (Ho and Yu 2015).
The output of the descriptive statistics of the Total cooking Time variable of the French Cuisine
is displayed below.
Total Time (Minutes)