Question
Conclude a summary of each variable (number of barrels sold and gross annual sales) in the below data set. Use histograms, descriptive statistics, and Empirical
Conclude a summary of each variable (number of barrels sold and gross annual sales) in the below data set. Use histograms, descriptive statistics, and Empirical rule to gain insight and detect data patterns.Your answer should refer to histograms, Empirical rule, and descriptive statistics (mean, median, mode, standard deviation, skewness, and kurtosis) to explain detected data patterns (i.e. increasing/decreasing/stable trends, whether the data is normally distributed based on Empirical rule, ...). Please show how to do on excel step by step:
2005 Data:
Jan.=196.5 barrels sold; gross sales =40,458
Feb.193.2 barrels sold; gross sales = 35,615
March.229.7 barrels sold; gross sales =43,306
2006 Data:
Jan.=243.2 barrels sold; gross sales =53,093
Feb.239.9 barrels sold; gross sales = 48,819
March.241.3 barrels sold; gross sales =49,782
2007 Data:
Jan.=290.8 barrels sold; gross sales =62,898
Feb.254.8 barrels sold; gross sales = 53,912
March.267.5 barrels sold; gross sales =56,477
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started